private void submitShift_Click(object sender, EventArgs e)
{
List<Employee> check = dbConnector.Instance.getAllEmployee();
List<Employee> nightShiftEmployess = new List<Employee>();
List<Employee> morningShiftEmployess = new List<Employee>();
for (int i = 0; i < MorningShiftCheckBox.Items.Count; i++)
{
if ((MorningShiftCheckBox.GetItemChecked(i)))
{
String name = MorningShiftCheckBox.Items[i].ToString();
Employee temp = check.Find(g => getFirstAndLastName(g).Equals(name));
morningShiftEmployess.Add(temp);
}
}
Shift morningShift = new Shift("Morning", (int)DateChoose.Date.DayOfWeek, DateChoose.Date.ToString("MM/dd/yyyy"), morningShiftEmployess);
listEmployeeShift.Add(morningShift);
if (!isFriday)
{
for (int i = 0; i < NightShiftCheckBox.Items.Count; i++)
{
if ((NightShiftCheckBox.GetItemChecked(i)))
{
String name = NightShiftCheckBox.Items[i].ToString();
Employee temp = check.Find(g => getFirstAndLastName(g).Equals(name));
Console.WriteLine(getFirstAndLastName(temp));
nightShiftEmployess.Add(temp);
}
}
Shift nightShift = new Shift("Evening", (int)DateChoose.Date.DayOfWeek, DateChoose.Date.ToString("MM/dd/yyyy"), nightShiftEmployess);
listEmployeeShift.Add(nightShift);
}
dbConnector.Instance.AddToSchedule(listEmployeeShift);
listEmployeeShift.Clear();
}
public Dictionary<String, Shift> getAllShifts(String startDate, String endDate)
{
Dictionary<String, Employee> listemp = getEmployeeList();
Dictionary<String, Shift> ds = new Dictionary<string, Shift>();
string query = "Select * FROM schedule WHERE shiftDate >= STR_TO_DATE('" + startDate + "', '%m/%d/%Y') AND shiftDate <= STR_TO_DATE('" + endDate + "', '%m/%d/%Y');";
MySqlCommand cmd = new MySqlCommand(query, this.connection);
MySqlDataReader dataReader2 = cmd.ExecuteReader();
while (dataReader2.Read())
{
if (!ds.Keys.Contains((String)dataReader2["shift"] + "_" + (String)dataReader2["shiftDate"])) {
String shift = (String)dataReader2["shift"];
int Shift_Day = getShiftDay((String)dataReader2["shift_day"]);
String shiftDate = (String)dataReader2["shiftDate"];
Shift Tempshift = new Shift(shift, Shift_Day, shiftDate, new List<Employee>());
Tempshift.setDbId((int)dataReader2["id"]);
ds[(String)dataReader2["shift"] + "_" + (String)dataReader2["shiftDate"]] = Tempshift;
}
}
dataReader2.Close();
dataReader2 = cmd.ExecuteReader();
while (dataReader2.Read())
{
ds[(String)dataReader2["shift"] + "_" + (String)dataReader2["shiftDate"]].setEmployee(listemp[((int)dataReader2["employeeId"]).ToString() + "_" + (String)dataReader2["employee_type"]]);
}
dataReader2.Close();
return ds;
}
