public void Insert(int? InvoiceNumber,int? SupplierID,decimal? EstimatedAmount,DateTime? EstimationDate,decimal? Amount,DateTime? DatePassed,string PurchaseInvNumber,string Remarks,decimal? ValueForProfit,byte[] Mstimestamp) { PurchaseTable item = new PurchaseTable(); item.InvoiceNumber = InvoiceNumber; item.SupplierID = SupplierID; item.EstimatedAmount = EstimatedAmount; item.EstimationDate = EstimationDate; item.Amount = Amount; item.DatePassed = DatePassed; item.PurchaseInvNumber = PurchaseInvNumber; item.Remarks = Remarks; item.ValueForProfit = ValueForProfit; item.Mstimestamp = Mstimestamp; item.Save(UserName); }
public ActionResult DeleteConfirmed(int id) { PurchaseTable purchaseTable = db.PurchaseTables.Find(id); db.PurchaseTables.Remove(purchaseTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "purchaseID,UserID,PurchaseDate,PurchaseAmount,SuplierID")] PurchaseTable purchaseTable) { if (ModelState.IsValid) { db.Entry(purchaseTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SuplierID = new SelectList(db.SuplierTables, "SuplierID", "SuplierName", purchaseTable.SuplierID); ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", purchaseTable.UserID); return(View(purchaseTable)); }
// GET: PurchaseTables/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PurchaseTable purchaseTable = db.PurchaseTables.Find(id); if (purchaseTable == null) { return(HttpNotFound()); } return(View(purchaseTable)); }
// GET: PurchaseTables/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PurchaseTable purchaseTable = db.PurchaseTables.Find(id); if (purchaseTable == null) { return(HttpNotFound()); } ViewBag.SuplierID = new SelectList(db.SuplierTables, "SuplierID", "SuplierName", purchaseTable.SuplierID); ViewBag.UserID = new SelectList(db.UserTables, "UserID", "UserName", purchaseTable.UserID); return(View(purchaseTable)); }
public ActionResult PurchaseConfirm(FormCollection collection) { if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"]))) { return(RedirectToAction("Login", "Home")); } int userid = Convert.ToInt32(Convert.ToString(Session["UserID"])); int supplierid = 0; string[] keys = collection.AllKeys; foreach (var name in keys) { if (name.Contains("name")) { string idname = name; string[] valueids = idname.Split(' '); supplierid = Convert.ToInt32(valueids[1]); } } var purchasedetails = db.PurTemDetailsTables.ToList(); double totalamount = 0; foreach (var item in purchasedetails) { totalamount = totalamount + (item.Qty * item.UnitPrice); } if (totalamount == 0) { ViewBag.Message = "Zamówienie jest puste"; return(View("NewPurchase")); } var purchaseheader = new PurchaseTable(); purchaseheader.SupplierID = supplierid; purchaseheader.PurchaseDate = DateTime.Now; purchaseheader.PurchaseAmount = totalamount; purchaseheader.UserID = userid; db.PurchaseTables.Add(purchaseheader); db.SaveChanges(); foreach (var item in purchasedetails) { var purdetails = new PurchaseDetailTable() { BookID = item.BookID, PurchaseID = purchaseheader.PurchaseID, Qty = item.Qty, UnitPrice = item.UnitPrice }; db.PurchaseDetailTables.Add(purdetails); db.SaveChanges(); var updatebookstock = db.BookTables.Find(item.BookID); updatebookstock.TotalCopies = updatebookstock.TotalCopies + item.Qty; updatebookstock.Price = item.UnitPrice; db.Entry(updatebookstock).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } ViewBag.Message = "Zamówiono pomyślnie"; return(RedirectToAction("AllPurchase")); }