/// <summary> /// Maakt excel file met alle stories en taken van de sprint cardwall en geeft filename terug /// </summary> /// <param name="sprint">Sprint</param> public string ExportSprintCardwall(Sprint sprint) { SetCultureInfo(); string fileName = String.Format("SprintCardwall_{0}_{1}.xls", DateTime.Now.ToString("yyyy-MM-dd"), sprint.Goal); ExcelStorage provider = new ExcelStorage(typeof(Cardwall)); provider.StartRow = 3; provider.StartColumn = 1; provider.FileName = ConfigurationManager.AppSettings["exportLocation"] + fileName; provider.TemplateFile = ConfigurationManager.AppSettings["sprintCardwallTemplate"]; List<Cardwall> res = new List<Cardwall>(); foreach (SprintStory sprintStory in sprint.SprintStories) { Cardwall storyRow = new Cardwall(); storyRow.StoryId = sprintStory.Id.ToString(); storyRow.StoryTitle = sprintStory.Story.Title; storyRow.StoryPriority = Enum.GetName(typeof(Priority), sprintStory.Story.ProductBacklogPriority); storyRow.StoryEstimatedHours = TimeSpanInMinuten(sprintStory.Story.Estimation).ToString(); res.Add(storyRow); foreach (Task task in sprintStory.Story.Tasks) { Cardwall taskRow = new Cardwall(); switch(task.State) { case State.Open: taskRow.TaskOpenId = task.Id.ToString(); taskRow.TaskOpenTitle = task.Title; taskRow.TaskOpenAssignee = task.AssignedUserName; taskRow.TaskOpenTimeSpent = TimeSpanInMinuten(task.TotalTimeSpent()).ToString(); break; case State.Taken: taskRow.TaskInProgressId = task.Id.ToString(); taskRow.TaskInProgressTitle = task.Title; taskRow.TaskInProgressAssignee = task.AssignedUserName; taskRow.TaskInProgressTimeSpent = TimeSpanInMinuten(task.TotalTimeSpent()).ToString(); break; case State.Closed: taskRow.TaskDoneId = task.Id.ToString(); taskRow.TaskDoneTitle = task.Title; taskRow.TaskDoneAssignee = task.AssignedUserName; taskRow.TaskDoneTimeSpent = TimeSpanInMinuten(task.TotalTimeSpent()).ToString(); break; } res.Add(taskRow); } } provider.InsertRecords(res.ToArray()); RestoreCultureInfo(); return fileName; }
/// <summary> /// Maakt excel file met alle stories en taken van de sprint cardwall en geeft filename terug /// </summary> /// <param name="sprint">Sprint</param> public string ExportSprintCardwall(Sprint sprint) { SetCultureInfo(); string fileName = String.Format("SprintCardwall_{0}_{1}.xls", DateTime.Now.ToString("yyyy-MM-dd"), sprint.Doel); ExcelStorage provider = new ExcelStorage(typeof(Cardwall)); provider.StartRow = 3; provider.StartColumn = 1; provider.FileName = ConfigurationManager.AppSettings["exportLocation"] + fileName; provider.TemplateFile = ConfigurationManager.AppSettings["sprintCardwallTemplate"]; List<Cardwall> res = new List<Cardwall>(); foreach (SprintStory sprintStory in sprint.SprintStories) { Cardwall storyRow = new Cardwall(); storyRow.StoryId = sprintStory.Id.ToString(); storyRow.StoryTitle = sprintStory.Story.Titel; storyRow.StoryPrioriteit = Enum.GetName(typeof(Prioriteit), sprintStory.Story.ProductBacklogPrioriteit); storyRow.StoryGeschatteUren = TimeSpanInMinuten(sprintStory.Story.Schatting).ToString(); res.Add(storyRow); foreach (Task task in sprintStory.Story.Tasks) { Cardwall taskRow = new Cardwall(); switch(task.Status) { case Status.NietOpgepakt: taskRow.TaskOpenId = task.Id.ToString(); taskRow.TaskOpenTitle = task.Titel; taskRow.TaskOpenBehandelaar = task.BehandelaarNaam; taskRow.TaskOpenBestedeUren = TimeSpanInMinuten(task.TotaalBestedeTijd()).ToString(); break; case Status.Opgepakt: taskRow.TaskInProgressId = task.Id.ToString(); taskRow.TaskInProgressTitle = task.Titel; taskRow.TaskInProgressBehandelaar = task.BehandelaarNaam; taskRow.TaskInProgressBestedeUren = TimeSpanInMinuten(task.TotaalBestedeTijd()).ToString(); break; case Status.Afgesloten: taskRow.TaskDoneId = task.Id.ToString(); taskRow.TaskDoneTitle = task.Titel; taskRow.TaskDoneBehandelaar = task.BehandelaarNaam; taskRow.TaskDoneBestedeUren = TimeSpanInMinuten(task.TotaalBestedeTijd()).ToString(); break; } res.Add(taskRow); } } provider.InsertRecords(res.ToArray()); RestoreCultureInfo(); return fileName; }