/// <summary>
/// get all data
/// </summary>
/// <returns></returns>
public LivelihoodBudgetCategoryList GetLiveBudgCategory()
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_MST_GET_LIV_BDG_CATEG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LivelihoodBudgetCategoryBO oLiveBudgCategoryBO = null;
LivelihoodBudgetCategoryList oLivBudgCategorylst = new LivelihoodBudgetCategoryList();
while (dr.Read())
{
oLiveBudgCategoryBO = new LivelihoodBudgetCategoryBO();
//objConcern.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID")));
//objConcern.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN"));
//objConcern.ConcernIsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
oLiveBudgCategoryBO = MapData(dr);
oLivBudgCategorylst.Add(oLiveBudgCategoryBO);
}
dr.Close();
return(oLivBudgCategorylst);
}
/// <summary>
/// Bind Data to Drop Downs
/// </summary>
private void LoadCategory()
{
LivelihoodBudgetCategoryBLL oLiveBudgCategoryBLL = new LivelihoodBudgetCategoryBLL();
LivelihoodBudgetCategoryList oLiveBudgCategoryList = new LivelihoodBudgetCategoryList();
oLiveBudgCategoryList = oLiveBudgCategoryBLL.GetLivBdgCategory();
ddlCategory.DataSource = oLiveBudgCategoryList;
ddlCategory.DataTextField = "Liv_Bud_CategoryName";
ddlCategory.DataValueField = "Liv_Bud_CategID";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, (new ListItem("--Select--", "0")));
ddlCategory.SelectedIndex = 0;
}