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)); }