public void AddWorkScheduleShift(WorkScheduleShift workScheduleShift)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
con.Open();
SqlCommand Addworkschedule = new SqlCommand("Sp_AddWorkScheduleShift", con);
Addworkschedule.CommandType = CommandType.StoredProcedure;
Addworkschedule.Parameters.Add(new SqlParameter("@EmployeeId", workScheduleShift.Employee.EmployeeId));
Addworkschedule.Parameters.Add(new SqlParameter("@StartTime", workScheduleShift.StartTime));
Addworkschedule.Parameters.Add(new SqlParameter("@EndTime", workScheduleShift.EndTime));
SqlDataReader reader = Addworkschedule.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
workScheduleShift.ShiftID = int.Parse(reader["ShiftID"].ToString());
}
}
}
catch (SqlException e) { Console.WriteLine("Muuuuligvis en fejl\n" + e.Message); }
}
GetAllWorkScheduleShifts();
}
public List <WorkScheduleShift> GetAllWorkScheduleShifts()
{
List <WorkScheduleShift> allShifts = new List <WorkScheduleShift>();
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);
allShifts.Add(newShift);
}
}
}
catch (SqlException e) { Console.WriteLine("Muuuuligvis en fejl\n" + e.Message); }
}
return(allShifts);
}
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 void AddShiftToSchedule(WorkScheduleShift shift)
{
shifts.Add(shift);
}
public void AddWorkShift(WorkScheduleShift newWorkSchedule)
{
workShifts.Add(newWorkSchedule);
}