public ActionResult DeleteConfirmed(int id) { PReturns pReturns = db.pReturns.Find(id); db.pReturns.Remove(pReturns); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PReturns pReturns = db.pReturns.Find(id); if (pReturns == null) { return(HttpNotFound()); } return(View(pReturns)); }
//"PReturnID,InvoiceNo,InvoiceDate,SupplierID,PPDiscountTotal,DiscountPercent,DiscountTotal,TotalNet //,BackAmount,Remarks,TotalDue,Status,VATTotal,AdjustmentAmount,PaidAmount,GrandPriceTotal, // CreateDate,CreatedBy,ModifiedDate,ModifiedDateBy,VendorID" // GET: PReturns/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PReturns pReturns = db.pReturns.Find(id); if (pReturns == null) { return(HttpNotFound()); } ViewBag.Supplier1 = new SelectList(db.masterSuppliers, "SupplierID", "Name"); ViewBag.Vendor1 = new SelectList(db.masterVendors, "VendorID", "Name"); return(View(pReturns)); }
public ActionResult Create(PReturns cvm) { PReturns cat = new PReturns(); //cat.InvoiceNo = cvm.InvoiceNo; if (cvm.InvoiceNo == null) { cat.InvoiceNo = "00002";//cvm.Code; } else { int maxcode = Convert.ToInt32(cvm.InvoiceNo); maxcode = maxcode + 1; //int getfinalcode = maxcode + maxcode; cat.InvoiceNo = "0000" + maxcode.ToString(); } cat.InvoiceDate = cvm.InvoiceDate; cat.VendorID = cvm.VendorID; cat.PPDiscountTotal = cvm.PPDiscountTotal; cat.DiscountPercent = cvm.DiscountPercent; cat.DiscountTotal = cvm.DiscountTotal; cat.TotalNet = cvm.TotalNet; cat.BackAmount = cvm.BackAmount; cat.Remarks = cvm.Remarks; cat.TotalDue = cvm.TotalDue; cat.VATTotal = cvm.VATTotal; cat.AdjustmentAmount = cvm.AdjustmentAmount; cat.PaidAmount = cvm.PaidAmount; cat.GrandPriceTotal = cvm.GrandPriceTotal; cat.CreateDate = cvm.CreateDate; cat.CreatedBy = cvm.CreatedBy; cat.ModifiedDate = cvm.ModifiedDate; cat.ModifiedDateBy = cvm.ModifiedDateBy; cat.VendorID = cvm.VendorID; cat.SupplierID = cvm.SupplierID; cat.Status = false; if (cvm.Statusex == "Yes") { cat.Status = true; } db.pReturns.Add(cat); db.SaveChanges(); ViewBag.Supplier1 = new SelectList(db.masterSuppliers, "SupplierID", "Name"); ViewBag.Vendor1 = new SelectList(db.masterVendors, "VendorID", "Name"); return(RedirectToAction("Index")); }
public ActionResult Create() { ViewBag.Supplier1 = new SelectList(db.masterSuppliers, "SupplierID", "Name"); ViewBag.Vendor1 = new SelectList(db.masterVendors, "VendorID", "Name"); var getprodcut = db.pReturns.FirstOrDefault(); var mspro = new PReturns(); if (getprodcut != null) { var maxcode = db.pReturns.OrderByDescending(x => x.PReturnID).Select(x => x.InvoiceNo).FirstOrDefault(); if (maxcode != null) { mspro.InvoiceNo = maxcode.ToString(); } } return(View(mspro)); }
public ActionResult Edit(PReturns cvm) { var cat = db.pReturns.Where(x => x.PReturnID == cvm.PReturnID).FirstOrDefault(); cat.InvoiceNo = cvm.InvoiceNo; cat.InvoiceDate = cvm.InvoiceDate; cat.VendorID = cvm.VendorID; cat.PPDiscountTotal = cvm.PPDiscountTotal; cat.DiscountPercent = cvm.DiscountPercent; cat.DiscountTotal = cvm.DiscountTotal; cat.TotalNet = cvm.TotalNet; cat.BackAmount = cvm.BackAmount; cat.Remarks = cvm.Remarks; cat.TotalDue = cvm.TotalDue; cat.VATTotal = cvm.VATTotal; cat.AdjustmentAmount = cvm.AdjustmentAmount; cat.PaidAmount = cvm.PaidAmount; cat.GrandPriceTotal = cvm.GrandPriceTotal; cat.CreateDate = cvm.CreateDate; cat.CreatedBy = cvm.CreatedBy; cat.ModifiedDate = cvm.ModifiedDate; cat.ModifiedDateBy = cvm.ModifiedDateBy; cat.VendorID = cvm.VendorID; cat.SupplierID = cvm.SupplierID; cat.Status = false; if (cvm.Statusex == "Yes") { cat.Status = true; } db.pReturns.Add(cat); db.SaveChanges(); ViewBag.Supplier1 = new SelectList(db.masterSuppliers, "SupplierID", "Name"); ViewBag.Vendor1 = new SelectList(db.masterVendors, "VendorID", "Name"); return(RedirectToAction("Index")); }