public void GetAllWorkScheduleShifts()
{
List <WorkScheduleShift> listOfAllShifts = new List <WorkScheduleShift>();
workSchedules.Clear();
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
con.Open();
SqlCommand allShiftsFromDB = new SqlCommand("Sp_GetWorkScheduleShifts", con);
allShiftsFromDB.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = allShiftsFromDB.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int shiftId = int.Parse(reader["ShiftID"].ToString());
int employeeId = int.Parse(reader["EmployeeID"].ToString());
DateTime startTime = Convert.ToDateTime(reader["StartTime"]);
DateTime endTime = Convert.ToDateTime(reader["EndTime"]);
Employee employeeToShift = EmployeeRepository.GetInstance().GetEmployeeById(employeeId);
WorkScheduleShift newShift = new WorkScheduleShift(shiftId, employeeToShift, startTime, endTime);
listOfAllShifts.Add(newShift);
}
}
}
catch (SqlException e) { Console.WriteLine("Muuuuligvis en fejl\n" + e.Message); }
}
foreach (WorkScheduleShift wss in listOfAllShifts)
{
int shiftYear = int.Parse(wss.StartTime.ToString("yyyy"));
int shiftMonth = int.Parse(wss.StartTime.ToString("M"));
WorkSchedule workSchedule = this.GetSchedule(shiftYear, shiftMonth);
if (workSchedule == null)
{
workSchedule = new WorkSchedule(shiftYear, shiftMonth);
AddWorkSchedule(workSchedule);
}
workSchedule.AddShiftToSchedule(wss);
}
}
public WorkSchedule GetSchedule(int workYear, int workMonth)
{
WorkSchedule workSchedule = null;
int i = 0;
bool running = true;
do
{
if (i < workSchedules.Count)
{
if (workSchedules[i].Year == workYear && workSchedules[i].Month == workMonth)
{
workSchedule = workSchedules[i];
running = false;
}
i++;
}
else
{
running = false;
}
} while (running);
return(workSchedule);
}
public void AddWorkSchedule(WorkSchedule newWorkSchedule)
{
workSchedules.Add(newWorkSchedule);
}
public void AddNewScheduleToGui(int year, int month)
{
WorkSchedule.WorkSchedule workSchedule = new WorkSchedule.WorkSchedule(year, month);
}