/// <summary>
/// Получить id станции по коду станции
/// </summary>
/// <param name="code_cs"></param>
/// <returns></returns>
public int DefinitionIDStation(int code_cs)
{
ReferenceStation station = g_ref.GetReferenceStationOfCode(code_cs);
if (station != null)
{
return(station.IDStation);
}
Code_Station code_station = rw_ref.GetStationsOfCodeCS(code_cs);
if (code_station == null)
{
return(0);
}
Code_InternalRailroad code_ir = rw_ref.GetInternalRailroads(code_station.IDInternalRailroad != null? (int)code_station.IDInternalRailroad:0);
Code_State code_st = rw_ref.GetState(code_ir != null ? code_ir.IDState: 0);
int res = g_ref.SaveReferenceStation(new ReferenceStation()
{
IDStation = 0,
Name = code_station.Station + (code_ir != null ? " " + code_ir.Abbr + " ж/д" : "") + (code_st != null ? " " + code_st.ABB_RUS : ""),
Station = code_station.Station,
InternalRailroad = code_ir != null ? code_ir.InternalRailroad : "-",
IR_Abbr = code_ir != null ? code_ir.Abbr : "-",
NameNetwork = code_st != null ? code_st.NameNetwork : "-",
NN_Abbr = code_st != null ? code_st.ABB_RUS : "-",
CodeCS = code_cs
});
if (res > 0)
{
return(res);
}
return(0);
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="ReferenceCountry"></param>
/// <returns></returns>
public int SaveReferenceStation(ReferenceStation ReferenceStation)
{
ReferenceStation dbEntry;
if (ReferenceStation.IDStation == 0)
{
dbEntry = new ReferenceStation()
{
IDStation = 0,
Name = ReferenceStation.Name,
Station = ReferenceStation.Station,
InternalRailroad = ReferenceStation.InternalRailroad,
IR_Abbr = ReferenceStation.IR_Abbr,
NameNetwork = ReferenceStation.NameNetwork,
NN_Abbr = ReferenceStation.NN_Abbr,
CodeCS = ReferenceStation.CodeCS
};
context.ReferenceStation.Add(dbEntry);
}
else
{
dbEntry = context.ReferenceStation.Find(ReferenceStation.IDStation);
if (dbEntry != null)
{
dbEntry.Name = ReferenceStation.Name;
dbEntry.Station = ReferenceStation.Station;
dbEntry.InternalRailroad = ReferenceStation.InternalRailroad;
dbEntry.IR_Abbr = ReferenceStation.IR_Abbr;
dbEntry.NameNetwork = ReferenceStation.NameNetwork;
dbEntry.NN_Abbr = ReferenceStation.NN_Abbr;
dbEntry.CodeCS = ReferenceStation.CodeCS;
}
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "SaveReferenceStation", eventID);
return(-1);
}
return(dbEntry.IDStation);
}
/// <summary>
/// Удалить
/// </summary>
/// <param name="IDCountry"></param>
/// <returns></returns>
public ReferenceStation DeleteReferenceStation(int IDCountry)
{
ReferenceStation dbEntry = context.ReferenceStation.Find(IDCountry);
if (dbEntry != null)
{
context.ReferenceStation.Remove(dbEntry);
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "DeleteReferenceStation", eventID);
return(null);
}
}
return(dbEntry);
}
/// <summary>
/// Добавить или изменить строку станции
/// </summary>
/// <param name="ReferenceStation"></param>
/// <returns></returns>
public int SaveReferenceStation(ReferenceStation ReferenceStation)
{
return(rep_station.SaveReferenceStation(ReferenceStation));
}
