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 PopulateProjects(JsonResultProjects oProjects, List <JsonResultTasks> oTasks) { JsonResultProject oProject; SLDocument sl = new SLDocument(); int row = 1; try { for (int i = 0; i < oProjects.projects.Count; i++) { // Extract a project oProject = oProjects.projects.ElementAt(i); for (int j = 0; j < oTasks[i].tasks.Count; j++) { sl.SetCellValue("A" + row, oTasks[i].tasks[j].companyname); sl.SetCellValue("B" + row, oProject.title); sl.SetCellValue("C" + row, oProject.categoryname); sl.SetCellValue("D" + row, oProject.managername); sl.SetCellValue("E" + row, oProject.startdate.Split('T')[0]); sl.SetCellValue("F" + row, oProject.duedate.Split('T')[0]); sl.SetCellValue("G" + row, oTasks[i].tasks[j].completedate.Split('T')[0]); sl.SetCellValue("H" + row, oTasks[i].tasks[j].name); sl.SetCellValue("I" + row, oTasks[i].tasks[j].status); sl.SetCellValue("J" + row, oTasks[i].tasks[j].ordernumber); row++; } } FormatProjectReport(sl); sl.SaveAs("\\\\bigdell\\Clients\\Omega\\00 Analytics\\Project Status\\Data\\Active-Projects-Tasks.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); }