public string UpdateComplaintRating(ComplaintVM model)
{
var data = (from x in _context.Complaint
where x.ComplaintId == model.complaintId
select x).FirstOrDefault();
if (data == null)
{
return("Complaint not found!");
}
if (data.StatusId == 1)
{
return("This complaint has not been attended");
}
data.RatingId = model.ratingId;
if (_context.SaveChanges() > 0)
{
return("Rated Successfully!");
}
return("Rating not successfully updated. Try again!!!!");
}
public IActionResult ViewMoreDetail(int id)
{
SessionCheck();
ComplaintVM cvm = new ComplaintVM();
cvm.complaints = obj_hrpdbcontext.Complaints.Where(data => data.id == id).FirstOrDefault();
cvm.status_name = obj_hrpdbcontext.Status.Where(data => data.id == cvm.complaints.status_id).FirstOrDefault().name;
cvm.complaint_type_name = obj_hrpdbcontext.Complaint_Types.Where(data => data.id == cvm.complaints.complaint_type_id).FirstOrDefault().name;
return(View(cvm));
}
public IActionResult ComplaintCreate()
{
SessionCheck();
ComplaintVM complaintvm = new ComplaintVM();
complaintvm.status = obj_hrpdbcontext.Status.ToList();
complaintvm.complainttype = obj_hrpdbcontext.Complaint_Types.ToList();
return(View(complaintvm));
}
public Complaint AddComplaint(ComplaintVM model)
{
if (model == null)
{
throw new Exception("There is no Entry!");
}
var data = new Complaint
{
ComplaintId = model.complaintId,
LogedBy = model.logedBy,
Title = model.title,
ComplaintTypeId = model.complaintTypeId,
DepartmentId = model.departmentId,
ComplaintDetail = model.complaintDetail,
DateCreated = DateTime.Now,
StatusId = 1,
RatingId = 0,
PriorityId = model.priorityId,
};
var complain = _context.Complaint.Add(data);
if (_context.SaveChanges() > 0)
{
// string url = HttpContext.Current.Request.Url.AbsoluteUri;
String path = String.Format(ConfigurationManager.AppSettings["path"]);
var email = _context.Department.Where(x => x.DepartmentId == complain.DepartmentId).Select(x => x.Email).FirstOrDefault();
var departmentName = _context.Department.Where(x => x.DepartmentId == complain.DepartmentId).Select(x => x.DepartmentName).FirstOrDefault();
// var absoluteToRelative = new Uri("http://*****:*****@sun.edu.ng", "Skyline University Nigeria Student Complaint ", messageContentSSD, ""); //[email protected]
// SendEmailAPI.SendEmail("", "*****@*****.**", "Skyline University Nigeria Student Complaint ", messageContentSSD, ""); //[email protected]
}
return(complain);
}
public HttpResponseMessage UpdateStatus(ComplaintVM model)
{
try
{
var response = _repo.UpdateStatus(model);
if (response == false)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { success = false, message = "No record found" }));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { success = true, result = response }));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { success = false, message = ex.Message }));
}
}
public bool UpdateComplaint(ComplaintVM model)
{
var data = (from x in _context.Complaint
where x.ComplaintId == model.complaintId
select x).FirstOrDefault();
if (data == null)
{
throw new Exception("Record not found");
}
data.ComplaintId = model.complaintId;
data.LogedBy = model.logedBy;
data.ComplaintTypeId = model.complaintTypeId;
data.DepartmentId = model.departmentId;
data.ComplaintDetail = model.complaintDetail;
data.DateCreated = model.dateCreated;
data.StatusId = model.statusId;
data.PriorityId = model.priorityId;
data.Title = model.title;
return(_context.SaveChanges() > 0);
}
public IActionResult UpdateComplaintStatus(int id)
{
SessionCheck();
ComplaintVM complaintVM = new ComplaintVM();
var data = obj_hrpdbcontext.Status.ToList().Where(a => !(a.name == "Withdraw") && !(a.name == "Reopen") && !(a.name == "Closed") && !(a.name == "Case Filing Request"));
complaintVM.status = new List <Status>();
foreach (Status d in data)
{
Status s = new Status();
s.name = d.name;
complaintVM.status.Add(s);
}
complaintVM.complaints = obj_hrpdbcontext.Complaints.ToList().Where(x => x.id == id).FirstOrDefault();
complaintVM.status_name = obj_hrpdbcontext.Status.Where(data => data.id == complaintVM.complaints.status_id).FirstOrDefault().name;
complaintVM.complaint_type_name = obj_hrpdbcontext.Complaint_Types.Where(data => data.id == complaintVM.complaints.complaint_type_id).FirstOrDefault().name;
return(View(complaintVM));
}
public void Update(ComplaintVM model)
{
_complaintRepository.Update(ProjectMapper.ConvertToEntity <Complaint>(model));
}
public void Insert(ComplaintVM model)
{
_complaintRepository.Insert(ProjectMapper.ConvertToEntity <Complaint>(model));
}
public ActionResult CreateComplaint(ComplaintVM model)
{
_complaintService.Insert(model);
return(RedirectToAction("Index", "Home"));
}
