public IncomingDataTable Get_IncomingDataTable(string nameTable, int year, int month, int day)
{
IncomingDataTable idd = new IncomingDataTable();
SQLiteDataReader dr = new SQLiteCommand($"select * from '{nameTable}' where {paramForUsersTable[2]}={year} and {paramForUsersTable[1]}={month} and {paramForUsersTable[0]}={day} ", db_connection).ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
idd.daynumber = new DateTime(Convert.ToInt32(dr.GetValue(3)), Convert.ToInt32(dr.GetValue(2)), Convert.ToInt32(dr.GetValue(1)));
idd.startday = new DateTime(Convert.ToInt32(dr.GetValue(3)),
Convert.ToInt32(dr.GetValue(2)), Convert.ToInt32(dr.GetValue(1)), Convert.ToInt32(dr.GetValue(4)), Convert.ToInt32(dr.GetValue(5)), 0);
idd.endday = new DateTime(Convert.ToInt32(dr.GetValue(3)),
Convert.ToInt32(dr.GetValue(2)), Convert.ToInt32(dr.GetValue(1)), Convert.ToInt32(dr.GetValue(6)), Convert.ToInt32(dr.GetValue(7)), 0);
idd.city = Convert.ToString(dr.GetValue(8));
idd.specCheck = Convert.ToString(dr.GetValue(9));
idd.achiv = Convert.ToString(dr.GetValue(10));
if (idd.isHoliday = true || idd.specCheck == "ком.")
{
idd.Work_time = idd.endday - idd.startday;
}
else
{
idd.Work_time = idd.endday - idd.startday - new TimeSpan(0, 48, 0);
}
}
}
dr.Close();
return(idd);
}
public List <IncomingDataTable> GetOneTabelData(string PathToFile, out string tablenumber)
{
IncomingDataTable odd = new IncomingDataTable();
JavaScriptSerializer serializer = new JavaScriptSerializer();
string json = System.IO.File.ReadAllText(PathToFile);
List <IncomingDataTable> Rows = serializer.Deserialize <List <IncomingDataTable> >(json);
Rows.ForEach((j) => { j.daynumber = j.daynumber.ToLocalTime(); j.startday = j.startday.ToLocalTime(); j.endday = j.endday.ToLocalTime(); });
tablenumber = Rows[0].tabelNumber;
return(Rows);
}