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