public bool SaveNewAssigningLimits(AsssigningLimit al) { if (OpenConnection() == true) { query = "TRUNCATE TABLE assigning_limits"; SqlQuery(query); cmd.ExecuteNonQuery(); query = "INSERT INTO assigning_limits (HR,PR,SALES_F1,SALES_F2,SALES_F3,SALES_F4,DEPOT) " + "VALUES (@HR,@PR,@SALES_F1,@SALES_F2,@SALES_F3,@SALES_F4,@DEPOT)"; SqlQuery(query); cmd.Parameters.AddWithValue("@HR", al.HR_Limit); cmd.Parameters.AddWithValue("@PR", al.PR_Limit); cmd.Parameters.AddWithValue("@SALES_F1", al.SALES_F1_Limit); cmd.Parameters.AddWithValue("@SALES_F2", al.SALES_F2_Limit); cmd.Parameters.AddWithValue("@SALES_F3", al.SALES_F3_Limit); cmd.Parameters.AddWithValue("@SALES_F4", al.SALES_F4_Limit); cmd.Parameters.AddWithValue("@DEPOT", al.DEPOT_Limit); cmd.ExecuteNonQuery(); conn.Close(); return(true); } else { conn.Close(); return(false); } }
public Schedule(List <Employee> existing, List <Employee> newemployees, List <Employee> formeremployees, Department department) { this.department = department; firstDayOfCurrentWeek = TimeControl.FirstDayOfWeek(DateTime.Today); fullListemployees = existing; formerEList = formeremployees; stageforChanges = new List <Shift>(); foreach (Employee ne in newemployees) { if (!fullListemployees.Contains(ne)) { fullListemployees.Add(ne); } } allshifts = conn.LoadShifts(department, fullListemployees); newshifts = new List <Shift>(); presentAndFutureShifts = new List <Shift>(); foreach (Shift s in allshifts) { if (s.Date >= firstDayOfCurrentWeek) { presentAndFutureShifts.Add(s); } } preferences = conn.LoadPreferences(); availability = conn.LoadAcceptedAbsence(); limitStorage = conn.LoadAssigningLimits(); }
public AsssigningLimit LoadAssigningLimits() { AsssigningLimit loadedLimit = null; if (OpenConnection() == true) { query = "SELECT * FROM assigning_limits"; SqlQuery(query); QueryEx(); foreach (DataRow dr in dt.Rows) { loadedLimit = new AsssigningLimit(Convert.ToInt32(dr["HR"]), Convert.ToInt32(dr["PR"]), Convert.ToInt32(dr["SALES_F1"]), Convert.ToInt32(dr["SALES_F2"]), Convert.ToInt32(dr["SALES_F3"]), Convert.ToInt32(dr["SALES_F4"]), Convert.ToInt32(dr["DEPOT"])); } conn.Close(); return(loadedLimit); } else { MessageBox.Show("Limitations not loaded, please make an attempt later!"); return(null); } }