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