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