public void Test_SUD_RC_Gruzs()
{
RC_Gruzs gruz = new RC_Gruzs();
GRUZS w1 = new GRUZS()
{
id_gruz = 0, name = "тест1", name_full = "full_test1", id_ora = 0, id_ora2 = 0,
};
int id_new = gruz.SaveGruzs(w1);
Test_RC_Gruzs(id_new);
GRUZS w2 = new GRUZS()
{
id_gruz = id_new,
name = "тест2",
name_full = "full_test2",
id_ora = null,
id_ora2 = null,
};
int id_ch = gruz.SaveGruzs(w2);
Test_RC_Gruzs(id_ch);
GRUZS del = gruz.DeleteGruzs(id_ch);
WL(del);
}
/// <summary>
/// Получить ID груза по коду ЕТ СНГ
/// </summary>
/// <param name="etsng"></param>
/// <returns></returns>
public int?GetIDGruzsToETSNG(int?etsng)
{
GRUZS gr = GetGruzsToETSNG(etsng);
if (gr != null)
{
return(gr.id_gruz);
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="id_gruz_prom_kis"></param>
/// <param name="id_gruz_vag_kis"></param>
/// <returns></returns>
public int?GetIDGruzs(int?id_gruz_prom_kis, int?id_gruz_vag_kis)
{
GRUZS gr = GetGruzs(id_gruz_prom_kis, id_gruz_vag_kis);
if (gr != null)
{
return(gr.id_gruz);
}
return(null);
}
/// <summary>
/// Удалить
/// </summary>
/// <param name="id_gruz"></param>
/// <returns></returns>
public GRUZS DeleteGRUZS(int id_gruz)
{
GRUZS dbEntry = context_edit.GRUZS.Find(id_gruz);
if (dbEntry != null)
{
context_edit.GRUZS.Remove(dbEntry);
context_edit.SaveChanges();
}
return(dbEntry);
}
//public void Test_RC_OwnersContries(int id_own_country)
//{
// RC_OwnersContries oс = new RC_OwnersContries();
// WL(oс.GetOwnersContries(id_own_country));
//}
//public void Test_RC_OwnersContriesToKis(int id_ora)
//{
// RC_OwnersContries oс = new RC_OwnersContries();
// WL(oс.GetOwnersContriesToKis(id_ora));
//}
public void WL(GRUZS t)
{
if (t != null)
{
Console.WriteLine("id_gruz: {0}, name: {1}, name_full: {2}, id_ora: {3}, id_ora2: {4}",
t.id_gruz, t.name, t.name_full, t.id_ora, t.id_ora2);
}
else
{
Console.WriteLine("= NULL");
}
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="GRUZS"></param>
/// <returns></returns>
public int SaveGRUZS(GRUZS GRUZS)
{
GRUZS dbEntry;
if (GRUZS.id_gruz == 0)
{
dbEntry = new GRUZS()
{
id_gruz = 0,
name = GRUZS.name,
name_full = GRUZS.name_full,
id_ora = GRUZS.id_ora,
id_ora2 = GRUZS.id_ora2,
ETSNG = GRUZS.ETSNG
};
context_edit.GRUZS.Add(dbEntry);
}
else
{
dbEntry = context_edit.GRUZS.Find(GRUZS.id_gruz);
if (dbEntry != null)
{
dbEntry.name = GRUZS.name;
dbEntry.name_full = GRUZS.name_full;
dbEntry.id_ora = GRUZS.id_ora;
dbEntry.id_ora2 = GRUZS.id_ora2;
dbEntry.ETSNG = GRUZS.ETSNG;
}
}
try
{
context_edit.SaveChanges();
}
catch (Exception e)
{
return(-1);
}
return(dbEntry.id_gruz);
}
/// <summary>
/// Добавить или удалить
/// </summary>
/// <param name="gruzs"></param>
/// <returns></returns>
public int SaveGruzs(GRUZS gruzs)
{
return(rep_gr.SaveGRUZS(gruzs));
}
