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