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