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