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