/// <summary>
/// Добавить или править
/// </summary>
/// <param name="TUPIKI"></param>
/// <returns></returns>
public int SaveTUPIKI(TUPIKI tupiki)
{
TUPIKI dbEntry;
if (tupiki.id_tupik == 0)
{
dbEntry = new TUPIKI()
{
id_tupik = 0,
id_ora = tupiki.id_ora,
name = tupiki.name
};
context.TUPIKI.Add(dbEntry);
}
else
{
dbEntry = context.TUPIKI.Find(tupiki.id_tupik);
if (dbEntry != null)
{
dbEntry.id_ora = tupiki.id_ora;
dbEntry.name = tupiki.name;
}
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "SaveTUPIKI", eventID);
return(-1);
}
return(dbEntry.id_tupik);
}
public void WL(TUPIKI t)
{
if (t != null)
{
Console.WriteLine("id_tupik: {0}, id_ora: {1}, name: {2}",
t.id_tupik, t.id_ora, t.name);
}
else
{
Console.WriteLine("= NULL");
}
}
/// <summary>
/// Получить id системы RailCars по id системы КИС
/// </summary>
/// <param name="id_tupik_kis"></param>
/// <returns></returns>
public int?GetIDTupikOfKis(int id_tupik_kis)
{
TUPIKI tp = GetTupikOfKis(id_tupik_kis);
if (tp != null)
{
return(tp.id_tupik);
}
else
{
return(null);
}
}
/// <summary>
/// Удалить
/// </summary>
/// <param name="id_tupik"></param>
/// <returns></returns>
public TUPIKI DeleteTUPIKI(int id_tupik)
{
TUPIKI dbEntry = context.TUPIKI.Find(id_tupik);
if (dbEntry != null)
{
context.TUPIKI.Remove(dbEntry);
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "DeleteTUPIKI", eventID);
return(null);
}
}
return(dbEntry);
}
public void Test_RC_Tupiki_Save_Read_Delete()
{
TUPIKI s1 = new TUPIKI()
{
id_tupik = 0,
name = "Тест-1",
id_ora = 3
};
int id_new = tupik.SaveTUPIKI(s1);
WL(tupik.GetTupik(id_new));
TUPIKI s2 = new TUPIKI()
{
id_tupik = id_new,
name = "Тест-2",
id_ora = 4
};
int id_ch = tupik.SaveTUPIKI(s2);
WL(tupik.GetTupik(id_ch));
TUPIKI del = tupik.DeleteTUPIKI(id_ch);
WL(del);
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="TUPIKI"></param>
/// <returns></returns>
public int SaveTUPIKI(TUPIKI tupiki)
{
return(rep_tp.SaveTUPIKI(tupiki));
}