private void LoadCashLimit() { BLL_PB_Admin ObjBLLPBAdmin = new BLL_PB_Admin(); DataTable dtCashLimit = ObjBLLPBAdmin.GetCashAdvanceLimit(); GridView_CashLimit.DataSource = dtCashLimit; GridView_CashLimit.DataBind(); }
private void SaveCashLimit() { BLL_PB_Admin ObjBLLPBAdmin = new BLL_PB_Admin(); int ID = 0; int RankCatID = Convert.ToInt32(ddlRnkCat.SelectedValue); int Percent = Convert.ToInt32(txtPercent.Text == ""?"0":txtPercent.Text.Trim()); ObjBLLPBAdmin.INS_CASH_ADV_LIMIT(0, RankCatID, Percent, (GetSessionUserID()), "A"); }
protected void GridView_CashLimit_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = (GridViewRow)GridView_CashLimit.Rows[e.RowIndex]; int ID = UDFLib.ConvertToInteger(GridView_CashLimit.DataKeys[e.RowIndex].Values[0].ToString()); BLL_PB_Admin ObjBLLPBAdmin = new BLL_PB_Admin(); int result = ObjBLLPBAdmin.INS_CASH_ADV_LIMIT(ID, null, null, GetSessionUserID(), "D"); LoadCashLimit(); LoadRankCategory(); }
private void LoadRankCategory() { BLL_PB_Admin ObjBLLPBAdmin = new BLL_PB_Admin(); DataTable dt = ObjBLLPBAdmin.GetRankCashAdvanceLimit(); ddlRnkCat.DataSource = dt; if (dt.Rows.Count > 0) { ddlRnkCat.DataTextField = Convert.ToString(dt.Columns["Category_Name"]); ddlRnkCat.DataValueField = Convert.ToString(dt.Columns["ID"]); ddlRnkCat.DataBind(); ddlRnkCat.Items.Insert(0, new ListItem("-Select-", "0")); } else { ddlRnkCat.Items.Insert(0, new ListItem("-Select-", "0")); ddlRnkCat.SelectedIndex = 0; } }
protected void GridView_CashLimit_RowUpdating(object sender, GridViewUpdateEventArgs e) { BLL_PB_Admin ObjBLLPBAdmin = new BLL_PB_Admin(); try { int ID = UDFLib.ConvertToInteger(GridView_CashLimit.DataKeys[e.RowIndex].Values[0].ToString()); GridViewRow row = (GridViewRow)GridView_CashLimit.Rows[e.RowIndex]; if (ValidateInput(((DropDownList)row.FindControl("ddlRankCat")).SelectedValue, ((TextBox)row.FindControl("txtPercentage")).Text) == true) { int result = ObjBLLPBAdmin.INS_CASH_ADV_LIMIT(ID, Convert.ToInt32(((DropDownList)row.FindControl("ddlRankCat")).SelectedValue), Convert.ToInt32(((TextBox)row.FindControl("txtPercentage")).Text), GetSessionUserID(), "U"); GridView_CashLimit.EditIndex = -1; LoadCashLimit(); } } catch { } }