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