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