public static List<TrainingType> GetAll() { List<TrainingType> output = new List<TrainingType>(); string sql = "SELECT DISTINCT TrainingType FROM REQ_EventDates"; using (SqlConnection conn = UtilityDb.GetConnectionESS()) { SqlDataReader dr = UtilityDb.GetDataReader(sql, conn); while (dr.Read()) { TrainingType tt = new TrainingType(dr["TrainingType"].ToString()); output.Add(tt); } } 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; } }
private static string getTrainingStatus(int stage, int SAPStatus, TrainingType Type) { string Status = ""; if (Type == TrainingType.Book) { switch (stage) { case 0: Status = "SAVED"; break; case 1: Status = "APPLIED"; break; case 2: Status = "APPROVED SV"; break; case 3: if (SAPStatus == 1) Status = "PENDING"; if (SAPStatus == 2) Status = "APPROVED HR"; break; } } if (Type == TrainingType.Prebook) { switch (stage) { case 0: Status = "SAVED"; break; case 1: Status = "APPLIED"; break; case 2: if (SAPStatus == 1) Status = "PENDING"; if (SAPStatus == 2) Status = "APPROVED SV"; break; } } return Status; }
internal static void getAllbyTypeUsernameandStage(TrainingType Type, string StaffUsername, int stage, ref List<Listing> TrainingLst) { Staff staff = Staff.getStaffInfo(StaffUsername); if (staff != null && stage == 1) { List<BookedEvent> bkEventsLst = new List<BookedEvent>(); List<PrebookedEvent> pbkEventsLst = new List<PrebookedEvent>(); if (Type == TrainingType.Book) bkEventsLst = BookedEvent.GetAllByStaffStage(StaffUsername, stage); if (Type == TrainingType.Prebook) pbkEventsLst = PrebookedEvent.getAllbyStaffStage(StaffUsername, stage); if (bkEventsLst != null || pbkEventsLst != null) BindToObject(ref TrainingLst, staff, bkEventsLst, pbkEventsLst, Mode.Staff, true); } }
public void LoadbyStaff(Staff staff, TrainingType Type, string TrainingName, int stage, int SAPStatus, DateTime? RequestedDate, string RequestedUsername, bool IsUnapproved, string CEF) { if (IsUnapproved) { Staff supervisor = Staff.GetSupervisorByUsername(staff.Username); if (supervisor != null) SupervisorName = supervisor.Name.ToUpper(); } CEFStatus = CEF; Staff RequestedStaff = Staff.getStaffInfo(RequestedUsername); RequestedBy = RequestedStaff.Name.ToUpper(); StaffID = staff.StaffID; StaffName = staff.Name; Title = TrainingName.ToUpper(); DateRequest = RequestedDate; if (Type == TrainingType.Book) { ApplicationType = "BOOK"; Status = getTrainingStatus(stage, SAPStatus, TrainingType.Book); if (SAPStatus == 0) PostedSAPStatus = "PENDING"; if (SAPStatus == 2) PostedSAPStatus = "POSTED"; } if (Type == TrainingType.Prebook) { ApplicationType = "PREBOOK"; Status = getTrainingStatus(stage, SAPStatus, TrainingType.Prebook); if (SAPStatus == 1) PostedSAPStatus = "PENDING"; if (SAPStatus == 2) PostedSAPStatus = "POSTED"; } }
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; } }