/// <summary>
/// Вернуть ID станции системы КИС
/// </summary>
/// <param name="id_station"></param>
/// <returns></returns>
public int?GetIDStationsKis(int id_station)
{
STATIONS st = GetStations(id_station);
if (st != null)
{
return(st.id_ora);
}
return(null);
}
/// <summary>
/// Вернуть ID станции системы Railcars
/// </summary>
/// <param name="id_station_kis"></param>
/// <returns></returns>
public int?GetIDStationsOfKis(int id_station_kis)
{
STATIONS st = GetStationsOfKis(id_station_kis);
if (st != null)
{
return(st.id_stat);
}
return(null);
}
/// <summary>
/// Удалить
/// </summary>
/// <param name="id_stat"></param>
/// <returns></returns>
public STATIONS DeleteSTATIONS(int id_stat)
{
STATIONS dbEntry = context_edit.STATIONS.Find(id_stat);
if (dbEntry != null)
{
context_edit.STATIONS.Remove(dbEntry);
context_edit.SaveChanges();
}
return(dbEntry);
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="STATIONS"></param>
/// <returns></returns>
public int SaveSTATIONS(STATIONS STATIONS)
{
STATIONS dbEntry;
if (STATIONS.id_stat == 0)
{
dbEntry = new STATIONS()
{
id_stat = STATIONS.id_stat,
name = STATIONS.name,
id_ora = STATIONS.id_ora,
outer_side = STATIONS.outer_side,
is_uz = STATIONS.is_uz,
};
context_edit.STATIONS.Add(dbEntry);
}
else
{
dbEntry = context_edit.STATIONS.Find(STATIONS.id_stat);
if (dbEntry != null)
{
dbEntry.id_stat = STATIONS.id_stat;
dbEntry.name = STATIONS.name;
dbEntry.id_ora = STATIONS.id_ora;
dbEntry.outer_side = STATIONS.outer_side;
dbEntry.is_uz = STATIONS.is_uz;
}
}
try
{
context_edit.SaveChanges();
}
catch (Exception e)
{
return(-1);
}
return(dbEntry.id_stat);
}
public int SaveStations(STATIONS stations)
{
return(rep_st.SaveSTATIONS(stations));
}
/// <summary>
/// Станция пренадлежит АМКР
/// </summary>
/// <param name="id_stat"></param>
/// <returns></returns>
public bool IsAMKR(int id_stat)
{
STATIONS stat = GetStations(id_stat);
return((stat != null & stat.is_uz == 0) ? true : false);
}
