// GET: enquiry_info/Delete/5 /* public ActionResult Delete(long? id) * { * if (id == null) * { * return new HttpStatusCodeResult(HttpStatusCode.BadRequest); * } * enquiry_info enquiry_info = db.enquiry.Find(id); * if (enquiry_info == null) * { * return HttpNotFound(); * } * return View(enquiry_info); * } */ // POST: enquiry_info/Delete/5 /* [HttpPost, ActionName("Delete")] * [ValidateAntiForgeryToken] */ public ActionResult DeleteConfirmed(long id) { enquiry_info enquiry_info = db.enquiry.Find(id); db.enquiry.Remove(enquiry_info); var proposal_info = db.proposal.Where(m => m.eid == id); var invoice_main = db.proposal.FirstOrDefault(m => m.eid == id); db.proposal.RemoveRange(proposal_info); var ff = invoice_main == null ? 0 : invoice_main.Id; var inv = db.invoice_main.Where(m => m.pid == ff); db.invoice_main.RemoveRange(inv); db.SaveChanges(); return(RedirectToAction("Index")); /* var Order = db.Orders.where(x => x.StoreId == store.StoreId) * var OrderDetail = db.OrderDetails.where(x => x.OrderId == Order.OrderId) * var Product = db.Products.where(x => x.StoreId == store.StoreId) * * db.Orders.RemoveRange(Order); * db.OrderDetails.RemoveRange(OrderDetail); * db.Products.RemoveRange(Product); * db.Stores.Remove(store);*/ }
public ActionResult Edit(enquiry_info enquiry_info) { if (ModelState.IsValid) { for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName); attachments_info attachment_info = new attachments_info() { fileName = fileName, cid = enquiry_info.Id }; var extension = Path.GetExtension(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName); file.SaveAs(path); db.Entry(attachment_info).State = EntityState.Added; } } db.Entry(enquiry_info).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid); return(View(enquiry_info)); }
// GET: enquiry_info/Delete/5 /* public ActionResult Delete(long? id) * { * if (id == null) * { * return new HttpStatusCodeResult(HttpStatusCode.BadRequest); * } * enquiry_info enquiry_info = db.enquiry.Find(id); * if (enquiry_info == null) * { * return HttpNotFound(); * } * return View(enquiry_info); * } */ // POST: enquiry_info/Delete/5 /* [HttpPost, ActionName("Delete")] * [ValidateAntiForgeryToken] */ public ActionResult DeleteConfirmed(long id) { enquiry_info enquiry_info = db.enquiry.Find(id); db.enquiry.Remove(enquiry_info); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(enquiry_info enquiry_info, string search) { var userexist = db.client_info.Where(m => m.email_id == search).SingleOrDefault(); if (ModelState.IsValid) { if (userexist != null) { List <attachments_info> attachment = new List <attachments_info>(); for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName); attachments_info attachment_info = new attachments_info() { fileName = fileName }; attachment.Add(attachment_info); var extension = Path.GetExtension(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName); file.SaveAs(path); } } var q = from c in db.client_info where c.email_id == search select c; foreach (var cust in q) { enquiry_info.cid = cust.id; } db.enquiry.Add(enquiry_info); enquiry_info.attachments = attachment; db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Email does not exists"); return(View(enquiry_info)); } } ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid); return(View(enquiry_info)); }
public ActionResult Edit([Bind(Include = "Id,cid,projectname,source,remark1,status,tag")] enquiry_info enquiry_info) { if (ModelState.IsValid) { db.Entry(enquiry_info).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid); return(View(enquiry_info)); }
// GET: enquiry_info/Edit/5 public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } enquiry_info enquiry_info = db.enquiry.Find(id); if (enquiry_info == null) { return(HttpNotFound()); } ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid); return(View(enquiry_info)); }
// GET: enquiry_info/Details/5 public ActionResult Details(long?id, string search) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } enquiry_info enquiry_info = db.enquiry.Find(id); if (enquiry_info == null) { return(HttpNotFound()); } return(View(enquiry_info)); }
// GET: enquiry_info/Edit/5 public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } // enquiry_info enquiry_info = db.enquiry.Find(id); enquiry_info enquiry_info = db.enquiry.Include(s => s.attachments).SingleOrDefault(x => x.Id == id); if (enquiry_info == null) { return(HttpNotFound()); } ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid); return(View(enquiry_info)); }
public ActionResult Create([Bind(Include = "Id,eid,prop_enquiry,sentdate,sent_to,sent_via")] proposal_info proposal_info) { if (ModelState.IsValid) { /* var result = (from r in db.enquiry * join t in db.client_info on r.cid equals t.id * where r.projectname.ToLower().Contains(term.ToLower()) * select new { r.projectname, t.email_id, r.Id }); * * return Json(result, JsonRequestBehavior.AllowGet); */ // if (userexist != null) // { List <pros_attachments_info> attachment = new List <pros_attachments_info>(); for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName); pros_attachments_info attachment_info = new pros_attachments_info() { fileName = fileName }; attachment.Add(attachment_info); var extension = Path.GetExtension(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/PUpload/"), attachment_info.fileName); file.SaveAs(path); } } /* var q = from c in db.enquiry where c.projectname == proposal_info.prop_enquiry select c; * * if (q != null) * { * foreach (var cust in q) * { * proposal_info.eid = cust.Id; * } * } * else * { * proposal_info.eid = null; * } */ if (proposal_info.eid != null) { enquiry_info e_info = db.enquiry.Find(proposal_info.eid); e_info.status = Status.Proposal; db.Entry(e_info).State = EntityState.Modified; db.SaveChanges(); } db.proposal.Add(proposal_info); proposal_info.pros_attachments = attachment; db.SaveChanges(); return(RedirectToAction("Index")); // } /* else * { * ModelState.AddModelError("", "project doesnot exists"); * * return View(proposal_info); * * }*/ } ViewBag.cid = new SelectList(db.enquiry, "id", "projectname", proposal_info.eid); return(View(proposal_info)); /* if (ModelState.IsValid) * { * db.proposal.Add(proposal_info); * db.SaveChanges(); * return RedirectToAction("Index"); * } * * ViewBag.eid = new SelectList(db.enquiry, "Id", "projectname", proposal_info.eid); * return View(proposal_info); */ }