/// <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(); } }