public static ResultView InsertRows(List <TimesheetUploadItem> timesheetUploadList, int reportId) { foreach (var item in timesheetUploadList) { item.AmountPaid = (decimal)item.Hours * GetHourlySalary(item.JobGroup); item.PayPeriodStart = GetPayPeriodStart(item.TimeEntry); item.ReportId = reportId; } return(TimesheetDA.InsertTimesheetBatch(timesheetUploadList)); }
public static List <TimesheetReportItemView> GetTimesheetReportItems() { var timesheetReportItems = new List <TimesheetReportItemView>(); var sqlReportList = TimesheetDA.GetReport(); if (sqlReportList.Success) { foreach (TimesheetReportItemSql row in ((List <TimesheetReportItemSql>)sqlReportList.Value)) { timesheetReportItems.Add(new TimesheetReportItemView() { EmployeeId = row.EmployeeId, PayPeriod = GetPeriodString(row.PayPeriodStart), AmountPaid = GetCurrency(row.AmountPaid) }); } } //TODO: we are loosing the db error return here, consider logging return(timesheetReportItems); }