/// <summary>
/// To Get Live Rest Bud Villages By Id
/// </summary>
/// <param name="LivRestBudgID"></param>
/// <returns></returns>
public LiveRestBudVillagesList GetLiveRestBudVillagesById(int LivRestBudgID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_LIV_BUD_VILLG_BYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("liv_res_budgid_", LivRestBudgID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LiveRestBudVillagesBO oLiveRestBudVillagesBO = null;
LiveRestBudVillagesList oLiveRestBudVillagesList = new LiveRestBudVillagesList();
while (dr.Read())
{
oLiveRestBudVillagesBO = new LiveRestBudVillagesBO();
oLiveRestBudVillagesBO = MapData(dr);
oLiveRestBudVillagesList.Add(oLiveRestBudVillagesBO);
}
dr.Close();
return(oLiveRestBudVillagesList);
}
//get all data in mst_Concern table using USP_MST_SELECTCONCERN-SP
/// <summary>
/// To Get Live Rest Bud Villages
/// </summary>
/// <returns></returns>
public LiveRestBudVillagesList GetLiveRestBudVillages()
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_LIVRESBUD_VILLAGE";
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);
LiveRestBudVillagesBO objLiveRestBudVillagesBO = null;
LiveRestBudVillagesList oLiveRestBudVillagesList = new LiveRestBudVillagesList();
while (dr.Read())
{
objLiveRestBudVillagesBO = new LiveRestBudVillagesBO();
objLiveRestBudVillagesBO = MapData(dr);
oLiveRestBudVillagesList.Add(objLiveRestBudVillagesBO);
}
dr.Close();
return(oLiveRestBudVillagesList);
}
