public List <LeaveOfAbsence> GetLeaveOfAbsences() { string query = "SELECT * FROM LeaveOfAbsence"; var listLOA = new List <LeaveOfAbsence>(); using (var conn = new SqlConnection(connectionstring)) { using (var cmd = new SqlCommand(query, conn)) { conn.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var LOA = new LeaveOfAbsence() { Id = (int)reader["LeaveOfAbsenceId"], ShiftId = (int)reader["Shift_Id"], Reason = (string)reader["Reason"] }; listLOA.Add(LOA); } return(listLOA); } } } }
public Company(int id, string name, string description, string keyWords, Categories categorie, Owner owner, ICollection <Location> locations, ICollection <OpeningHours> openingHours, LeaveOfAbsence leaveOfAbsence, SocialMedia socialMedia, ICollection <Promotion> promotions) { Id = id; Name = name; Description = description; KeyWords = keyWords; Categorie = categorie; Owner = owner; Locations = locations; OpeningHours = openingHours; LeaveOfAbsence = leaveOfAbsence; SocialMedia = socialMedia; Promotions = promotions; Discounts = new List <Discount>(); }
public List <LeaveOfAbsence> GetLeaveOfAbsencesWithApproval() { string query = "SELECT * FROM LeaveOfAbsence inner join Shift on LeaveOfAbsence.Shift_Id=Shift.Id inner join Department on Department_Id=Department.Id inner join User_LeaveOfAbsence on LeaveOfAbsence.LeaveOfAbsenceId=User_LeaveOfAbsence.LeaveOfAbsence_Id WHERE Approved IS NOT NULL"; var leaveOfAbsences = new List <LeaveOfAbsence>(); using (var conn = new SqlConnection(connectionstring)) { using (var cmd = new SqlCommand(query, conn)) { conn.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var LOA = new LeaveOfAbsence { Id = (int)reader["LeaveOfAbsenceId"], Reason = (string)reader["Reason"], IsApproved = (LeaveOfAbsence.Approved)reader["Approved"], NewUserId = (int)reader["NewUser_Id"], Shift = new Shift { Id = (int)reader["Shift_Id"], Date = (DateTime)reader["Date"], StartTime = (TimeSpan)reader["StartTime"], EndTime = (TimeSpan)reader["EndTime"], Department = new Department() { Name = (string)reader["Name"] } } }; leaveOfAbsences.Add(LOA); } return(leaveOfAbsences); } } } }