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