public JsonResult DeleteFile(long?id) { if (id == null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json(new { Result = "Error" })); } try { // Guid guid = new Guid(id); pros_attachments_info fileDetail = db.pros_attachment.Find(id); if (fileDetail == null) { Response.StatusCode = (int)HttpStatusCode.NotFound; return(Json(new { Result = "Error" })); } //Remove from database db.pros_attachment.Remove(fileDetail); db.SaveChanges(); //Delete file from the file system var path = Path.Combine(Server.MapPath("~/App_Data/PUpload/"), fileDetail.fileName); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } return(Json(new { Result = "OK" })); } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }
public ActionResult Edit(proposal_info proposal_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); pros_attachments_info attachment_info = new pros_attachments_info() { fileName = fileName, pid = proposal_info.Id }; var extension = Path.GetExtension(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/PUpload/"), attachment_info.fileName); file.SaveAs(path); db.Entry(attachment_info).State = EntityState.Added; } } db.Entry(proposal_info).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.eid = new SelectList(db.enquiry, "Id", "projectname", proposal_info.eid); return(View(proposal_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); */ }