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