protected void gvLkDescription_Sorting(object sender, GridViewSortEventArgs e) { SortExpression = e.SortExpression; DataTable dt = FundTypeData.GetFundTypeData(cbActiveOnly.Checked); SortDireaction = CommonHelper.GridSorting(gvLkDescription, dt, SortExpression, SortDireaction); }
protected void BindGridWithSort() { DataTable dt = new DataTable(); dt = FundTypeData.GetFundTypeData(cbActiveOnly.Checked); SortDireaction = CommonHelper.GridSorting(gvLkDescription, dt, SortExpression, SortDireaction != "" ? ViewState["SortDireaction"].ToString() : SortDireaction); }
protected void BindFundTypeData() { try { gvLkDescription.DataSource = FundTypeData.GetFundTypeData(cbActiveOnly.Checked); gvLkDescription.DataBind(); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }
public static string[] GetFundTypes(string prefixText, int count) { DataTable dt = new DataTable(); dt = FundTypeData.GetFundTypeDescription(prefixText); List <string> ftDesc = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { ftDesc.Add(dt.Rows[i][0].ToString()); } return(ftDesc.ToArray()); }
protected void gvLkDescription_RowUpdating(object sender, GridViewUpdateEventArgs e) { int rowIndex = e.RowIndex; string lkDescription = ((TextBox)gvLkDescription.Rows[rowIndex].FindControl("txtDesc")).Text; int typeid = Convert.ToInt32(((Label)gvLkDescription.Rows[rowIndex].FindControl("lbltypeid")).Text); bool isActive = Convert.ToBoolean(((CheckBox)gvLkDescription.Rows[rowIndex].FindControl("chkActiveEdit")).Checked); FundTypeData.UpdateFundType(lkDescription, typeid, isActive); gvLkDescription.EditIndex = -1; BindFundTypeData(); lblErrorMsg.Text = "FundType description updated successfully"; txtDescription.Text = ""; }
protected void BindfundType() { try { ddlLkLookupViewname.DataSource = FundTypeData.GetFundType("GetFundType"); ddlLkLookupViewname.DataValueField = "TypeId"; ddlLkLookupViewname.DataTextField = "Description"; ddlLkLookupViewname.DataBind(); ddlLkLookupViewname.Items.Insert(0, new ListItem("Select", "NA")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (ddlLkLookupViewname.SelectedIndex != 0 && txtDescription.Text != "") { FundTypeData.AddFundType(txtDescription.Text, Convert.ToInt32(ddlLkLookupViewname.SelectedValue.ToString())); lblErrorMsg.Text = "Fund Type saved successfully"; BindFundTypeData(); txtDescription.Text = ""; } else { lblErrorMsg.Text = "Please select fund type source and add description"; } } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }
protected void BindLookups() { try { dtable = new DataTable(); dtable = FundTypeData.GetFundType("GetFundTypeData"); ddlFundType.DataSource = dtable; ddlFundType.DataValueField = "typeid"; ddlFundType.DataTextField = "description"; ddlFundType.DataBind(); ddlFundType.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkAcctMethod"); ddlAcctMethod.DataSource = dtable; ddlAcctMethod.DataValueField = "typeid"; ddlAcctMethod.DataTextField = "description"; ddlAcctMethod.DataBind(); ddlAcctMethod.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkGrantor"); ddlGrantor.DataSource = dtable; ddlGrantor.DataValueField = "typeid"; ddlGrantor.DataTextField = "description"; ddlGrantor.DataBind(); ddlGrantor.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LkYear"); ddlFiscalYr.DataSource = dtable; ddlFiscalYr.DataValueField = "typeid"; ddlFiscalYr.DataTextField = "description"; ddlFiscalYr.DataBind(); ddlFiscalYr.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetLookupDetailsByName("LKGrantSource"); ddlGrantSource.DataSource = dtable; ddlGrantSource.DataValueField = "typeid"; ddlGrantSource.DataTextField = "description"; ddlGrantSource.DataBind(); ddlGrantSource.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetDataTableByProcName("GetStaffUsers"); ddlStaff.DataSource = dtable; ddlStaff.DataValueField = "userid"; ddlStaff.DataTextField = "name"; ddlStaff.DataBind(); ddlStaff.Items.Insert(0, new ListItem("Select", "NA")); dtable = new DataTable(); dtable = FinancialTransactions.GetDataTableByProcName("GetContactUsers"); ddlContact.DataSource = dtable; ddlContact.DataValueField = "contactid"; ddlContact.DataTextField = "name"; ddlContact.DataBind(); ddlContact.Items.Insert(0, new ListItem("Select", "NA")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message; } }