/// <summary> /// Check CDAP Request Status /// </summary> private void CheckPendings() { objCDAPBudgetBLL = new CDAPBudgetBLL(); int ProjectID = Convert.ToInt32(Session["PROJECT_ID"].ToString()); string Status = "ALL"; objCDAPBudgetList = objCDAPBudgetBLL.GetCDAPBudget(ProjectID, Status); int iCount = 0; for (int i = 0; i < objCDAPBudgetList.Count; i++) { if (objCDAPBudgetList[i].FundReqStatus.ToString().ToUpper() == "Pending Approval".ToUpper() || objCDAPBudgetList[i].FundReqStatus.ToString().ToUpper() == "Declined".ToUpper()) { iCount++; } } if (iCount > 0) { checkApprovalExitOrNot(); //btnApproval.Visible = true; } else { btnApproval.Visible = false; } }
/// <summary> /// get data from data base abd bind it to grid /// </summary> private void BindGrid() { objCDAPBudgetBLL = new CDAPBudgetBLL(); int ProjectID = Convert.ToInt32(Session["PROJECT_ID"].ToString()); string Status = "ALL"; objCDAPBudgetList = objCDAPBudgetBLL.GetCDAPBudget(ProjectID, Status); grdCDAPBudget.DataSource = objCDAPBudgetList; grdCDAPBudget.DataBind(); }
/// <summary> /// To Get CDAP Budget from database /// </summary> /// <param name="ProjectID"></param> /// <param name="Status"></param> /// <returns></returns> public CDAPBudgetList GetCDAPBudget(int ProjectID, string Status) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_TRN_CDAP_BUDG"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PROJECTID_", ProjectID); cmd.Parameters.Add("Status_", Status); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CDAPBudgetBO objCDAPBudgetBO = null; CDAPBudgetList CDAPBudget = new CDAPBudgetList(); while (dr.Read()) { objCDAPBudgetBO = new CDAPBudgetBO(); if (!dr.IsDBNull(dr.GetOrdinal("CDAP_BUDGID"))) { objCDAPBudgetBO.Cdap_budgid = dr.GetInt32(dr.GetOrdinal("CDAP_BUDGID")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_CATEGORYNAME"))) { objCDAPBudgetBO.Cdap_categoryname = dr.GetString(dr.GetOrdinal("CDAP_CATEGORYNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_SUBCATEGORYNAME"))) { objCDAPBudgetBO.Cdap_subcategoryname = dr.GetString(dr.GetOrdinal("CDAP_SUBCATEGORYNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("UNITNAME"))) { objCDAPBudgetBO.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("QUANTITY"))) { objCDAPBudgetBO.Quantity = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("QUANTITY"))); } if (!dr.IsDBNull(dr.GetOrdinal("RATEPERUNIT"))) { objCDAPBudgetBO.Rateperunit = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("RATEPERUNIT"))); } if (!dr.IsDBNull(dr.GetOrdinal("FUNDREQSTATUS"))) { objCDAPBudgetBO.FundReqStatus = dr.GetString(dr.GetOrdinal("FUNDREQSTATUS")); } CDAPBudget.Add(objCDAPBudgetBO); } dr.Close(); return(CDAPBudget); }