public ActionResult UpdateComplaint(int id = 0)
{
DataManager DM = new DataManager();
ComplaintView CV = DM.ViewComplaint(id);
return(View(CV));
}
public ActionResult UpdateComplaint(ComplaintView CV)
{
DataManager DM = new DataManager();
DM.UpdateComplaint(CV);
return(Json(new { success = true, message = "Updated Successfully!" }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> Edit(ComplaintView view)
{
if (ModelState.IsValid)
{
var pic = view.Image; //la inicializo en la imagen vieja por si el no la cambio no la dañe
var folder = "~/Content/Images";
if (view.PhotoFile != null)
{
pic = FilesHelper.UploadPhoto(view.PhotoFile, folder);
pic = string.Format("{0}/{1}", folder, pic);
}
var complaint = ToComplaint(view);
complaint.Image = pic;
db.Entry(complaint).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
//db.Entry(complaint).State = EntityState.Modified;
//await db.SaveChangesAsync();
//return RedirectToAction("Index");
}
ViewBag.ComplaintTypeId = new SelectList(db.ComplaintsTypes, "ComplaintTypeId", "Description", view.ComplaintTypeId);
return(View(view));
}
// public ActionResult Create([Bind(Include = "ComplaintId,UserId,CreationDate,Address,Description,Image,IsActive,Lat,Lon,ComplaintTypeId")] Complaint complaint)
public ActionResult Create(ComplaintView view)
{
if (ModelState.IsValid)
{
//db.Complaints.Add(complaint);
//db.SaveChanges();
//return RedirectToAction("Index");
var pic = string.Empty;
var folder = "~/Content/Images";
if (view.ImageFile != null)
{
pic = FilesHelper.UploadPhoto(view.ImageFile, folder);
pic = string.Format("{0}/{1}", folder, pic);
}
var complaint = ToComplaint(view);
complaint.Image = pic;
//db.Flowers.Add(flower);
db.Complaints.Add(complaint);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ComplaintTypeId = new SelectList(db.ComplaintTypes, "ComplaintTypeId", "Description", view.ComplaintTypeId);
return(View(view));// complaint);
}
public ComplaintView ViewComplaint(int id)
{
List <ComplaintView> complaints = GetComplaintViews();
ComplaintView CV = complaints.Where(o => o.ComplaintID.Equals(id)).FirstOrDefault();
return(CV);
}
public List <ComplaintView> GetMyComplaintViews(int id)
{
List <ComplaintView> complaints = new List <ComplaintView>();
using (CMSProjectEntities db = new CMSProjectEntities())
{
var comp = db.Complaints.ToList();
foreach (Complaint c in comp)
{
ComplaintView CV = new ComplaintView();
CV.ComplaintID = c.ComplaintID;
CV.CustomerID = c.CustomerID;
CV.EmployeeID = c.EmployeeID.GetValueOrDefault();
CV.Description = c.Description;
CV.ComplaintStatusID = c.ComplaintStatusID;
var compstat = db.ComplaintStatusLookups.Where(o => o.ComplaintStatusID.Equals(CV.ComplaintStatusID)).FirstOrDefault();
CV.ComplaintStatus = compstat.Status;
if (CV.CustomerID.Equals(id))
{
complaints.Add(CV);
}
}
}
return(complaints);
}
public ActionResult MakeComplaint(ComplaintView CV)
{
DataManager DM = new DataManager();
Complaint C = new Complaint();
C = DM.AddOrUpdateComplaint(CV, 1);
using (CMSProjectEntities db = new CMSProjectEntities())
{
db.Complaints.Add(C);
db.SaveChanges();
}
return(Json(new { success = true, message = "Added Successfully!" }, JsonRequestBehavior.AllowGet));
}
public void UpdateComplaint(ComplaintView CV)
{
using (CMSProjectEntities db = new CMSProjectEntities())
{
var emp = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
Complaint currComplaint = new Complaint();
currComplaint.ComplaintID = CV.ComplaintID;
currComplaint.CustomerID = CV.CustomerID;
currComplaint.Description = CV.Description;
currComplaint.ComplaintStatusID = CV.ComplaintStatusID;
currComplaint.EmployeeID = emp.UserID;
db.Entry(currComplaint).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
private Complaint ToComplaint(ComplaintView view)
{
return(new Complaint
{
ComplaintId = view.ComplaintId,
UserId = view.UserId,
CreationDate = view.CreationDate,
Address = view.Address,
Description = view.Description,
Image = view.Image,
IsActive = view.IsActive,
Lat = view.Lat,
Lon = view.Lon,
ComplaintTypeId = view.ComplaintTypeId,
});
}
public Complaint AddOrUpdateComplaint(ComplaintView CV, int i)
{
Complaint comp = new Complaint();
using (CMSProjectEntities db = new CMSProjectEntities())
{
if (i == 1)
{
comp.Description = CV.Description;
var user = db.Users.Where(o => o.Username.Equals(HttpContext.Current.User.Identity.Name)).FirstOrDefault();
int cid = db.CustomerUsers.Where(o => o.UserID.Equals(user.UserID)).FirstOrDefault().CustomerID;
comp.CustomerID = cid;
comp.ComplaintStatusID = 1;
}
return(comp);
}
}
