private void frmRevenueAnalysis_Load(object sender, EventArgs e)
{
//load the year combo box with the year
DataSet ds = new DataSet();
ds = Revenue.loadYear(ds);
//load year
for (int i = 0; i < ds.Tables["year"].Rows.Count; i++)
{
cboYear.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
//display on the gridbox
ds = Revenue.displayAnnualRecord(ds);
for (int i = 0; i < ds.Tables["annual"].Rows.Count; i++)
{
DataGridViewRow row = (DataGridViewRow)grdRevnAnalys.Rows[0].Clone();
row.Cells[0].Value = ds.Tables["annual"].Rows[i][0].ToString();
row.Cells[1].Value = "";
row.Cells[2].Value = "";
row.Cells[3].Value = "";
row.Cells[4].Value = ds.Tables["annual"].Rows[i][1].ToString();
grdRevnAnalys.Rows.Add(row);
}
}
private void frmFoodAnalysis_Load(object sender, EventArgs e)
{
//load the year combo box with the year
DataSet ds = new DataSet();
ds = Revenue.loadYear(ds);
//load year
for (int i = 0; i < ds.Tables["year"].Rows.Count; i++)
{
cboYear.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
//load month
ds = Revenue.loadMonth(ds, yearSelected);
for (int i = 0; i < ds.Tables["month"].Rows.Count; i++)
{
cboMonth.Items.Add(ds.Tables["month"].Rows[i][0].ToString());
}
//display analysis
displayAnalysis(grdFdAnlys);
}
private void btnReset_Click(object sender, EventArgs e)
{
yearSelected = null;
monthSelected = null;
weekSelected = null;
//reset other combo
cboMonth.Items.Clear();
cboWeek.Items.Clear();
cboYear.Items.Clear();
//load the year combo box with the year
DataSet ds = new DataSet();
ds = Revenue.loadYear(ds);
//load year
for (int i = 0; i < ds.Tables["year"].Rows.Count; i++)
{
cboYear.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
grdRevnAnalys.Rows.Clear();
//display on the gridbox
ds = Revenue.displayAnnualRecord(ds);
for (int i = 0; i < ds.Tables["annual"].Rows.Count; i++)
{
DataGridViewRow row = (DataGridViewRow)grdRevnAnalys.Rows[0].Clone();
row.Cells[0].Value = ds.Tables["annual"].Rows[i][0].ToString();
row.Cells[1].Value = "";
row.Cells[2].Value = "";
row.Cells[3].Value = "";
row.Cells[4].Value = ds.Tables["annual"].Rows[i][1].ToString();
grdRevnAnalys.Rows.Add(row);
}
}