IBE.SQL.EliteDBIO.CopyEDStationToDataRow C# (CSharp) Method

CopyEDStationToDataRow() private method

copies the data from a "EDStation"-object to a Datarow from table "tbStations"
private CopyEDStationToDataRow ( EDStation StationObject, DataRow StationRow, System.Boolean OwnData = false, int StationID = null, System.Boolean insertUnknown = false ) : void
StationObject IBE.EDDB_Data.EDStation
StationRow System.Data.DataRow
OwnData System.Boolean
StationID int
insertUnknown System.Boolean
return void
        private void CopyEDStationToDataRow(EDStation StationObject, DataRow StationRow, Boolean OwnData = false, int? StationID = null, Boolean insertUnknown = false)
        {
            try
            {

                StationRow["id"]                    = StationID == null ? DBConvert.From(StationObject.Id) : StationID;
                StationRow["stationname"]           = DBConvert.From(StationObject.Name);
                StationRow["system_id"]             = DBConvert.From(StationObject.SystemId);
                StationRow["max_landing_pad_size"]  = DBConvert.From(StationObject.MaxLandingPadSize);
                StationRow["distance_to_star"]      = DBConvert.From(StationObject.DistanceToStar);
                StationRow["faction"]               = DBConvert.From(StationObject.Faction);
                StationRow["government_id"]         = DBConvert.From(BaseTableNameToID("government", StationObject.Government, insertUnknown));
                StationRow["allegiance_id"]         = DBConvert.From(BaseTableNameToID("allegiance", StationObject.Allegiance, insertUnknown));
                StationRow["state_id"]              = DBConvert.From(BaseTableNameToID("state", StationObject.State, insertUnknown));
                StationRow["stationtype_id"]        = DBConvert.From(BaseTableNameToID("stationtype", StationObject.Type, insertUnknown));
                StationRow["has_blackmarket"]       = DBConvert.From(StationObject.HasBlackmarket);
                StationRow["has_market"]            = DBConvert.From(StationObject.HasMarket);
                StationRow["has_refuel"]            = DBConvert.From(StationObject.HasRefuel);
                StationRow["has_repair"]            = DBConvert.From(StationObject.HasRepair);
                StationRow["has_outfitting"]        = DBConvert.From(StationObject.HasOutfitting);
                StationRow["has_shipyard"]          = DBConvert.From(StationObject.HasShipyard);
                StationRow["updated_at"]            = DBConvert.From(DateTimeOffset.FromUnixTimeSeconds(StationObject.UpdatedAt).DateTime);
                StationRow["is_changed"]            = OwnData ? DBConvert.From(1) : DBConvert.From(0);
                StationRow["visited"]               = DBConvert.From(0);
                StationRow["shipyard_updated_at"]   = DBConvert.From(DateTimeOffset.FromUnixTimeSeconds(StationObject.Shipyard_UpdatedAt.GetValueOrDefault()).DateTime);
                StationRow["outfitting_updated_at"] = DBConvert.From(DateTimeOffset.FromUnixTimeSeconds(StationObject.Outfitting_UpdatedAt.GetValueOrDefault()).DateTime);
                StationRow["market_updated_at"]     = DBConvert.From(DateTimeOffset.FromUnixTimeSeconds(StationObject.Market_UpdatedAt.GetValueOrDefault()).DateTime);
                StationRow["type_id"]               = DBConvert.From(StationObject.TypeID);
                StationRow["has_commodities"]       = DBConvert.From(StationObject.HasCommodities); 
                StationRow["is_planetary"]          = DBConvert.From(StationObject.IsPlanetary);

            }
            catch (Exception ex)
            {
                throw new Exception("Error while copying station data", ex);
            }
        }