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