public Capacity() { try { rw = new Update_pstgr_from_Ora <Crp>(); Parallel.Invoke(async() => { Crp_list = await PSTGR_CRP(); if (Crp_list.Count == 0) { Updated_on_init = true; await Ora_CRP(); } else { Crp_list.Sort(); Updated_on_init = false; } }); } catch (Exception e) { Loger.Log("Błąd Inicjalizacji obiektu CRP:" + e); } }
public Cust_orders() { try { rw = new Update_pstgr_from_Ora <Orders_row>(); Parallel.Invoke(async() => { Orders_list = await Get_PSTGR_List(); if (Orders_list.Count == 0) { Updated_on_init = true; await Update_cust(); } else { Orders_list.Sort(); Updated_on_init = false; } }); } catch (Exception e) { Loger.Log("Błąd Inicjalizacji obiektu zamówienia klienta:" + e); } }
/// <summary> /// Update table with Calendar Days /// </summary> /// <returns></returns> public async Task <int> Update_calendar_table(string calendar_id) { try { if (calendar_id != "") { Update_pstgr_from_Ora <Calendar> rw = new Update_pstgr_from_Ora <Calendar>(); List <Calendar> list_ora = new List <Calendar>(); List <Calendar> list_pstgr = new List <Calendar>(); var dataObject = new ExpandoObject() as IDictionary <string, Object>; ORA_parameters Command_prepare = new ORA_parameters(); Parallel.Invoke(async() => { list_ora = await rw.Get_Ora("" + "SELECT calendar_id, counter, to_date(work_day) work_day, day_type, working_time, working_periods, objid, objversion " + "FROM ifsapp.work_time_counter " + "WHERE CALENDAR_ID='SITS' ", "Calendar_ORA"); list_ora.Sort(); }, async() => { list_pstgr = await rw.Get_PSTGR("Select * from work_cal WHERE CALENDAR_ID='SITS' order by counter", "Calendar_Pstgr"); list_pstgr.Sort(); }); Changes_List <Calendar> tmp = rw.Changes(list_pstgr, list_ora, new[] { "id" }, "id", "id"); list_ora = null; list_pstgr = null; return(await PSTRG_Changes_to_dataTable(tmp, "work_cal", "id", null, null)); } else { throw new Exception("Service Calendar not set in settings.xml file "); } } catch (Exception e) { Loger.Log("Błąd importu CRP:" + e); return(1); } }