private void fillMatChart()
{
try
{
ReportDBaccess RD = new ReportDBaccess();
grid_met.DataSource = RD.getAllMaterial();
int a = 0;
chart5.Titles.Add("Material Stock");
while (a < grid_met.RowCount - 1)
{
chart5.Series["Material Stock"].Points.AddXY(grid_met.Rows[a].Cells[0].Value.ToString(), grid_met.Rows[a].Cells[4].Value.ToString());
a = a + 1;
}
lb_Mattoday.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void fillClientChart()
{
try
{
DateTime date = DateTime.Today.Date;
var firstDayOfMonth = new DateTime(date.Year, date.Month, 1).AddDays(-1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(-1).AddDays(1);
var firstDayOfMonth1 = lastDayOfMonth.AddDays(-1);
var lastDayOfMonth1 = firstDayOfMonth.AddMonths(-2).AddDays(1);
lb_cltFrom.Text = lastDayOfMonth.ToString("dd/MM/yyyy");
lb_cltTo.Text = firstDayOfMonth.ToString("dd/MM/yyyy");
ReportDBaccess RD = new ReportDBaccess();
DateTime d1 = firstDayOfMonth.Date;
DateTime d2 = lastDayOfMonth.Date;
DateTime d3 = firstDayOfMonth1.Date;
DateTime d4 = lastDayOfMonth1.Date;
ClientDBaccess CB = new ClientDBaccess();
grid_Clientreport.DataSource = CB.getAllClients();
grid_Clientreport.Columns.Add("Order_Placed", "Orders Placed");
int x = 0;
while (x < grid_Clientreport.RowCount - 1)
{
grid_Clientreport.Rows[x].Cells["Order_Placed"].Value = RD.getClientcount(grid_Clientreport.Rows[x].Cells[0].Value.ToString(), d2, d1).Rows.Count.ToString();
x = x + 1;
}
int a = 0;
chart3.Titles.Add("Client Orders");
while (a < grid_Clientreport.RowCount - 1)
{
chart3.Series["Client Orders"].Points.AddXY(grid_Clientreport.Rows[a].Cells[1].Value.ToString(), grid_Clientreport.Rows[a].Cells[5].Value.ToString());
a = a + 1;
}
int total = 0;
for (int b = 0; b < grid_Clientreport.Rows.Count; b++)
{
total += Convert.ToInt32(grid_Clientreport.Rows[b].Cells[5].Value);
}
lb_cltTot.Text = total.ToString();
lb_cltnow.Text = total.ToString();
int tot = 0;
for (int b = 0; b < grid_Clientreport.Rows.Count - 1; b++)
{
int[] y = new int[grid_Clientreport.Rows.Count];
y[b] = Convert.ToInt32(RD.getClientcount(grid_Clientreport.Rows[b].Cells[0].Value.ToString(), d4, d3).Rows.Count);
tot = tot + y[b];
}
//int sum = Convert.ToInt32(RD.getClientcount(grid_Clientreport.Rows[x].Cells[0].Value.ToString(), d2, d1).Compute("SUM(Order_Placed)", string.Empty));
lb_cltlast.Text = tot.ToString();
lb_cltnext.Text = (Convert.ToInt32(total) + (Convert.ToInt32(total) - Convert.ToInt32(tot))).ToString();
string pMonth = DateTime.Now.AddMonths(-1).ToString("MMMM");
string pMonth1 = DateTime.Now.AddMonths(-2).ToString("MMMM");
string pMonth2 = DateTime.Now.ToString("MMMM");
lb_cltlastmonth.Text = pMonth1;
lb_cltnowmonrh.Text = pMonth;
lb_cltNextmonth.Text = pMonth2;
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void fillPurChart()
{
try
{
DateTime date = DateTime.Today.Date;
var firstDayOfMonth = new DateTime(date.Year, date.Month, 1).AddDays(-1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(-1).AddDays(1);
var firstDayOfMonth1 = lastDayOfMonth.AddDays(-1);
var lastDayOfMonth1 = firstDayOfMonth.AddMonths(-2).AddDays(1);
lb_fromdate.Text = lastDayOfMonth.ToString("dd/MM/yyyy");
lb_todate.Text = firstDayOfMonth.ToString("dd/MM/yyyy");
ReportDBaccess RD = new ReportDBaccess();
DateTime d1 = firstDayOfMonth.Date;
DateTime d2 = lastDayOfMonth.Date;
DateTime d3 = firstDayOfMonth1.Date;
DateTime d4 = lastDayOfMonth1.Date;
grid_PurReport.DataSource = RD.getPurchaseReport(d2, d1);
int total = 0;
for (int a = 0; a < grid_PurReport.Rows.Count; a++)
{
total += Convert.ToInt32(grid_PurReport.Rows[a].Cells[3].Value);
}
lb_tot.Text = total.ToString();
lb_now.Text = total.ToString();
int sum = Convert.ToInt32(RD.getPurchaseReport(d4, d3).Compute("SUM(pur_total)", string.Empty));
lb_last.Text = sum.ToString();
lb_next.Text = (Convert.ToInt32(total) + (Convert.ToInt32(total) - Convert.ToInt32(sum))).ToString();
//grid_SaleReport.DataSource = rows;
//AddXY value in chart1 in series named as Salary
string pMonth = DateTime.Now.AddMonths(-1).ToString("MMMM");
string pMonth1 = DateTime.Now.AddMonths(-2).ToString("MMMM");
string pMonth2 = DateTime.Now.ToString("MMMM");
chart2.Series["Purchase"].Points.AddXY(pMonth1, sum.ToString());
chart2.Series["Purchase"].Points.AddXY(pMonth, total.ToString());
lb_lastmonth.Text = pMonth1;
lb_nawMonth.Text = pMonth;
lb_nextMonth.Text = pMonth2;
//chart title
chart2.Titles.Add("Purchase Chart");
}
catch (SqlException)
{
MetroMessageBox.Show(this, "\n\nConnecton Failed", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (FormatException)
{
MetroMessageBox.Show(this, "\n\nInvalid Format", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (OutOfMemoryException)
{
MetroMessageBox.Show(this, "\n\nInsuffisent memory", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MetroMessageBox.Show(this, "\n\nERROR", "Fail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
