/// <summary>
/// Bind Drop down data
/// </summary>
private void BindProjects()
{
//drpProject.DataSource = (new DashboardBLL()).GetProjects(Convert.ToInt32(Session["USER_ID"]));
drpProject.DataSource = (new ProjectBLL()).GetProjects("", "", "", "", Convert.ToInt32(Session["USER_ID"]));
drpProject.DataTextField = "ProjectName";
drpProject.DataValueField = "ProjectID";
drpProject.DataBind();
if (drpProject.Items.Count > 0)
{
DSH_PAPStatusList PAPStatusList = (new DashboardBLL()).GetRecentProject(Convert.ToInt32(Session["USER_ID"]));
if (PAPStatusList.Count > 0)
{
DSH_PAPStatusBO objPAPStatusBO = PAPStatusList[0];
drpProject.ClearSelection();
if (drpProject.Items.FindByValue(objPAPStatusBO.ProjectId.ToString()) != null)
{
drpProject.Items.FindByValue(objPAPStatusBO.ProjectId.ToString()).Selected = true;
}
objPAPStatusBO = null;
}
GetPAPStatus();
GetPAPStatusPie();
GetPAPStatusSpline();
}
else
{
phProjects.Visible = false;
}
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DSH_PAPStatusList GetProjectwisePAPStatus(int PROJECTID)
{
OracleConnection cnn = new OracleConnection(con);
DSH_PAPStatusBO objPAPStatus = null;
DSH_PAPStatusList PAPStatusList = new DSH_PAPStatusList();
OracleCommand cmd = new OracleCommand("USP_DSH_PAPSTATUS", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTIDIN", PROJECTID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objPAPStatus = new DSH_PAPStatusBO();
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTNAME")))
{
objPAPStatus.ProjectName = dr.GetString(dr.GetOrdinal("PROJECTNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ProjectCode")))
{
objPAPStatus.ProjectCode = dr.GetString(dr.GetOrdinal("ProjectCode"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PAPCount")))
{
objPAPStatus.PAPCount = dr.GetInt32(dr.GetOrdinal("PAPCount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PAPPaidCount")))
{
objPAPStatus.PAPPaidCount = dr.GetInt32(dr.GetOrdinal("PAPPaidCount"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PAPPendingPayCount")))
{
objPAPStatus.PAPPendingPayCount = dr.GetInt32(dr.GetOrdinal("PAPPendingPayCount"));
}
PAPStatusList.Add(objPAPStatus);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAPStatusList);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DSH_PAPStatusList GetProjectwisePAPBudgetForSpline(int PROJECTID)
{
OracleConnection cnn = new OracleConnection(con);
DSH_PAPStatusBO objPAPStatus = null;
DSH_PAPStatusList PAPStatusList = new DSH_PAPStatusList();
OracleCommand cmd = new OracleCommand("USP_DSH_PAPBUDGET", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PROJECTIDIN", PROJECTID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objPAPStatus = new DSH_PAPStatusBO();
if (!dr.IsDBNull(dr.GetOrdinal("est_value")))
{
objPAPStatus.est_value = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("est_value")));
}
if (!dr.IsDBNull(dr.GetOrdinal("expenseamount")))
{
objPAPStatus.expenseamount = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("expenseamount")));
}
if (!dr.IsDBNull(dr.GetOrdinal("BudDate")))
{
objPAPStatus.BudDate = dr.GetString(dr.GetOrdinal("BudDate"));
}
PAPStatusList.Add(objPAPStatus);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAPStatusList);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DSH_PAPStatusList GetRecentProject(int userID)
{
OracleConnection cnn = new OracleConnection(con);
DSH_PAPStatusBO objPAPStatus = null;
DSH_PAPStatusList PAPStatusList = new DSH_PAPStatusList();
OracleCommand cmd = new OracleCommand("USP_DSH_GET_RECENTPROJECT", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("USERID_", userID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objPAPStatus = new DSH_PAPStatusBO();
if (!dr.IsDBNull(dr.GetOrdinal("ProjectName")))
{
objPAPStatus.ProjectName = dr.GetString(dr.GetOrdinal("ProjectName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ProjectCode")))
{
objPAPStatus.ProjectCode = dr.GetString(dr.GetOrdinal("ProjectCode"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ProjectID")))
{
objPAPStatus.ProjectId = dr.GetInt32(dr.GetOrdinal("ProjectID"));
}
PAPStatusList.Add(objPAPStatus);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAPStatusList);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DSH_PAPStatusList GetProjectwisePAPStatusForPie()
{
OracleConnection cnn = new OracleConnection(con);
DSH_PAPStatusBO objPAPStatus = null;
DSH_PAPStatusList PAPStatusList = new DSH_PAPStatusList();
OracleCommand cmd = new OracleCommand("USP_DSH_PAPSTATUSFORPIEHOME", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objPAPStatus = new DSH_PAPStatusBO();
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTSTATUS")))
{
objPAPStatus.ProjectStatus = Convert.ToString(dr.GetValue(dr.GetOrdinal("PROJECTSTATUS")));
}
if (!dr.IsDBNull(dr.GetOrdinal("StatuCount")))
{
objPAPStatus.StatuCount = Convert.ToDouble(dr.GetValue(dr.GetOrdinal("StatuCount")));
}
PAPStatusList.Add(objPAPStatus);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(PAPStatusList);
}
