public static List <Row> Filter_Shifts(int mouth, int week) { List <Row> filterShifts = new List <Row>(); Row shift; DateTime time, start, end; foreach (Row row in shifts) { try { time = DateTime.Parse(row.GetColValue("day").ToString()); start = DateTime.Parse(row.GetColValue("start_shift").ToString()); end = DateTime.Parse(row.GetColValue("end_shift").ToString()); if (time.Month == mouth) { if (week == -1 || (week + 1) * 7 > time.Day && week * 7 < time.Day) { shift = new Row(); shift.AddColume(new Col("day", $"{time.Day}/{time.Month}")); shift.AddColume(new Col("hours", end.Hour - start.Hour)); filterShifts.Add(shift); } } } catch { } } return(filterShifts); }
public static List <Row> Filter_Shifts(DateTime value, int id) { List <Row> filterShifts = new List <Row>(); Row shift; DateTime time, start, end; foreach (Row row in Assets.shifts) { try { if (id != -1 && row.GetColValue("id_worker").ToString() != id.ToString()) { continue; } time = DateTime.Parse(row.GetColValue("day").ToString()); start = DateTime.Parse(row.GetColValue("start_shift").ToString()); end = DateTime.Parse(row.GetColValue("end_shift").ToString()); if (time.Month == value.Month && time.Year == value.Year) { shift = new Row(); shift.AddColume(new Col("id", row.GetColValue("id_worker"))); shift.AddColume(new Col("day", $"{time.Day}/{time.Month}")); shift.AddColume(new Col("hours", end.Hour - start.Hour)); filterShifts.Add(shift); } } catch (Exception err) { } } return(Organize(filterShifts)); }
public static List <Row> getObjects(string command) { List <Row> Rows = new List <Row>(); try { ConnectionState(true); OleCommand = new OleDbCommand(command, Connection); Reader = OleCommand.ExecuteReader(); while (Reader.Read()) { Row row = new Row(); var table = Reader.GetSchemaTable(); var nameCol = table.Columns["ColumnName"]; var fields = new List <string>(); foreach (DataRow r in table.Rows) { fields.Add(r[nameCol].ToString()); } for (int i = 0; i < Reader.FieldCount; i++) { row.AddColume(new Col(fields[i], Reader[i].ToString())); } Rows.Add(row); } Reader.Close(); ConnectionState(false); return(Rows); } catch { ConnectionState(false); return(null); } }
public static bool updateWorker() { Row columes = new Row( ); Condition con = new Condition("id", int.Parse(worker.GetColValue("id").ToString())); columes.AddColume(new Col("password", worker.GetColValue("password"))); return(Access.Execute(SQL_Queries.Update("workers", columes.GetColumes(), con))); }