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))); }
public static bool UpdateTreatment(List <Col> values) { if (Selected_Treatment == -1) { return(false); } Condition condition = new Condition("id", int.Parse(GetValue("id"))); return(Access.Execute(SQL_Queries.Update("treatments", values, condition))); }
public static void Exit(int id) { string query; foreach (Row row in Assets.shifts) { if (row.GetColValue("end_shift").ToString() == "not") { row.UpdateColume(new Col("end_shift", DateTime.Today.ToShortTimeString())); query = SQL_Queries.Update("shifts", row.GetColumes(), new Condition("shift", row.GetColValue("shift"))); Access.Execute(query); } } }
public static bool UpdateUser(List <Col> update) { bool execute = Access.Execute(SQL_Queries.Update("people", update, new Condition("id", user_id))); if (execute) { foreach (Col col in update) { if (col.GetField() == "id") { user_id = (int)(col.GetValue()); break; } } user.UpdateColume(update); GetUserInfo(); } return(execute); }
public static bool UpdateCar(List <Col> update, int number) { MessageBox.Show(SQL_Queries.Update("cars", update, new Condition("number", number))); bool execute = Access.Execute(SQL_Queries.Update("cars", update, new Condition("car_number", number))); if (execute) { foreach (Row row in cars) { if (row.GetColValue("car_number").ToString() == number.ToString()) { row.UpdateColume(update); break; } } Refresh(); } return(execute); }