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