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