internal static void ulozDavkuDoDB(Session sesna, int EXT_APP_KOD, ref PLATCI_RESP resp) { try { DBUtil dbu = new DBUtil(sesna); MyUnitOfWork uow = new MyUnitOfWork(sesna.DataLayer); foreach (PLATCE2 item in resp.PLATCI) { P_ODPADY_EULEVY pul = new P_ODPADY_EULEVY(uow); pul.EUL_ID = dbu.LIZNI_SEQ("P_ODPADY_EULEVY_ID"); pul.DAVKA = resp.DAVKA_ID; pul.EA = EXT_APP_KOD; pul.POPL = resp.RGP_POPLATEK; pul.PER = resp.RGP_PER; pul.KC_ZAPER = item.POPLATNIK.RGP_KCROK; pul.VS = item.POPLATNIK.VS; pul.ZPRAC = "E"; uow.CommitTransaction(); uow.Dispose(); uow = new MyUnitOfWork(sesna.DataLayer); } } catch (Exception e) { resp.result = Result.ERROR; resp.status = Status.ERROR; resp.ERRORMESS = "DejPlatce2 - Chyba při ukládání dávky" + e.Message; } }
internal static void smazStarouDavku(Session sesna, int extApp, string perioda, out bool dataSmazana, ref PLATCI_RESP resp) { dataSmazana = false; try { DBVal dbval = new DBVal(sesna); sesna.ExecuteNonQuery("delete from P_ODPADY_EULEVY where ZPRAC = 'A' and EA = " + extApp.ToString() + " and ENTRYDATE < " + dbval.dbv.getCurrentDateTimeText + "-750"); sesna.ExecuteNonQuery("delete from P_ODPADY_EULEVY where EA = " + extApp.ToString() + " and ZPRAC = 'E'" + " and PER = '" + perioda + "'"); dataSmazana = true; } catch (Exception e) { resp.result = Result.ERROR; resp.status = Status.ERROR; resp.ERRORMESS = string.Format("Odmazání starých dat neproběhlo. \n {0}", e.Message); } }