public static List <IterationStateCountExcel> ToIterationWithStateCountsExcel(DbDataReader dataReader) { List <IterationStateCountExcel> iterationStates = new List <IterationStateCountExcel>(); while (dataReader.Read()) { var iterationWithStateCount = new IterationStateCountExcel() { FirstName = dataReader["firstName"].ToString(), LastName = dataReader["lastName"].ToString(), Email = dataReader["email"].ToString(), ReportingManager = dataReader["email"].ToString(), Role = dataReader["role_name"].ToString(), Department = dataReader["department_name"].ToString(), IterationTitle = dataReader["title"].ToString(), IterationStartDate = DateTime.Parse(dataReader["iteration_start_date"].ToString()), IterationEndDate = DateTime.Parse(dataReader["iteration_end_date"].ToString()), IterationState = dataReader["iteration_state"].ToString(), Rating = dataReader["rating"].ToString() }; iterationStates.Add(iterationWithStateCount); } ; iterationStates = iterationStates.OrderBy(x => x.IterationState).ToList(); return(iterationStates); }
private void SetRowContent(ExcelWorksheet ws, int rowNumber, IterationStateCountExcel iterationStateCountExcelModel) { ws.Cells[rowNumber, 3].Value = iterationStateCountExcelModel.FirstName; ws.Cells[rowNumber, 4].Value = iterationStateCountExcelModel.LastName; ws.Cells[rowNumber, 5].Value = iterationStateCountExcelModel.Email; ws.Cells[rowNumber, 6].Value = iterationStateCountExcelModel.ReportingManager; ws.Cells[rowNumber, 7].Value = iterationStateCountExcelModel.Role; ws.Cells[rowNumber, 8].Value = iterationStateCountExcelModel.Department; ws.Cells[rowNumber, 9].Value = iterationStateCountExcelModel.IterationState; ws.Cells[rowNumber, 10].Value = iterationStateCountExcelModel.Rating; }
private void AddIterationDetails(ExcelWorksheet ws, IterationStateCountExcel stateCountExcel) { ws.Cells[3, 5].Value = IterationStateCountExcelConstant.ITERATION_TITLE; ws.Cells[3, 5].Style.Font.Bold = true; ws.Cells[3, 6].Value = stateCountExcel.IterationTitle; ws.Cells[4, 5].Value = IterationStateCountExcelConstant.ITERATION_START; ws.Cells[4, 5].Style.Font.Bold = true; ws.Cells[4, 6].Value = stateCountExcel.IterationStartDate.ToString("dd/MM/yyyy"); ws.Cells[5, 5].Value = IterationStateCountExcelConstant.ITERATION_END; ws.Cells[5, 5].Style.Font.Bold = true; ws.Cells[5, 6].Value = stateCountExcel.IterationEndDate.ToString("dd/MM/yyyy"); using (var range = ws.Cells[3, 5, 5, 6]) { range.Style.ShrinkToFit = false; range.Style.Border.Top.Style = ExcelBorderStyle.Thin; range.Style.Border.Left.Style = ExcelBorderStyle.Thin; range.Style.Border.Right.Style = ExcelBorderStyle.Thin; range.Style.Border.Bottom.Style = ExcelBorderStyle.Thin; } }