/// <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>
/// MapData
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private LivelihoodBudgetCategoryBO MapData(IDataReader reader)
{
LivelihoodBudgetCategoryBO oLiveBudgCategoryBO = new LivelihoodBudgetCategoryBO();
if (ColumnExists(reader, "Liv_Bud_CategID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_CategID")))
{
oLiveBudgCategoryBO.Liv_Bud_CategID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Bud_CategID")));
}
if (ColumnExists(reader, "Liv_Bud_CategoryName") && !reader.IsDBNull(reader.GetOrdinal("Liv_Bud_CategoryName")))
{
oLiveBudgCategoryBO.Liv_Bud_CategoryName = reader.GetString(reader.GetOrdinal("Liv_Bud_CategoryName"));
}
return(oLiveBudgCategoryBO);
}
