public virtual WorkTimeLookUpTable CreateFromImportedData(TimeSheetData timeSheetData) { var workTimeLookUpTable = new WorkTimeLookUpTable(timeSheetData.TimeSheetDataFile); try { foreach (var timeSheetDataRow in timeSheetData.WorkTimeData.Rows) { //var convertDateFromObjToDouble = Convert.ToDouble(timeSheetDataRow.Time); //var date = DateTime.FromOADate(convertDateFromObjToDouble); var workTimeLookUpTableRow = new WorkTimeLookUpTableRow() { WorkTimeLookUpTableId = workTimeLookUpTable.Id, ProjectName = Convert.ToString(timeSheetDataRow.ProjectName), Task = Convert.ToString(timeSheetDataRow.Task), Hour = Convert.ToDouble(timeSheetDataRow.Hour), Time = Convert.ToDateTime(timeSheetDataRow.Time) }; workTimeLookUpTable.Rows.Add(workTimeLookUpTableRow); } } catch (Exception e) { throw e; } return(workTimeLookUpTable); }
public virtual TimeSheetDataValidatorError[] Validate(TimeSheetData timeSheetData) { var timeSheetDataValidationResult = new List <TimeSheetDataValidatorError>(); var workTimeDataValidationResult = workTimeDataValidator.Validate(timeSheetData.WorkTimeData); timeSheetDataValidationResult.AddRange(workTimeDataValidationResult); return(timeSheetDataValidationResult.ToArray()); }