public void EditPtoRequest(PaidTimeOff paidTimeOff) { using (var cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand("UPDATE [dbo].[PaidTimeOff] " + "SET [PtoStatus] = @PtoStatus, " + "[EmpID] = @EmpId, " + "[HoursRequested] = @HoursRequested, " + "[Date] = @Date, " + "[ReasonRejected] = @ReasonReject, " + "[ManagerID] = @ManagerId " + "WHERE PtoRequestID = @PtoRequestId", cn); cmd.Parameters.AddWithValue("@PtoRequestId", paidTimeOff.PtoRequestID); cmd.Parameters.AddWithValue("@PtoStatus", paidTimeOff.PtoStatus); cmd.Parameters.AddWithValue("@EmpID", paidTimeOff.EmpID); cmd.Parameters.AddWithValue("@HoursRequested", paidTimeOff.HoursRequested); cmd.Parameters.AddWithValue("@Date", paidTimeOff.Date); cmd.Parameters.AddWithValue("@ReasonReject", paidTimeOff.ReasonRejected); cmd.Parameters.AddWithValue("@ManagerID", paidTimeOff.ManagerID); cn.Open(); cmd.ExecuteNonQuery(); } }
public ActionResult ApprovePaid(int id) { OvmDbContext context = new OvmDbContext(); PaidTimeOff pto = context.PaidTimeOffs.Find(id); pto.IsApproved = true; context.SaveChanges(); context.Dispose(); return(RedirectToAction("AllRequests")); }
public ActionResult DeletePaid(int id) { OvmDbContext context = new OvmDbContext(); PaidTimeOff pto = context.PaidTimeOffs.Find(id); context.PaidTimeOffs.Remove(pto); context.SaveChanges(); context.Dispose(); return(RedirectToAction("Index")); }
public void EditPtoRequestTest() { PaidTimeOff ptoRequest = new PaidTimeOff() { EmpID = 6, Date = new DateTime(2015, 07, 15), HoursRequested = 4 }; PaidTimeOffRepository repo = new PaidTimeOffRepository(); repo.EditPtoRequest(ptoRequest); }
public async Task <string> UpdatePaidTime(int id, PaidTimeOff paidTime) { try { var res = await _repository.UpdatePaidTimes(id, paidTime); return(res); } catch (Exception ex) { throw ex; } }
public async Task <PaidTimeOff> CreateNewPaidTime(PaidTimeOff paidTime) { try { var res = await _repository.CreateNewPaidTimes(paidTime); return(res); } catch (Exception ex) { throw ex; } }
public void SubmitPtoRequest(PaidTimeOff ptoRequest) { using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) { var p = new DynamicParameters(); p.Add("EmpId", ptoRequest.EmpID); p.Add("HoursRequested", ptoRequest.HoursRequested); p.Add("Date", ptoRequest.Date); cn.Query <PaidTimeOff>("SubmitPtoRequest", p, commandType: CommandType.StoredProcedure); } }
public async Task <PaidTimeOff> CreateNewPaidTimes(PaidTimeOff paidTimes) { try { _context.PaidTimeOffs.Add(paidTimes); await _context.SaveChangesAsync(); return(paidTimes); } catch (Exception ex) { throw ex; } }
public void SubmitPtoRequestTest() { PaidTimeOff pto = new PaidTimeOff() { EmpID = 6, Date = new DateTime(2015, 07, 15), HoursRequested = 4 }; PaidTimeOffRepository repo = new PaidTimeOffRepository(); repo.SubmitPtoRequest(pto); var ptoList = repo.ViewAllPtoRequests(); Assert.AreEqual(7, ptoList.Count); }
public async Task <IActionResult> CreatePaidTime(PaidTimeOff paidTime) { try { var response = await _service.CreateNewPaidTime(paidTime); if (response != null) { return(Ok(response)); } return(StatusCode(StatusCodes.Status204NoContent)); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> UpdatePaidTime(int PaidTimeId, PaidTimeOff paidTime) { try { var res = await _service.UpdatePaidTime(PaidTimeId, paidTime); if (res != null) { return(Ok(res)); } return(StatusCode(StatusCodes.Status204NoContent)); } catch (Exception ex) { throw; } }
public ActionResult EditPaid(PaidTimeOffsEditVM model) { OvmDbContext context = new OvmDbContext(); PaidTimeOff pto = new PaidTimeOff { Id = model.Id, CreatedOn = DateTime.Now, RequestorId = AuthenticationManager.LoggedUser.Id, From = model.From, To = model.To, IsHalfDay = model.IsHalfDay }; context.PaidTimeOffs.AddOrUpdate(pt => pt.Id, pto); context.SaveChanges(); context.Dispose(); return(RedirectToAction("Index")); }
public ActionResult EditPaid(int?id) { PaidTimeOffsEditVM model = new PaidTimeOffsEditVM(); ; OvmDbContext context = new OvmDbContext(); if (id != null) { PaidTimeOff pto = context.PaidTimeOffs.Find(id.Value); model.To = pto.To; model.From = pto.From; model.IsHalfDay = pto.IsHalfDay; model.Id = pto.Id; } context.Dispose(); return(View(model)); }
public ActionResult SubmitPtoRequest(PaidTimeOffVM ptoVM) { if (ModelState.IsValidField("HoursRequested") && ModelState.IsValidField("Date") && ModelState.IsValidField("EmpID")) { var ptoRequest = new PaidTimeOff(); ptoRequest.EmpID = ptoVM.EmpId; ptoRequest.Date = ptoVM.Date; ptoRequest.HoursRequested = ptoVM.HoursRequested; ptoRequest.ManagerID = ptoVM.ManagerId; var ops = OperationsFactory.CreatePaidTimeOffOperations(); ops.SubmitPtoRequest(ptoRequest); } else { return(RedirectToAction("SubmitPtoRequest")); } return(RedirectToAction("ViewPtoRequests")); }
public async Task <string> UpdatePaidTimes(int id, PaidTimeOff paidTimes) { try { var res = await _context.PaidTimeOffs.FirstOrDefaultAsync(m => m.PaidTimeOffId == id); res.LeaveType = paidTimes.LeaveType; res.EmployeeName = paidTimes.EmployeeName; res.LeavePeriod = paidTimes.LeavePeriod; res.LeaveAmount = paidTimes.LeaveAmount; res.Note = paidTimes.Note; _context.Update(res); await _context.SaveChangesAsync(); return("Updated Record"); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Create(BaseTimeOffViewModel model) { if (ModelState.IsValid) { PaidTimeOff timeOff = new PaidTimeOff() { From = model.From, To = model.To, CreatedOn = DateTime.Now, IsHalfDay = model.IsHalfDay, IsApproved = model.IsApproved, Requestor = model.Requestor }; _context.Add(timeOff); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(model)); }
public void EditPtoRequestTest() { //tests against DB; altered test app config setting var ops = OperationsFactory.CreatePaidTimeOffOperations(); PaidTimeOff ptoRequest = new PaidTimeOff() { PtoRequestID = 1, PtoStatus = "Approved", EmpID = 5, Date = new DateTime(2015, 07, 15), HoursRequested = 4, ManagerID = 2, ReasonRejected = "N/A" }; PaidTimeOffRepository repo = new PaidTimeOffRepository(); repo.EditPtoRequest(ptoRequest); var response = new Response <List <PaidTimeOff> >(); response = ops.ViewAllPtoRequests(); PaidTimeOff updatedPto = response.Data.FirstOrDefault(p => p.PtoRequestID == 1); Assert.AreEqual("Approved", updatedPto.PtoStatus); }
public void SubmitPtoRequest(PaidTimeOff ptoRequest) { }
public void EditPtoRequest(PaidTimeOff ptoRequest) { var repo = new PaidTimeOffRepository(); repo.EditPtoRequest(ptoRequest); }
public void SubmitPtoRequest(PaidTimeOff pto) { PaidTimeOffRepository repo = new PaidTimeOffRepository(); repo.SubmitPtoRequest(pto); }