public void PopulateBilling(JsonResultTimes oTimes) { JsonResultTime oTime; SLDocument sl = new SLDocument(); int row = 1; try { for (int i = 0; i < oTimes.timerecords.Count; i++) { oTime = oTimes.timerecords.ElementAt(i); sl.SetCellValue("A" + row, oTime.projecttitle); sl.SetCellValue("B" + row, oTime.companyname); sl.SetCellValue("C" + row, oTime.taskname); sl.SetCellValue("D" + row, oTime.starttime.ToString("MM-dd-yyy")); sl.SetCellValue("E" + row, oTime.contactname); sl.SetCellValue("F" + row, oTime.timetracked / 60); sl.SetCellValue("G" + row, oTime.notes); row++; } FormatBillingReport(sl); sl.SaveAs("C:\\Users\\John Fleischli\\Downloads\\Billing Report.xlsx"); } catch (Exception e) { SlackClient client = new SlackClient(""); client.PostMessage("PWF API Tool Error: " + e.ToString().Substring(0, 100), "PWF API Admin", "C9X3YGW5B"); Environment.Exit(1); } }
public Form1() { InitializeComponent(); oXL = new ExcelHelper(); oAPI = new PWFAPIHelper(); dateToPicker.MaxDate = DateTime.Today; dateFromPicker.MaxDate = DateTime.Today; string timeFrom = DateTime.Today.ToString("yyyy-MM"); timeFrom = timeFrom + "-01"; string timeTo = DateTime.Today.ToString("yyyy-MM-dd"); string reportName = dateFromPicker.Value.Date.ToString("yyyy-MM"); // Populate DataGridView with Projects List <JsonResultTasks> oTasks = new List <JsonResultTasks>(); JsonResultProjects oProjects = oAPI.GetProjects(); JsonResultTimes oTimes = oAPI.GetTime(timeFrom, timeTo); foreach (JsonResultProject project in oProjects.projects) { JsonResultTasks tasks = oAPI.GetTasks(project.id.ToString()); oTasks.Add(tasks); } oXL.PopulateProjects(oProjects, oTasks); oXL.PopulateTime(oTimes, reportName); //oXL.PopulateBilling(oTimes); }
public void PopulateTime(JsonResultTimes oTimes, string reportName) { JsonResultTime oTime; SLDocument sl = new SLDocument(); int row = 1; try { for (int i = 0; i < oTimes.timerecords.Count; i++) { oTime = oTimes.timerecords.ElementAt(i); sl.SetCellValue("A" + row, oTime.companyname); sl.SetCellValue("B" + row, oTime.projecttitle); sl.SetCellValue("C" + row, oTime.categoryname); sl.SetCellValue("D" + row, oTime.contactname); sl.SetCellValue("E" + row, oTime.taskname); sl.SetCellValue("F" + row, oTime.timetracked / 60); sl.SetCellValue("G" + row, oTime.starttime.ToString("MM-dd-yyy")); row++; } FormatTimeReport(sl); sl.SaveAs("\\\\bigdell\\Clients\\Omega\\00 Analytics\\Hours\\Data\\Actual\\" + reportName + ".xlsx"); } catch (Exception e) { SlackClient client = new SlackClient(""); client.PostMessage("PWF API Tool Error: " + e.ToString(), "PWF API Admin", "C9X3YGW5B"); Environment.Exit(1); } }
private void updateButton_Click(object sender, EventArgs e) { string timeFrom = dateFromPicker.Value.Date.ToString("yyyy-MM-dd"); string timeTo = dateToPicker.Value.Date.ToString("yyyy-MM-dd"); string reportName = dateFromPicker.Value.Date.ToString("yyyy-MM"); // Populate DataGridView with Projects List <JsonResultTasks> oTasks = new List <JsonResultTasks>(); JsonResultProjects oProjects = oAPI.GetProjects(); JsonResultTimes oTimes = oAPI.GetTime(timeFrom, timeTo); foreach (JsonResultProject project in oProjects.projects) { JsonResultTasks tasks = oAPI.GetTasks(project.id.ToString()); oTasks.Add(tasks); } oXL.PopulateProjects(oProjects, oTasks); oXL.PopulateTime(oTimes, reportName); //oXL.PopulateBilling(oTimes); }