protected void BtnEdit_Click(object sender, EventArgs e) { int lintCnt = 0; try { List <EntityPurchaseOrderDetails> lstEdited = (List <EntityPurchaseOrderDetails>)Session["FromEdit"]; List <EntityPurchaseOrderDetails> lstUpdate = (List <EntityPurchaseOrderDetails>)Session["ForUpdate"]; EntityPurchaseOrder entPurchaseOrder = new EntityPurchaseOrder(); EntityPurchaseOrderDetails entPurchaseOrderDetails = new EntityPurchaseOrderDetails(); entPurchaseOrder.VendorId = Convert.ToInt32(ddlSupplier.SelectedValue); entPurchaseOrder.PO_Amount = Convert.ToDecimal(txtTotal.Text); entPurchaseOrder.PO_Date = Convert.ToDateTime(txtPurchaseDate.Text); lstEdited[0].Total = Convert.ToDecimal(txtTotal.Text); lintCnt = mobjDeptBLL.UpdatePurchaseOrderDetails(lstEdited, lstUpdate); if (lintCnt > 0) { GetPurchaseOrder(); lblMessage.Text = "Record Updated Successfully"; } else { lblMessage.Text = "Record Not Updated"; } } catch (Exception ex) { lblMessage.Text = ex.Message; } MultiView1.SetActiveView(View1); }
protected void BtnSave_Click(object sender, EventArgs e) { int Invoice = 0; EntityPurchaseOrder entPurchaseOrder = new EntityPurchaseOrder(); EntityPurchaseOrderDetails entPurchaseOrderDetails = new EntityPurchaseOrderDetails(); if (ddlSupplier.SelectedIndex == 0) { lblMsg.Text = "Please Select Supplier Name"; ddlSupplier.Focus(); return; } else { if (string.IsNullOrEmpty(txtPurchaseDate.Text.Trim())) { lblMsg.Text = "Please Selct Purchase Order Date"; CalPurchaseDate.Focus(); return; } else { entPurchaseOrder.VendorId = Convert.ToInt32(ddlSupplier.SelectedValue); entPurchaseOrder.PO_Amount = Convert.ToDecimal(txtTotal.Text); entPurchaseOrder.PO_Date = Convert.ToDateTime(txtPurchaseDate.Text); List <EntityPurchaseOrderDetails> lstInvoice = (List <EntityPurchaseOrderDetails>)Session["BillDetails"]; Invoice = mobjDeptBLL.InsertPurchaseOrder(entPurchaseOrder, lstInvoice); if (Invoice > 0) { GetPurchaseOrder(); lblMessage.Text = "Record Inserted Successfully...."; Session["update"] = Server.UrlEncode(System.DateTime.Now.ToString()); } else { lblMessage.Text = "Record Not Inserted..."; } Session["BillDetails"] = new List <EntityPurchaseOrderDetails>(); } } MultiView1.SetActiveView(View1); }
public EntityPurchaseOrderDetails GetPOQty(int PINo, int ProductId) { EntityPurchaseOrderDetails order = null; try { order = (from tbl in objData.tblPurchaseOrderDetails join tblPI in objData.tblPurchaseInvoices on tbl.PO_Id equals tblPI.PONo where tblPI.PINo == PINo && tbl.Product_Id == ProductId && tblPI.IsDelete == false select new EntityPurchaseOrderDetails { Quantity = tbl.Quantity, InvoiceQuantity = Convert.ToInt32(tbl.InvoiceQuantity) }).FirstOrDefault(); } catch (Exception ex) { throw ex; } return order; }
public EntityPurchaseOrderDetails GetItemDetails(int PONo, int ProductId) { EntityPurchaseOrderDetails obj = new EntityPurchaseOrderDetails(); try { obj = (from tbl in objData.tblProductMasters join tblPO in objData.tblPurchaseOrderDetails on tbl.ProductId equals tblPO.Product_Id where tblPO.IsDelete == false && tblPO.PO_Id == PONo && tblPO.Product_Id == ProductId select new EntityPurchaseOrderDetails { Product_Id = tbl.ProductId, ProductName = tbl.ProductName, Quantity = tblPO.Quantity, Rate = tblPO.Rate } ).FirstOrDefault(); } catch (Exception ex) { throw ex; } return obj; }