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