//Generate the report according to the selected fucntion
private void btn_Generate_Click(object sender, EventArgs e)
{
if (rbn_allCusRent.Checked || rbn_allCusRange.Checked)
{
if (string.IsNullOrEmpty(txt_nic.Text))
{
MessageBox.Show("Enter NIC", "Alert1", MessageBoxButtons.OK, MessageBoxIcon.Information);
while (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows.RemoveAt(0);
}
txt_nic.Focus();
}
}
string d1 = "", d2 = "", nic = txt_nic.Text;
int value1 = 3;
if (rbn_allCusRent.Checked)
{
value1 = 0;
}
if (rbn_allCusRange.Checked)
{
value1 = 1;
d1 = dateTimePicker1.Value.ToShortDateString();
d2 = dateTimePicker2.Value.ToShortDateString();
}
if (rbn_notReturned.Checked)
{
value1 = 2;
}
if (rbn_allCus.Checked)
{
value1 = 3;
}
db = new DBconnection();
dataGridView1.DataSource = db.repcus(value1, d1, d2, nic);
if (dataGridView1.RowCount == 0)
{
MessageBox.Show("No Data", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void deleteR_Click(object sender, EventArgs e)
{
DialogResult r1 = MessageBox.Show("This customer may have some transactions\nAre you sure?", "Delete", MessageBoxButtons.YesNo);
if (r1 == DialogResult.Yes)
{
dbc1 = new DBconnection();
dbc1.deleteCust(nicI.Text);
MessageBox.Show("Sucessfully deleted customer data related to nic no : " + nicI.Text, "Completed");
customerSearch_Load(this, null);
}
else
{
this.Show();
animationLoad(false, 255, 255, 255);
}
}
private void com_ReGen2_SelectedIndexChanged(object sender, EventArgs e)
{
//cmd_ReMov2.Enabled = true;
cmd_ReMov2.Items.Clear();
List <string> list1 = new List <string>();
DBconnection db1 = new DBconnection();
list1.AddRange(db1.searchByGenre(com_ReGen2.SelectedItem.ToString()));
foreach (string s in list1)
{
if (s == mov1)
{
list1.Remove(s);
break;
}
}
cmd_ReMov2.Items.AddRange(list1.ToArray());
}
private void button_del_Click(object sender, EventArgs e)//Delete a movie
{
if (movieI.Text == "")
{
movieI.Text = "Enter a movie";
movieI.ForeColor = System.Drawing.Color.Red;
}
else
{
DialogResult r1 = MessageBox.Show("Do you sure about this movie deletion?", "Warning", MessageBoxButtons.YesNo);
if (r1 == DialogResult.Yes)
{
dbc1 = new DBconnection();
dbc1.deleteMovie(movieI.Text);
movieNameMsgBox_Load(this, null);//reload form again to refresh auto complete
}
}
}
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;
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
var item = dataGridView2.Rows[e.RowIndex].Cells[0].Value;
txt_RuMovieName.Text = item.ToString();
DBconnection db1 = new DBconnection();
Movie m = db1.searchMovie(txt_RuMovieName.Text);
movno = m.Movie_Id;
txt_RuMovieRent.Text = m.Price.ToString();
Rent r1 = new Rent();
int fineval = r1.getfines(m.Movie_Id, txt_RuCusNIC.Text);
txt_fines.Text = fineval.ToString();
txt_RuTotal.Text = ((m.Price) + fineval).ToString();
}
catch (Exception)
{
MessageBox.Show("Click on a movie name", "Select Movie", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void EditMovie_Load(object sender, EventArgs e)
{
cmb_genre.Enabled = false;
txt_movieName.Text = movieNameCurrent;
dbc1 = new DBconnection();
AutoCompleteStringCollection at1 = dbc1.dataLoadToSuggestion("movie_name", "movie");
txt_movieName.AutoCompleteCustomSource = at1;
Movie movie = new Movie();
movie = movie.searchMovie(movieNameCurrent);
id = movie.Movie_Id;
txt_movieName.Text = movie.Movie_Name;
cmb_genre.SelectedItem = movie.Genre;
txt_price.Text = movie.Price.ToString();
txt_noCopies.Text = movie.No_Of_Copies.ToString();
}
//Search movies according to the selected genre
private void com_ReGen3_SelectedIndexChanged(object sender, EventArgs e)
{
//cmd_ReMov3.Enabled = true;
cmd_ReMov3.Items.Clear();
List <string> list2 = new List <string>();
DBconnection db2 = new DBconnection();
list2.AddRange(db2.searchByGenre(com_ReGen3.SelectedItem.ToString()));
foreach (string s in list2.ToList())
{
if (s == mov1)
{
list2.Remove(s);
continue;
}
if (s == mov2)
{
list2.Remove(s);
continue;
}
}
cmd_ReMov3.Items.AddRange(list2.ToArray());
}
public DataTable searchCustomer(string nic)
{
DBconnection db = new DBconnection();
return(db.seachCustomer(nic));
}
public Movie searchMovie(String name)
{
DBconnection db = new DBconnection();
return(db.searchMovie(name));
}