public ActionResult DeleteConfirmed(int id)
{
RequestStatu requestStatu = db.RequestStatus.Find(id);
db.RequestStatus.Remove(requestStatu);
db.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult Edit([Bind(Include = "Id,Status")] RequestStatu requestStatu)
{
if (ModelState.IsValid)
{
db.Entry(requestStatu).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(requestStatu);
}
public ActionResult Create([Bind(Include = "Id,Status")] RequestStatu requestStatu)
{
if (ModelState.IsValid)
{
db.RequestStatus.Add(requestStatu);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(requestStatu);
}
public void CreateLeaveRequest(LeaveRequestModel leaveRequestModel)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
CreateLeaveCheck(unitOfWork, leaveRequestModel);
RequestStatu status = unitOfWork.RequestStatusRepository.GetRequestStatusByCode(Status.PENDING.ToString());
leaveRequestModel.StatusId = status.RequestStatusId;
unitOfWork.LeaveRequestRepository.Insert(LeaveRequestModelBuilder.Instance.MapToLeaveRequestDao(leaveRequestModel));
unitOfWork.Save();
}
}
// GET: RequestStatus/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
RequestStatu requestStatu = db.RequestStatus.Find(id);
if (requestStatu == null)
{
return HttpNotFound();
}
return View(requestStatu);
}
// GET: RequestStatus/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RequestStatu requestStatu = db.RequestStatus.Find(id);
if (requestStatu == null)
{
return(HttpNotFound());
}
return(View(requestStatu));
}
public void ApproveLeaveRequest(LeaveRequestModel leaveRequestModel)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
RequestStatu status = unitOfWork.RequestStatusRepository.GetRequestStatusByCode(Status.APPROVED.ToString());
LeaveRequest leaveRequest = unitOfWork.LeaveRequestRepository.GetById(item => item.LeaveRequestId == leaveRequestModel.LeaveRequestId);
if (leaveRequest == null)
{
throw new LightstoneValidationException("Leave entry you trying to approve does not exist in the database.");
}
leaveRequestModel.LeaveRequestId = status.RequestStatusId;
UpdateLeaveRequest(unitOfWork, leaveRequest, leaveRequestModel);
}
}
public ActionResult Edit([Bind(Include = "RequestStatusId,NameEn,NameAr,StatusCode,CreatedDate,LastUpdateBy,LastUpdateDate,Active")] RequestStatu requestStatu)
{
if (ModelState.IsValid)
{
var user = db.Users.Where(u => u.JobNumber == User.Identity.Name).FirstOrDefault();
requestStatu.LastUpdateDate = DateTime.Today;
requestStatu.LastUpdateBy = user.FirstNameEn + " " + user.LastNameEn;
db.Entry(requestStatu).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(requestStatu));
}
private void AddDefaultRequestStatus()
{
var db = new Entities();
var requestStatusExists = db.RequestStatus.Any(rs => rs.Code == RequestStatusApproved);
if (!requestStatusExists)
{
var requestStata = new List <RequestStatu>
{
new RequestStatu
{
Code = RequestStatusApproved,
Title = GetRequestStatusString(ApplicationWideData.RequestStatusApproved)
},
new RequestStatu
{
Code = RequestStatusCancelled,
Title = GetRequestStatusString(RequestStatusCancelled)
},
new RequestStatu
{
Code = RequestStatusNotViewed,
Title = GetRequestStatusString(RequestStatusNotViewed)
}
};
requestStata.ForEach(rs => db.RequestStatus.Add(rs));
db.SaveChanges();
}
if (!db.RequestStatus.Any(rs => rs.Code == RequestStatusNoAction))
{
var requestStatus = new RequestStatu
{
Code = RequestStatusNoAction,
Title = GetRequestStatusString(RequestStatusNoAction)
};
db.RequestStatus.Add(requestStatus);
db.SaveChanges();
}
}
public async Task <int> CancelAppointment(Guid appointmentId, int conf)
{
try
{
int count = 0;
Guid requestId = appointmentId;
string userId = string.Empty;
var appoinments = _context.Appoinments.Where(r => r.AppoinmentId.Equals(appointmentId));
foreach (var apoin in appoinments)
{
var allAppoinments = _context.Appoinments.Where(r => r.RequestId.Equals(apoin.RequestId)).ToList();
foreach (var all in allAppoinments)
{
count = count + 1;
requestId = all.RequestId;
}
}
if (count >= conf)
{
/* CANCELAR Appoinments */
var apps = _context.Appoinments.Find(appointmentId);
var reqStas = new List <RequestStatu>();
apps.IsAttended = false;
apps.IsCancelled = true;
/* CANCELAR RequestStatus (Cancelar los IsCurrentStatus = 1 y Agregar nueva fila) */
var selectRequestStatus = _context.RequestStatus.Where(r => r.RequestId == requestId && r.IsCurrentStatus == true);
foreach (var query in selectRequestStatus)
{
query.IsCurrentStatus = false;
}
var reqStatus = new RequestStatu
{
RequestStatusId = Guid.NewGuid(),
RequestId = requestId,
StatusId = (int)StatusEnum.CitacanceladaDer,
Date = DateTime.Now,
IsCurrentStatus = true,
Observations = "",
};
var req = _context.Requests.Find(requestId);
req.RequestId = requestId;
req.IsComplete = false;
_context.RequestStatus.AddOrUpdate(reqStatus);
_context.Requests.AddOrUpdate(req);
}
else
{
var app = _context.Appoinments.Find(appointmentId);
app.IsAttended = false;
app.IsCancelled = true;
var apps = _context.Appoinments.Find(appointmentId);
var reqStas = new List <RequestStatu>();
apps.IsAttended = false;
apps.IsCancelled = true;
/* CANCELAR RequestStatus (Cancelar los IsCurrentStatus = 1 y Agregar nueva fila) */
var selectRequestStatus = _context.RequestStatus.Where(r => r.RequestId == requestId && r.IsCurrentStatus == true);
foreach (var query in selectRequestStatus)
{
query.IsCurrentStatus = false;
}
var reqStatus = new RequestStatu
{
RequestStatusId = Guid.NewGuid(),
RequestId = requestId,
StatusId = (int)StatusEnum.EnesperadeAgendarCiraDer,
Date = DateTime.Now,
IsCurrentStatus = true,
Observations = "",
};
var req = _context.Requests.Find(requestId);
req.RequestId = requestId;
req.IsComplete = false;
_context.RequestStatus.AddOrUpdate(reqStatus);
_context.Requests.AddOrUpdate(req);
_context.Appoinments.AddOrUpdate(app);
// _context.RequestStatus.AddOrUpdate(rs);
}
return(await _context.SaveChangesAsync());
}
catch (Exception exception)
{
throw exception;
}
}
