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);
}
public int InsertPurchaseOrder(EntityPurchaseOrder entInvoice, List <EntityPurchaseOrderDetails> lstInvoice)
{
try
{
int?PO_ID = 0;
objData.STP_InsertPurchaseOrder(Convert.ToDateTime(entInvoice.PO_Date), ref PO_ID, Convert.ToInt32(entInvoice.VendorId), Convert.ToDecimal(entInvoice.PO_Amount));
foreach (EntityPurchaseOrderDetails entPurchaseDetails in lstInvoice)
{
tblPurchaseOrderDetail obj = new tblPurchaseOrderDetail()
{
PO_Id = PO_ID,
Product_Id = entPurchaseDetails.Product_Id,
Quantity = entPurchaseDetails.Quantity,
Rate = entPurchaseDetails.Rate,
Total = entPurchaseDetails.Total,
IsDelete = false
};
objData.tblPurchaseOrderDetails.InsertOnSubmit(obj);
}
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
