private void btn_load_Click(object sender, EventArgs e)
{
String cusnic = txt_cusNic.Text;
DBconnection db = new DBconnection();
OracleDataReader reader = db.DetailsForChart(cusnic, 0);
while (reader.Read())
{
chart1.Series[reader[1].ToString()].Points.AddXY(DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(Convert.ToInt32(reader[3])), reader[2]);
}
}
private void btn_load_Click(object sender, EventArgs e)
{
String mGenre = cmb_mGenre.SelectedItem.ToString();
DBconnection db = new DBconnection();
OracleDataReader reader = db.DetailsForChart(mGenre, 1);
while (reader.Read())
{
chart1.Series[reader[0].ToString()].Points.AddXY(DateTimeFormatInfo.CurrentInfo.GetAbbreviatedMonthName(Convert.ToInt32(reader[2])), reader[1]);
}
}
private void btn_load_Click(object sender, EventArgs e)
{
int maxCount = 0;
String maxMovie = "";
String fromDate = dtp_From.Value.ToShortDateString();
String toDate = dtp_To.Value.ToShortDateString();
int reportType = 2;
String s = "Most Popular Genre ";
if (rbn_customer.Checked)
{
reportType = 0;
s = "The Best Customer ";
}
else if (rbn_movie.Checked)
{
reportType = 1;
s = "Most Popular Movie ";
}
DBconnection db = new DBconnection();
OracleDataReader reader = db.DetailsForChart(fromDate, toDate, reportType);
while (reader.Read())
{
if (maxCount < Convert.ToInt32(reader[1]))
{
maxCount = Convert.ToInt32(reader[1]);
maxMovie = reader[0].ToString();
}
this.chart1.Series["Number of times rented"].Points.AddXY(reader[0], reader[1]);
}
lbl_summary.Text = s + " for the Period : " + maxMovie;
lbl_summary.Show();
btn_load.Enabled = false;
}