public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
PayrollReport = _context.GetPayrolls(StartDate.Date, EndDate.Date);
return(Page());
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
IFileProcessor fileProcessor = new TimesheetFileProcessor();
int reportId;
string errorString;
fileProcessor.ProcessFile(FileUpload.Timesheet, _context, out reportId, out errorString);
if (!string.IsNullOrEmpty(errorString))
{
ModelState.AddModelError(FileUpload.Timesheet.Name, errorString);
PayrollReport = new List <PayrollReport>().ToArray();
return(Page());
}
//var data = await FileHelpers.ProcessFormFile(FileUpload.Timesheet, ModelState);
//DataTable dt = FileHelpers.Csv2Table(FileUpload.Timesheet, ",");
//const string COL_EMPID = "employee id";
//const string COL_DATE = "date";
//const string COL_HOURSWORKED = "hours worked";
//const string COL_JOBCODE = "job group";
//var reportId = int.Parse(dt.Rows[dt.Rows.Count - 1][COL_HOURSWORKED].ToString());
//dt.Rows.RemoveAt(dt.Rows.Count - 1);
//dt.AcceptChanges();
//var report = _context.Report.FirstOrDefault(r => r.ReportId == reportId);
//if (report == null)
//{
// _context.Report.Add(new Report { ReportId = reportId });
// _context.SaveChanges();
//}
//else
//{
// ModelState.AddModelError(FileUpload.Timesheet.Name,
// string.Format("Report with ID: {0} already exists in database.", reportId));
// PayrollReport = new List<PayrollReport>().ToArray();
// return Page();
//}
//DataView dv = new DataView(dt);
//dv.Sort = COL_EMPID;
//DataTable distinctEmployees = dv.ToTable(true, COL_EMPID);
//_context.Database.EnsureCreated();
//var employeedToAdd = new List<Employee>();
//foreach (DataRow dr in distinctEmployees.Rows)
//{
// var employeeId = int.Parse(dr[COL_EMPID].ToString());
// if (_context.Employee.FirstOrDefault(e => e.EmployeeId == employeeId) == null)
// {
// employeedToAdd.Add(new Employee { EmployeeId = employeeId });
// }
//}
//if (employeedToAdd.Count > 0)
//{
// _context.Employee.AddRange(employeedToAdd.ToArray());
// _context.SaveChanges();
//}
//foreach (DataRow dr in dt.Rows)
//{
// var date = DateTime.ParseExact(dr[COL_DATE].ToString(), "d/m/yyyy", System.Globalization.CultureInfo.InvariantCulture);
// var employeeId = int.Parse(dr[COL_EMPID].ToString());
// var hoursWorked = decimal.Parse(dr[COL_HOURSWORKED].ToString());
// var jobCode = dr[COL_JOBCODE].ToString();
// var jobId = _context.Job.FirstOrDefault(j => j.JobCode == jobCode).JobId;
// _context.Timesheet.Add(new Timesheet { Date = date, EmployeeId = employeeId, HoursWorked = hoursWorked, ReportId = reportId, JobId = jobId });
//}
//_context.SaveChanges();
//PayrollReport = new PayrollReport[]
//{
// new PayrollReport{EmployeeId=1, StartDate=DateTime.Parse("1/1/2011"), EndDate=DateTime.Parse("1/15,2011"), Amount=100},
// new PayrollReport{EmployeeId=1, StartDate=DateTime.Parse("1/16/2011"), EndDate=DateTime.Parse("1/31,2011"), Amount=100}
//};
//if(PayrollReport.Count > 0)
//{
//}
var timesheet = _context.Report.FirstOrDefault(x => x.ReportId == reportId).Timesheets.OrderBy(x => x.Date).ToList();
var startDate = timesheet.First().Date;
var endDate = timesheet.Last().Date;
PayrollReport = _context.GetPayrolls(startDate, endDate);
return(Page());
}