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