/// <summary>
/// get all data by ID
/// </summary>
/// <param name="LivRestBudgID"></param>
/// <returns></returns>
public LivelihoodRestBudgetBO GetLiveRestBudgetById(int LivRestBudgID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_LIV_RES_BUDG_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);
LivelihoodRestBudgetBO objLivelihoodRestBudgetBO = null;
LivelihoodRestBudgetList oLivelihoodRestBudgetList = new LivelihoodRestBudgetList();
objLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();
while (dr.Read())
{
objLivelihoodRestBudgetBO = MapData(dr);
}
dr.Close();
return(objLivelihoodRestBudgetBO);
}
/// <summary>
/// get all data
/// </summary>
/// <param name="projectID"></param>
/// <returns></returns>
public LivelihoodRestBudgetList GetLiveRestBudget(int projectID)
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_LIV_RES_BUDG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("projectid_", projectID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LivelihoodRestBudgetBO objLivelihoodRestBudgetBO = null;
LivelihoodRestBudgetList oLivelihoodRestBudgetList = new LivelihoodRestBudgetList();
while (dr.Read())
{
objLivelihoodRestBudgetBO = new LivelihoodRestBudgetBO();
objLivelihoodRestBudgetBO = MapData(dr);
oLivelihoodRestBudgetList.Add(objLivelihoodRestBudgetBO);
}
dr.Close();
return(oLivelihoodRestBudgetList);
}
/// <summary>
/// Bind Data to Grid
/// </summary>
private void BindGrid()
{
// LivelihoodRestBudgetBO oLiveRestBudgetBO = new LivelihoodRestBudgetBO();
LivelihoodRestBudgetList lstLiveRestBudget = new LivelihoodRestBudgetList();
LivelihoodRestBudgetBLL oLivRestPlanBLL = new LivelihoodRestBudgetBLL();
lstLiveRestBudget = oLivRestPlanBLL.GetLiveRestBudget(Convert.ToInt32(Session["PROJECT_ID"]));
if (lstLiveRestBudget.Count > 0)
{
grdRestBudget.DataSource = lstLiveRestBudget;
grdRestBudget.DataBind();
}
else
{
grdRestBudget.DataSource = null;
grdRestBudget.DataBind();
}
}
