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