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