// modify in 3/11 public void selectGenerate(string supplierName, List<ReorderItem> list, List<ReorderItem> Orglist) { purchaseOrder po = new purchaseOrder(); po.purchaseOrderId = "PO" + supplierFacede.getCodeGeneratorValue_Lingna("PO"); po.supplierId = supplierFacede.getSupplier_Lingna(supplierName).supplierId; DateTime date = DateTime.Now; po.orderDate = date; po.status = "Pending"; supplierFacede.createPurchaseOrder_Lingna(po); foreach(ReorderItem r in Orglist) { supplierFacede.updateReorderItemStatus_Lingna(r.ReorderItemId, "Completed"); } foreach (ReorderItem n in list) { purchaseOrderDetail pod = new purchaseOrderDetail(); pod.purchaseOrderId = po.purchaseOrderId; string itemName = ConvertName(n.ItemName); pod.itemId = catalogueFacade.getItem_Lingna(itemName).itemId; pod.qty = n.QtyToOrder; pod.amount = n.Amount; supplierFacede.insertPurchaseOrderDetails_Lingna(po.purchaseOrderId, pod); } supplierFacede.updateCodeGeneratorValue_Lingna("PO"); }
public ActionResult DeleteConfirmed(int id) { purchaseOrder purchaseorder = db.purchaseOrder.Find(id); db.purchaseOrder.Remove(purchaseorder); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /purchaseOrder/Delete/5 public ActionResult Delete(int id = 0) { purchaseOrder purchaseorder = db.purchaseOrder.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } return(View(purchaseorder)); }
public ActionResult Edit(purchaseOrder purchaseorder) { if (ModelState.IsValid) { db.Entry(purchaseorder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.supplier = new SelectList(db.supplier, "id", "company", purchaseorder.supplier); return(View(purchaseorder)); }
// // GET: /purchaseOrder/Edit/5 public ActionResult Edit(int id = 0) { purchaseOrder purchaseorder = db.purchaseOrder.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } ViewBag.supplier = new SelectList(db.supplier, "id", "company", purchaseorder.supplier); return(View(purchaseorder)); }
public ActionResult Create(purchaseOrder purchaseorder) { if (ModelState.IsValid) { db.purchaseOrder.Add(purchaseorder); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.supplier = new SelectList(db.supplier, "id", "company", purchaseorder.supplier); return(View(purchaseorder)); }
//createPurchaseOrder_Lingna( ) public void createPurchaseOrder_Lingna(purchaseOrder po) { ctx.purchaseOrders.Add(po); ctx.SaveChanges(); }
protected void Button2_Click(object sender, EventArgs e) { try { if (txtPid != null && txtSname != null) { String pid = txtPid.Text.ToString(); String stringPid = convertStrToId(pid); String purPrice1 = txtPrice.Text.ToString(); decimal purchaseP = Convert.ToDecimal(purPrice1); int productID = Int32.Parse(stringPid); String quantity = txtQty.Text.ToString(); int qty = Int32.Parse(quantity); int purid; decimal allTotal = purchaseP * qty; var query = from s in db.products where s.productId == productID select s; foreach (product prod in query) { prod.productId = prod.productId; prod.url = prod.url; prod.productStatus = prod.productStatus; prod.description = prod.description; prod.productName = prod.productName; prod.qtyOnHand = prod.qtyOnHand + qty; prod.purchasePrice = prod.purchasePrice; prod.sellingPrice = prod.sellingPrice; prod.category = prod.category; prod.warranty = prod.warranty; } String StringDate = DateTime.Now.ToShortDateString(); DateTime nowDate = Convert.ToDateTime(StringDate); String purPrice = txtPrice.Text.ToString(); decimal purchasePrice = Convert.ToDecimal(purPrice); decimal total = qty * purchasePrice; String ss = DropDownList1.SelectedValue.ToString(); int sid = Int32.Parse(ss); purchaseOrder newPurchase = new purchaseOrder { purchaseDate = nowDate, totalAmount = total, purchaseStatus = "valid", supplier = sid }; db.purchaseOrders.InsertOnSubmit(newPurchase); db.SubmitChanges(); var query2 = (from p in db.purchaseOrders select p.purchaseId).Max(); purchaseItem newItem = new purchaseItem { purchaseId = query2, productId = productID, quantity = qty, unitPurchasePrice = purchaseP, totalPurchasePrice = allTotal }; db.purchaseItems.InsertOnSubmit(newItem); db.SubmitChanges(); string display = "Restock Successful !"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } } catch (Exception) { string display = "Please Select Product Or Supplier First !"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } }