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