public void check_file(HttpPostedFileBase file, ProcurementAndTenderModels procurementAndTenderModels, string type, int idNo) { if (file != null) { var allowedExtensions = new[] { ".pdf" }; var fileName = Path.GetFileName(file.FileName); var ext = Path.GetExtension(file.FileName); //getting the extension(ex-.jpg) if (allowedExtensions.Contains(ext)) //check what type of extension { string name = Path.GetFileNameWithoutExtension(fileName); //getting file name without extension string myfile = name + ext; //appending the name with id // store the file inside ~/project folder(Img) var path = Path.Combine(Server.MapPath("~/ProcurementAndTender/" + type + "/" + idNo.ToString()), myfile); if (type.Contains("spec")) { procurementAndTenderModels.SpecURL = Path.Combine("~/ProcurementAndTender/" + type + "/" + idNo.ToString(), myfile); } else if (type.Contains("notice")) { procurementAndTenderModels.NoticeURL = Path.Combine("~/ProcurementAndTender/" + type + "/" + idNo.ToString(), myfile); } else if (type.Contains("ITRef")) { procurementAndTenderModels.ITReferenceURL = Path.Combine("~/ProcurementAndTender/" + type + "/" + idNo.ToString(), myfile); } else if (type.Contains("LPRef")) { procurementAndTenderModels.LPReferenceURL = Path.Combine("~/ProcurementAndTender/" + type + "/" + idNo.ToString(), myfile); } file.SaveAs(path); } } }
public ActionResult EditCST(ProcurementAndTenderModels procurementAndTenderModels, HttpPostedFileBase fileTenderNotice, HttpPostedFileBase fileTenderSpecification) { allViewbags(); var PrevpathfileTenderNotice = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.NoticeURL).FirstOrDefault())); procurementAndTenderModels.NoticeURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.NoticeURL).FirstOrDefault(); if (System.IO.File.Exists(PrevpathfileTenderNotice) && fileTenderNotice != null) { System.IO.File.Delete(PrevpathfileTenderNotice); } var PrevpathfileTenderSpecification = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.SpecURL).FirstOrDefault())); procurementAndTenderModels.SpecURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.SpecURL).FirstOrDefault(); if (System.IO.File.Exists(PrevpathfileTenderSpecification) && fileTenderSpecification != null) { System.IO.File.Delete(PrevpathfileTenderSpecification); } string subPath = "~/ProcurementAndTender/" + "spec" + "/" + procurementAndTenderModels.ID.ToString(); // your code goes here bool exists = System.IO.Directory.Exists(Server.MapPath(subPath)); if (!exists) { System.IO.Directory.CreateDirectory(Server.MapPath(subPath)); } subPath = "~/ProcurementAndTender/" + "notice" + "/" + procurementAndTenderModels.ID.ToString(); exists = System.IO.Directory.Exists(Server.MapPath(subPath)); if (!exists) { System.IO.Directory.CreateDirectory(Server.MapPath(subPath)); } if (ModelState.IsValid) { check_file(fileTenderNotice, procurementAndTenderModels, "notice", procurementAndTenderModels.ID); check_file(fileTenderSpecification, procurementAndTenderModels, "spec", procurementAndTenderModels.ID); try { db.Set <ProcurementAndTenderModels>().AddOrUpdate(procurementAndTenderModels); //db.Entry(procurementAndTenderModels).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("", ex.Message.ToString()); return(View(procurementAndTenderModels)); } return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Model is not valid"); } return(View(procurementAndTenderModels)); }
public ActionResult Create(ProcurementAndTenderModels procurementAndTenderModels, HttpPostedFileBase fileITReference) { ViewBag.error = ""; allViewbags(); if (ModelState.IsValid) { try { db.ProcurementAndTenderModels.Add(procurementAndTenderModels); db.SaveChanges(); } catch (SqlException e) { if (e.ErrorCode == 2601) { Response.Write("Student already registered!"); return(View(procurementAndTenderModels)); } } catch (DbUpdateException ex) { var sqlException = ex.InnerException.InnerException as SqlException; if (sqlException != null && sqlException.Number == 2627) { //Response.Write("LeterNo already registered!"); ViewBag.error = "Record already registered!"; return(View(procurementAndTenderModels)); } } string subPath = "~/ProcurementAndTender/" + "ITRef" + "/" + procurementAndTenderModels.ID.ToString(); bool exists = System.IO.Directory.Exists(Server.MapPath(subPath)); if (!exists) { System.IO.Directory.CreateDirectory(Server.MapPath(subPath)); } check_file(fileITReference, procurementAndTenderModels, "ITRef", procurementAndTenderModels.ID); db.Set <ProcurementAndTenderModels>().AddOrUpdate(procurementAndTenderModels); //db.Entry(procurementAndTenderModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(procurementAndTenderModels)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProcurementAndTenderModels procurementAndTenderModels = db.ProcurementAndTenderModels.Find(id);//db.ProcurementAndTenderModels.FirstOrDefault(m => m.TenderNo == id); if (procurementAndTenderModels == null) { return(HttpNotFound()); } return(View(procurementAndTenderModels)); }
// GET: ProcurementAndTenderModels/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProcurementAndTenderModels procurementAndTenderModels = db.ProcurementAndTenderModels.Find(Convert.ToInt32(id));//db.ProcurementAndTenderModels.FirstOrDefault(m => m.ID == id); ; if (procurementAndTenderModels == null) { return(HttpNotFound()); } return(View(procurementAndTenderModels)); }
public ActionResult EditBill(int?id) { allViewbags(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProcurementAndTenderModels procurementAndTenderModels = db.ProcurementAndTenderModels.Where(m => m.ID == id).FirstOrDefault();//.FirstOrDefault(m => m == id); if (procurementAndTenderModels == null) { return(HttpNotFound()); } return(View(procurementAndTenderModels)); }
// GET: ProcurementAndTenderModels/Edit/5 public ActionResult Edit(int id) { allViewbags(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProcurementAndTenderModels procurementAndTenderModels = db.ProcurementAndTenderModels.Where(x => x.ID == id).AsNoTracking().FirstOrDefault();//FirstOrDefault(m => m.LetterNo == id); if (procurementAndTenderModels == null) { return(HttpNotFound()); } return(View(procurementAndTenderModels)); }
public ActionResult Edit(ProcurementAndTenderModels procurementAndTenderModels, //,TenderNo,CSTDate,OpeningDate,Remarks,SpecURL,NoticeURL,NumberOfPages,price,CSTForwardedTo,CSTAction,TenderNew,TypeOfTender, ApprovalLetterNo,LPDate,PurchaseType,DescriptionOfItems,PurchaseOrderNo,OrderDate,LPQuantity,LPAmount,lpDeno,Days,LastDateOfSupply,NameOfTheSupplier,PlaceOfDelivery,TimeExtentionUpto,LPReferenceURL, CRPurchaseOrderNo,CRNo,CRDate,D44BNo,D44BRecievingDate,RecievingQuantity,CRDeno,RequisitionNo,group, CINSPurchaseOrderNo,CINSCRNo,CINSDateOfRecieving,CINSRecievingQuantity,CINSDeno,CINSDisposal,CINSRemarks, BillPurchaseOrderNo,BillCRNo,FinancialCode, BillRecievingDate,BillForwardingPlace,BillForwardingDate,BillRemarks,BillTotalAmount,BFFC,BillType")] ProcurementAndTenderModels procurementAndTenderModels, HttpPostedFileBase fileITReference) { allViewbags(); var PrevpathfileITReference = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.ITReferenceURL).FirstOrDefault())); procurementAndTenderModels.ITReferenceURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.ITReferenceURL).FirstOrDefault(); if (System.IO.File.Exists(PrevpathfileITReference) && fileITReference != null) { System.IO.File.Delete(PrevpathfileITReference); } string subPath = "~/ProcurementAndTender/" + "ITRef" + "/" + procurementAndTenderModels.ID.ToString(); bool exists = System.IO.Directory.Exists(Server.MapPath(subPath)); if (!exists) { System.IO.Directory.CreateDirectory(Server.MapPath(subPath)); } if (ModelState.IsValid) { check_file(fileITReference, procurementAndTenderModels, "ITRef", procurementAndTenderModels.ID); try { //db.ProcurementAndTenderModels.Attach(procurementAndTenderModels); db.Set <ProcurementAndTenderModels>().AddOrUpdate(procurementAndTenderModels); //db.Entry(procurementAndTenderModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", ex.Message.ToString()); return(View(procurementAndTenderModels)); } } return(View(procurementAndTenderModels)); }
public ActionResult EditLP(ProcurementAndTenderModels procurementAndTenderModels, HttpPostedFileBase fileLPReference) { allViewbags(); var PrevpathfileLPReference = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.LPReferenceURL).FirstOrDefault())); procurementAndTenderModels.LPReferenceURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.LPReferenceURL).FirstOrDefault(); if (System.IO.File.Exists(PrevpathfileLPReference) && fileLPReference != null) { System.IO.File.Delete(PrevpathfileLPReference); } var subPath = "~/ProcurementAndTender/" + "LPRef" + "/" + procurementAndTenderModels.ID.ToString(); bool exists = System.IO.Directory.Exists(Server.MapPath(subPath)); if (!exists) { System.IO.Directory.CreateDirectory(Server.MapPath(subPath)); } if (ModelState.IsValid) { check_file(fileLPReference, procurementAndTenderModels, "LPRef", procurementAndTenderModels.ID); try { db.Set <ProcurementAndTenderModels>().AddOrUpdate(procurementAndTenderModels); //db.Entry(procurementAndTenderModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", "Model is not valid"); } } else { ModelState.AddModelError("", "Model is not valid"); } return(View(procurementAndTenderModels)); }
public ActionResult EditBill(ProcurementAndTenderModels procurementAndTenderModels) { allViewbags(); if (ModelState.IsValid) { try { db.Set <ProcurementAndTenderModels>().AddOrUpdate(procurementAndTenderModels); //db.Entry(procurementAndTenderModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", "Model is not valid"); //return RedirectToAction("Index"); } } return(View(procurementAndTenderModels)); }
public ActionResult DeleteConfirmed(int?id) { ProcurementAndTenderModels procurementAndTenderModels = db.ProcurementAndTenderModels.Find(id);//db.ProcurementAndTenderModels.FirstOrDefault(m=> m.TenderNo == id); var Prevpathfile1 = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.SpecURL).FirstOrDefault())); procurementAndTenderModels.SpecURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.SpecURL).FirstOrDefault(); if (System.IO.File.Exists(Prevpathfile1)) { System.IO.File.Delete(Prevpathfile1); } var Prevpathfile2 = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.NoticeURL).FirstOrDefault())); procurementAndTenderModels.SpecURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.NoticeURL).FirstOrDefault(); if (System.IO.File.Exists(Prevpathfile2)) { System.IO.File.Delete(Prevpathfile2); } var Prevpathfile3 = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.ITReferenceURL).FirstOrDefault())); procurementAndTenderModels.ITReferenceURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.ITReferenceURL).FirstOrDefault(); if (System.IO.File.Exists(Prevpathfile3)) { System.IO.File.Delete(Prevpathfile3); } var Prevpathfile4 = Path.Combine(Server.MapPath(db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.LPReferenceURL).FirstOrDefault())); procurementAndTenderModels.LPReferenceURL = db.ProcurementAndTenderModels.Where(m => m.ID == procurementAndTenderModels.ID).Select(m => m.LPReferenceURL).FirstOrDefault(); if (System.IO.File.Exists(Prevpathfile4)) { System.IO.File.Delete(Prevpathfile4); } db.ProcurementAndTenderModels.Remove(procurementAndTenderModels); db.SaveChanges(); return(RedirectToAction("Index")); }