public static List<PrebookedEvent> GetAll(string staffUsername, int stage, bool isAdHoc) { List<PrebookedEvent> output = new List<PrebookedEvent>(); string sql = string.Format("SELECT * FROM REQ_PrebookedEvents WHERE StaffUsername='******' AND Stage={1} AND IsAdHoc='{2}'", staffUsername, stage, isAdHoc.ToString()); using (SqlConnection conn = UtilityDb.GetConnectionESS()) { SqlDataReader dr = UtilityDb.GetDataReader(sql, conn); while (dr.Read()) { PrebookedEvent obj = new PrebookedEvent(); obj.LoadFromReader(dr); output.Add(obj); } } return output; }
internal static List<PrebookedEvent> getByUsername(string Username) { List<PrebookedEvent> output = new List<PrebookedEvent>(); string sql = string.Format("SELECT * FROM REQ_PrebookedEvents Where UPPER(StaffUsername)='{0}'", Username.ToUpper()); using (SqlConnection conn = UtilityDb.GetConnectionESS()) { SqlDataReader dr = UtilityDb.GetDataReader(sql, conn); while (dr.Read()) { PrebookedEvent obj = new PrebookedEvent(); obj.LoadFromReader(dr); output.Add(obj); } } return output; }
internal static List<PrebookedEvent> getByEventID(int SelectedID) { List<PrebookedEvent> output = new List<PrebookedEvent>(); string sql = string.Format("SELECT * FROM REQ_PrebookedEvents Where EventID={0}", SelectedID); using (SqlConnection conn = UtilityDb.GetConnectionESS()) { SqlDataReader dr = UtilityDb.GetDataReader(sql, conn); while (dr.Read()) { PrebookedEvent obj = new PrebookedEvent(); obj.LoadFromReader(dr); output.Add(obj); } } return output; }
public static List<PrebookedEvent> GetAllListing(string staffUsername, int? SelectedYear) { List<PrebookedEvent> output = new List<PrebookedEvent>(); string sql = string.Format("SELECT * FROM REQ_PrebookedEvents WHERE StaffUsername='******'", staffUsername); //if (SelectedYear.HasValue) // sql += " AND YEAR(RequestDate)=" + SelectedYear.Value; using (SqlConnection conn = UtilityDb.GetConnectionESS()) { SqlDataReader dr = UtilityDb.GetDataReader(sql, conn); while (dr.Read()) { PrebookedEvent obj = new PrebookedEvent(); obj.LoadFromReader(dr); output.Add(obj); } } return output; }
//for filter by Training status private static void LoadObjectForStatus(TrainingType Type, ref List<Listing> output, string SelectedValue, BookedEvent bk, PrebookedEvent pk) { Listing newList = new Listing(); Staff staff = new Staff(); Staff supervisor = new Staff(); string TrainingName = ""; switch (Type) { case TrainingType.Book: staff = Staff.getStaffInfo(bk.StaffUsername); if (staff != null) { newList.StaffID = staff.StaffID; newList.StaffName = staff.Name.ToUpper(); } supervisor = Staff.GetSupervisorByUsername(staff.Username); if (supervisor != null) { newList.SupervisorName = supervisor.Name.ToUpper(); } else { newList.SupervisorName = "NOT DEFINED"; } newList.ApplicationType = "BOOK"; TrainingName = EventGroup.getTitle(bk.EventId); if (TrainingName != null || TrainingName != "") newList.Title = TrainingName.ToUpper(); newList.DateRequest = bk.RequestDate; newList.Status = SelectedValue.ToUpper(); if (bk.SAPStatus == 0) newList.PostedSAPStatus = "PENDING"; if (bk.SAPStatus == 2) newList.PostedSAPStatus = "POSTED"; output.Add(newList); break; case TrainingType.Prebook: staff = Staff.getStaffInfo(pk.StaffUsername); if (staff != null) { newList.StaffID = staff.StaffID; newList.StaffName = staff.Name.ToUpper(); } supervisor = Staff.GetSupervisorByUsername(staff.Username); if (supervisor != null) { newList.SupervisorName = supervisor.Name.ToUpper(); } else { newList.SupervisorName = "NOT DEFINED"; } newList.ApplicationType = "PREBOOK"; TrainingName = EventGroup.getTitle(pk.EventId); if (TrainingName != null || TrainingName != "") newList.Title = TrainingName.ToUpper(); newList.DateRequest = pk.RequestDate; newList.Status = SelectedValue.ToUpper(); if (pk.SAPStatus == 0) newList.PostedSAPStatus = "PENDING"; if (pk.SAPStatus == 2) newList.PostedSAPStatus = "POSTED"; output.Add(newList); break; } }
public void LoadAll(TrainingType Type, string TrainingName, BookedEvent booked, PrebookedEvent prebooked) { Staff staff = new Staff(); Staff supervisor = new Staff(); switch (Type) { case TrainingType.Prebook: DateRequest = prebooked.RequestDate; staff = Staff.getStaffInfo(prebooked.StaffUsername); if (staff != null) { StaffID = staff.StaffID; StaffName = staff.Name; } supervisor = Staff.GetSupervisorByUsername(prebooked.StaffUsername); if (supervisor != null) { SupervisorName = supervisor.Name.ToUpper(); } else { SupervisorName = "NOT DEFINED"; } ApplicationType = "PREBOOK"; Title = TrainingName.ToUpper(); Status = getTrainingStatus(prebooked.Stage, prebooked.SAPStatus, TrainingType.Prebook); if (prebooked.SAPStatus == 1) PostedSAPStatus = "PENDING"; if (prebooked.SAPStatus == 2) PostedSAPStatus = "POSTED"; break; case TrainingType.Book: DateRequest = booked.RequestDate; staff = Staff.getStaffInfo(booked.StaffUsername); if (staff != null) { StaffID = staff.StaffID; StaffName = staff.Name; } supervisor = Staff.GetSupervisorByUsername(booked.StaffUsername); if (supervisor != null) { SupervisorName = supervisor.Name.ToUpper(); } else { SupervisorName = "NOT DEFINED"; } ApplicationType = "BOOK"; Title = TrainingName.ToUpper(); Status = getTrainingStatus(booked.Stage, booked.SAPStatus, TrainingType.Book); if (booked.SAPStatus == 0) PostedSAPStatus = "PENDING"; if (booked.SAPStatus == 2) PostedSAPStatus = "POSTED"; break; } }