protected void gvPurchaseBill_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//*****************
BusinessLayer.PurchaseOrder.PurchaseOrderEntry objPOE = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
int PurchaseBillId = int.Parse(gvPurchaseBill.DataKeys[e.RowIndex].Value.ToString());
objPOE.Delete(PurchaseBillId);
getPurchaseBill();
}
private void getPurchaseBill()
{
BusinessLayer.PurchaseOrder.PurchaseOrderEntry objPOE = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
DataTable dt;
dt = objPOE.GetPurchaseBill();
if (dt != null)
{
gvPurchaseBill.DataSource = dt;
gvPurchaseBill.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strValues = txtBillDate.Text;
strValues += chr.ToString() + "";
DataSet ds_fn = gf.ExecuteSelectSP("spSelect_GetFnYear", strValues);
if (ds_fn.Tables[0].Rows[0]["FinYearID"].ToString() == Session["FinYrID"].ToString().Trim())
{
if (Validate())
{
BusinessLayer.PurchaseOrder.PurchaseOrderEntry ObjPO = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
Entity.PurchaseOrder.PurchaseOrderEntry PO = new Entity.PurchaseOrder.PurchaseOrderEntry();
PO.PurchaseBillId = PurchaseBillId;
PO.BillNo = txtBillNo.Text.Trim();
PO.BillDate = Convert.ToDateTime(txtBillDate.Text.Trim());
PO.BillAmount = decimal.Parse(txtBillAmt.Text.Trim());
PO.SupplierLedgerID_FK = int.Parse(ddlSupplier.SelectedValue);
PO.PurchaseLedgerID_FK = int.Parse(ddlPurchaseLedger.SelectedValue.Trim());
PO.CompanyID_FK = Convert.ToInt32(Session["CompanyId"].ToString());
PO.BranchID_FK = Convert.ToInt32(Session["BranchId"].ToString());
PO.FinYearID_FK = Convert.ToInt32(Session["FinYrID"].ToString());
PO.DataFlow = Convert.ToInt32(Session["DataFlow"].ToString());
PO.Narration = txtNarration.Text.Trim();
PO.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name);
PO.ModifiedBy = int.Parse(HttpContext.Current.User.Identity.Name);
int RowsAffected = ObjPO.Save(PO);
if (RowsAffected != -1)
{
Message.IsSuccess = true;
Message.Text = "Data Saved Successfully";
ClearControls();
LoadPOList();
}
else
{
Message.IsSuccess = false;
Message.Text = "Can Not Save. Duplicate Bill No is Not Allowed. Please Check";
}
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Please select a Date Between " + Session["SesFromDate"].ToString() + " & " + Session["SesToDate"].ToString() + "";
}
Message.Show = true;
}
protected void LoadPOList()
{
string BillNo = txtBillNoSearch.Text.Trim();
string FromDate = txtFromDate.Text.Trim();
string ToDate = txtToDate.Text.Trim();
BusinessLayer.PurchaseOrder.PurchaseOrderEntry ObjPO = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
DataView dv = new DataView(ObjPO.GetAll(BillNo, FromDate, ToDate));
if (dv != null)
{
dv.RowFilter = "CompanyID_FK=" + Convert.ToInt32(Session["CompanyId"].ToString()) + " and FinYearID_FK=" + Convert.ToInt32(Session["FinYrID"].ToString());
dgvPO.DataSource = dv.ToTable();
dgvPO.DataBind();
}
}
protected void LoadPODetails()
{
BusinessLayer.PurchaseOrder.PurchaseOrderEntry ObjPO = new BusinessLayer.PurchaseOrder.PurchaseOrderEntry();
Entity.PurchaseOrder.PurchaseOrderEntry PO = new Entity.PurchaseOrder.PurchaseOrderEntry();
PO = ObjPO.GetAllById(PurchaseBillId);
if (PO != null)
{
txtBillNo.Text = PO.BillNo;
txtBillDate.Text = PO.BillDate.ToString("dd MMM yyyy");
txtBillAmt.Text = PO.BillAmount.ToString("#0.00");
ddlSupplier.SelectedValue = PO.SupplierLedgerID_FK.ToString();
ddlPurchaseLedger.SelectedValue = PO.PurchaseLedgerID_FK.ToString();
txtNarration.Text = PO.Narration.ToString();
btnSave.Text = "Update";
Message.Show = false;
}
}
