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