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