private string figureOutClient(PersonnelScheduleDetail wSD) { if (wSD.GETjobName().Contains("Nisqually")) { return("TPU"); } if (wSD.GETjobName().Contains("TPU")) { return("TPU Admin"); } return(wSD.GETjobName().Substring(0, 9)); }
private string figureOutStore(PersonnelScheduleDetail wSD) { if (wSD.GETpostDescription().Contains("SMC")) { return("SMC"); } if (wSD.GETpostDescription().Contains("CP")) { return("CP"); } if (wSD.GETjobName().Contains("Nisqually")) { return("Nisqually"); } return(wSD.GETjobName()); }
private List <PersonnelScheduleDetail> listOfXMLstringsToPersonalScheduleDetailObjectsLongNameLOL(List <string> psd2) { List <PersonnelScheduleDetail> ListPSD = new List <PersonnelScheduleDetail>(); foreach (string str in psd2) { PersonnelScheduleDetail temp = new PersonnelScheduleDetail(); temp.SETcellID(Convert.ToInt32(findXMLnameAndReturnStringValue(str, "CellID"))); temp.SETcellLocked(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "CellLocked"))); temp.SETchangeReasonID(findXMLnameAndReturnStringValue(str, "ChangeReasonID")); temp.SETchangesCount(Convert.ToInt32(findXMLnameAndReturnStringValue(str, "ChangesCount"))); temp.SETdateAcknowledged(findXMLnameAndReturnStringValue(str, "DateAcknowledged")); temp.SETdateChanged(findXMLnameAndReturnStringValue(str, "DateChanged")); temp.SETemployeeName(findXMLnameAndReturnStringValue(str, "EmployeeName")); temp.SETemployeeNumber(Convert.ToInt32(findXMLnameAndReturnStringValue(str, "EmployeeNumber"))); temp.SEThasBeenOffered(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "HasBeenOffered"))); temp.SEThasNotes(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "HasNotes"))); temp.SEThours(Convert.ToDouble(findXMLnameAndReturnStringValue(str, "Hours"))); temp.SETisAcknowledged(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "IsAcknowledged"))); temp.SETjobNumber(findXMLnameAndReturnStringValue(str, "JobNumber")); temp.SETlunch(Convert.ToDouble(findXMLnameAndReturnStringValue(str, "Lunch"))); temp.SETmultipleCells(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "MultipleCells"))); temp.SETnextDay(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "NextDay"))); temp.SETofferID(findXMLnameAndReturnStringValue(str, "OfferID")); temp.SETofferNotes(findXMLnameAndReturnStringValue(str, "OfferNotes")); temp.SETofferedToMe(Convert.ToBoolean(findXMLnameAndReturnStringValue(str, "OfferedToMe"))); temp.SETpostDescription(findXMLnameAndReturnStringValue(str, "PostDescription")); temp.SETscheduleDetailsID(Convert.ToInt32(findXMLnameAndReturnStringValue(str, "ScheduleDetailsID"))); temp.SETscheduledWorkDate(Convert.ToDateTime(findXMLnameAndReturnStringValue(str, "ScheduledWorkDate")).AddDays(1)); //NOTE OFF BY 1 DAY SO WE ARE ADDING 1 DAY TO THE RETURNED DAY... DON'T KNOW WHY EHUB IS SENDING US A VALUE THAT IS OFF BY ONE DAY... :) temp.SETshiftCode(findXMLnameAndReturnStringValue(str, "ShiftCode")); temp.SETttmStatusID(findXMLnameAndReturnStringValue(str, "TTMStatusID")); temp.SETuserNotes(findXMLnameAndReturnStringValue(str, "UserNotes")); temp.SETencodedID(findXMLnameAndReturnStringValue(str, "EncodedID")); temp.SETinTime(Convert.ToDateTime(findXMLnameAndReturnStringValue(str, "InTime"))); temp.SETjobName(findXMLnameAndReturnStringValue(str, "JobName")); temp.SEToutTime(Convert.ToDateTime(findXMLnameAndReturnStringValue(str, "OutTime"))); temp.SETpostID(Convert.ToInt32(findXMLnameAndReturnStringValue(str, "PostID"))); temp.SETpayPeriod(temp.GETscheduledWorkDate()); ListPSD.Add(temp); } return(ListPSD); }
private List <List <PersonnelScheduleDetail> > editTheSortedReturnedDataForCorrectSubmitions(List <List <PersonnelScheduleDetail> > allData) { DateTime today = TODAYSDATE; if (today.Day == 1) { List <List <PersonnelScheduleDetail> > temp = new List <List <PersonnelScheduleDetail> >(); int stupid = 0; if (today.AddDays(-15).Year != TODAYSDATE.Year || today.AddDays(-7).Year != TODAYSDATE.Year) { stupid = 365; } int alldataStartCT = allData.Count; foreach (List <PersonnelScheduleDetail> lst1 in allData) { List <PersonnelScheduleDetail> tempListPSD = new List <PersonnelScheduleDetail>(); foreach (PersonnelScheduleDetail psd in lst1) { PersonnelScheduleDetail tempPSD = new PersonnelScheduleDetail(); tempPSD = psd; tempListPSD.Add(tempPSD); } temp.Add(tempListPSD); } foreach (List <PersonnelScheduleDetail> lst2 in temp) { allData.Add(lst2); } bool newWeekly = true; for (int j = 0; j < alldataStartCT; j++) { List <PersonnelScheduleDetail> list = allData.ElementAtOrDefault(j); for (int i = 0; list != null && i < list.Count; i++) { newWeekly = true; if (list.ElementAtOrDefault(i).GETscheduledWorkDate().DayOfYear < today.DayOfYear - 7 + stupid || list.ElementAtOrDefault(i).GETscheduledWorkDate().Day == TODAYSDATE.Day) { list.Remove(list.ElementAtOrDefault(i)); i--; } } if (list != null && list.Count == 0) { allData.Remove(list); j--; alldataStartCT--; newWeekly = false; } if (newWeekly) { isWeekly.Add(true); } } for (int j = alldataStartCT; j < allData.Count; j++) { List <PersonnelScheduleDetail> list = allData.ElementAtOrDefault(j); for (int i = 0; list != null && i < list.Count; i++) { if (list.ElementAtOrDefault(i).GETscheduledWorkDate().DayOfYear < today.DayOfYear - 16 + stupid || list.ElementAtOrDefault(i).GETscheduledWorkDate().Day == TODAYSDATE.Day) { list.Remove(list.ElementAtOrDefault(i)); i--; } } if (list != null && list.Count == 0) { allData.Remove(list); j--; alldataStartCT--; } isWeekly.Add(false); } } else if (today.Day == 16) { List <List <PersonnelScheduleDetail> > temp = new List <List <PersonnelScheduleDetail> >(); int stupid = 0; if (today.AddDays(-15).Year != TODAYSDATE.Year || today.AddDays(-7).Year != TODAYSDATE.Year) { stupid = 365; } int alldataStartCT = allData.Count; foreach (List <PersonnelScheduleDetail> lst1 in allData) { List <PersonnelScheduleDetail> tempListPSD = new List <PersonnelScheduleDetail>(); foreach (PersonnelScheduleDetail psd in lst1) { PersonnelScheduleDetail tempPSD = new PersonnelScheduleDetail(); tempPSD = psd; tempListPSD.Add(tempPSD); } temp.Add(tempListPSD); } foreach (List <PersonnelScheduleDetail> lst2 in temp) { allData.Add(lst2); } deleteDataBefore15thandWeek(allData, today, stupid, alldataStartCT); } else { justWeeklyDeleteExtraData(allData, today); } return(allData); }
private void setDataForExcelSpreadsheet(string store, int rowToUpDate, IXLWorksheet worksheet, double hours, PersonnelScheduleDetail wSD) { worksheet.Cell("A13").SetValue(wSD.GETemployeeName() + " " + wSD.GETemployeeNumber()); worksheet.Cell("AH38").SetValue(wSD.GETemployeeName()); worksheet.Cell("AM13").SetValue(figureOutClient(wSD)); worksheet.Cell("X13").SetValue(wSD.GETpayPeriod()); //each of the worked days: worksheet.Cell("A" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GETscheduledWorkDate().ToShortDateString()); worksheet.Cell("E" + Convert.ToString(rowToUpDate + 19)).SetValue(store); worksheet.Cell("I" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GETinTime().ToString("H:mm")); worksheet.Cell("V" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GEToutTime().ToString("H:mm")); worksheet.Cell("AI" + Convert.ToString(rowToUpDate + 19)).SetValue(wSD.GEThours().ToString()); worksheet.Cell("AI35").SetValue(Convert.ToString(hours)); }