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