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