Guid ISaveWorkTimeTable.Save(TimeSheetData timeSheetData) { var workTimeLookUpTable = timeSheetLookUpTableFactory.CreateFromImportedData(timeSheetData); using (var connection = connectionFactory.Create()) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { LoadWorkTimeDataToDataTable(workTimeLookUpTable); InsertWorkTimeLookUpTables(connection, transaction); InsertWorkTimeLookUpTableRows(connection, transaction); transaction.Commit(); return(workTimeLookUpTable.Id); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
private Worksheet PutTimesheetDataIntoExcelSheet(Worksheet worksheet, TimeSheetData timeSheetData) { worksheet = PutDayDataInToRow("2" , timeSheetData.Monday, worksheet); worksheet = PutDayDataInToRow("3", timeSheetData.Tuesday, worksheet); worksheet = PutDayDataInToRow("4", timeSheetData.Wednesday, worksheet); worksheet = PutDayDataInToRow("5", timeSheetData.Thursday, worksheet); worksheet = PutDayDataInToRow("6", timeSheetData.Friday, worksheet); return worksheet; }
TimeSheetData IDataTimeSheetReader.Read(TimeSheetFile timeSheetDataFile) { using (ExcelPackage excelPackage = new ExcelPackage(new MemoryStream(timeSheetDataFile.FileContent))) { var workBook = excelPackage.Workbook; var workSheet = workBook.Worksheets["Timesheet"]; var firstRow = 2; var lastRow = workSheet.Dimension.End.Row; var workTimeDataRows = new List <WorkTimeDataRow>(); for (var rowIndex = firstRow; rowIndex <= lastRow; rowIndex++) { var workTimeDataRow = new WorkTimeDataRow() { RowNumber = rowIndex, ProjectName = workSheet.Cells["B" + rowIndex].Value, Task = workSheet.Cells["C" + rowIndex].Value, Hour = workSheet.Cells["D" + rowIndex].Value, Time = workSheet.Cells["E" + rowIndex].Value }; workTimeDataRows.Add(workTimeDataRow); } var timeSheetData = new TimeSheetData() { TimeSheetDataFile = timeSheetDataFile, WorkTimeData = new WorkTimeData() { Rows = workTimeDataRows.ToArray() } }; return(timeSheetData); } }
public void LoadDataIntoExcelTemplateAndSaveToLocation(TimeSheetData timeSheetData, string location) { var emptyWorksheet = GetTheMainWorkSheet(); var loadedWorksheet = PutTimesheetDataIntoExcelSheet(emptyWorksheet, timeSheetData); loadedWorksheet.SaveAs(location); }
public TimeSheetController(ApplicationDbContext context) { _repository = new TimeSheetData(context); }