/// <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> /// Bind Chart data for Spiline /// </summary> private void GetPAPStatusSpline() { DashboardBLL objPAPStatusLogic = new DashboardBLL(); DSH_PAPStatusList PAPStatusList = objPAPStatusLogic.GetProjectwisePAPBudgetForSpline(Convert.ToInt32(drpProject.SelectedValue)); ProjectStatusSplineChart.Series["Series1"].Points.AddXY(0, 0); ProjectStatusSplineChart.Series["Series2"].Points.AddXY(0, 0); for (int i = 0; i < PAPStatusList.Count; i++) { ProjectStatusSplineChart.Series["Series1"].Points.AddXY(i + 1, PAPStatusList[i].est_value); ProjectStatusSplineChart.Series["Series2"].Points.AddXY(i + 1, PAPStatusList[i].expenseamount); } //ProjectStatusSplineChart.Series["Series1"].Points.AddXY(1, 5); //ProjectStatusSplineChart.Series["Series1"].Points.AddXY(2, 15); //ProjectStatusSplineChart.Series["Series1"].Points.AddXY(3, 10); //ProjectStatusSplineChart.Series["Series2"].Points.AddXY(0, 0); //ProjectStatusSplineChart.Series["Series2"].Points.AddXY(1, 10); //ProjectStatusSplineChart.Series["Series2"].Points.AddXY(2, 8); //ProjectStatusSplineChart.Series["Series2"].Points.AddXY(3, 20); for (int i = 0; i < PAPStatusList.Count + 1; i++) { CustomLabel lbl = new CustomLabel(); if (i == 0) { lbl.Text = ""; } else { lbl.Text = PAPStatusList[i - 1].BudDate.Substring(0, 3); } //else if (i == 1) // lbl.Text = "Feb"; //else if (i == 2) // lbl.Text = "Mar"; //else if (i == 3) // lbl.Text = "Apr"; lbl.FromPosition = i - 0.5; lbl.ToPosition = i + 0.5; ProjectStatusSplineChart.ChartAreas[0].AxisX.CustomLabels.Add(lbl); ProjectStatusSplineChart.ChartAreas[0].AxisX.LabelStyle.Angle = -90; } ProjectStatusSplineChart.ChartAreas["ChartArea1"].AxisX.IsStartedFromZero = true; ProjectStatusSplineChart.ChartAreas["ChartArea1"].AxisX.Minimum = 0; ProjectStatusSplineChart.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false; ProjectStatusSplineChart.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.LightGray; }
/// <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); }
/// <summary> /// Bind Chart data for Pie /// </summary> private void GetPAPStatusPie() { DashboardBLL objPAPStatusLogic = new DashboardBLL(); //ProjectStatusPieChart.Legends.Add(new Legend("ProjectStatus")); ProjectStatusPieChart.Series[0].XValueMember = "ProjectStatus"; ProjectStatusPieChart.Series[0].YValueMembers = "StatuCount"; ProjectStatusPieChart.Series[0].Label = "#PERCENT{P0}"; ProjectStatusPieChart.Series[0].Font = new Font("Segoe UI", 8.0f, FontStyle.Bold); ProjectStatusPieChart.Series[0].Legend = "ProjectStatus"; DSH_PAPStatusList PAPStatusList = objPAPStatusLogic.GetProjectwisePAPStatusForPie(); ProjectStatusPieChart.DataSource = PAPStatusList; ProjectStatusPieChart.DataBind(); for (int i = 0; i < PAPStatusList.Count; i++) { DataPoint pt = ProjectStatusPieChart.Series[0].Points[i]; if (PAPStatusList[i].ProjectStatus.ToString().ToUpper() == "IN PROGRESS") { pt.LegendText = "In Progress"; pt.Color = Color.Orange; } else if (PAPStatusList[i].ProjectStatus.ToString().ToUpper() == "COMPLETED") { pt.LegendText = "Completed"; pt.Color = Color.Green; } else if (PAPStatusList[i].ProjectStatus.ToString().ToLower() == "new") { pt.LegendText = "New"; pt.Color = Color.Blue; } else { pt.LegendText = PAPStatusList[i].ProjectStatus.ToString(); } } }