public void AddTimeEntry(TimeEntry timeEntry)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
p.Add("EmpID", timeEntry.EmpID);
p.Add("Date", timeEntry.Date);
p.Add("HoursWorked", timeEntry.HoursWorked);
cn.Execute("AddTimeEntry", p, commandType: CommandType.StoredProcedure);
}
}
public Response<TimeEntry> AddTimeSheets(TimeEntry timeEntry)
{
var repo = new TimeSheetRepository();
Response<TimeEntry> response = new Response<TimeEntry>();
repo.AddTimeEntry(timeEntry);
try
{
response.Success = true;
response.Message = "Your Time Entry was added!";
}
catch (Exception exception)
{
response.Success = false;
response.Message = exception.Message;
}
return response;
}
public ActionResult AddTimeSheets(TimeEntry timeEntry, int SelectedEmployeeID)
{
var ops = FileManager.CreateTimeSheetOperations();
timeEntry.EmpID = SelectedEmployeeID;
var empDD = ops.GetAllEmployees();
ops.AddTimeSheets(timeEntry);
ViewTimeSheetVM model = new ViewTimeSheetVM();
var timeEntries = ops.GetAllTimeEntriesForOneEmp(SelectedEmployeeID);
var employee = ops.SelectOneEmployee(SelectedEmployeeID);
model.TimeEntries = timeEntries.Data;
model.Message = timeEntries.Message;
model.employee = employee;
model.CreateEmployeeList(empDD);
model.employee.EmpID= SelectedEmployeeID;
return View("ViewTimeSheets", model);
}
