private void del_btn_Click(object sender, EventArgs e)
{
if (RID > 0 && rental_mov_name.Text.Equals("") && rental_cs_name.Text.Equals(""))
{
MessageBox.Show("Must need to select the video and Customer");
}
else
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
if (db.delRentalVideo(RID))
{
MessageBox.Show("rental video is deleted ");
RID = 0;
cname.Text = "";
rental_cs_name.Text = "";
cAge.Text = "";
cPhone.Text = "";
caddress.Text = "";
rental_mov_name.Text = "";
vName.Text = "";
year.Text = "";
plot.Text = "";
Cost_txt.Text = "";
copies.Text = "";
genre.Text = "";
rating.Text = "";
}
else
{
MessageBox.Show("Must select the data ");
}
}
}
private void update_cs_btn_Click(object sender, EventArgs e)
{
if (rental_cs_name.Text.Equals("") && cname.Text.Equals("") && cAge.Text.Equals("") && cPhone.Text.Equals("") && caddress.Text.Equals(""))
{
MessageBox.Show("You must need to fill all details ");
}
else
{
Controller.DatabaseClass dbClient = new Controller.DatabaseClass();
if (dbClient.editClient(Convert.ToInt32(rental_cs_name.Text), cname.Text, cAge.Text, cPhone.Text, caddress.Text))
{
MessageBox.Show("Client record is updated ");
cname.Text = "";
rental_cs_name.Text = "";
cAge.Text = "";
cPhone.Text = "";
caddress.Text = "";
}
else
{
MessageBox.Show("check the details once ");
}
}
}
private void add_cs_btn_Click(object sender, EventArgs e)
{
if (cname.Text.Equals("") && cAge.Text.Equals("") && cPhone.Text.Equals("") && caddress.Text.Equals(""))
{
MessageBox.Show("You must need to fill all details ");
}
else
{
Controller.DatabaseClass dbClient = new Controller.DatabaseClass();
if (dbClient.addClient(cname.Text, cAge.Text, cPhone.Text, caddress.Text))
{
MessageBox.Show("Client is registered ");
cname.Text = "";
rental_cs_name.Text = "";
cAge.Text = "";
cPhone.Text = "";
caddress.Text = "";
}
else
{
MessageBox.Show("check the details once ");
}
}
}
private void Issue_btn_Click(object sender, EventArgs e)
{
if (rental_mov_name.Text.Equals("") && rental_cs_name.Text.Equals(""))
{
MessageBox.Show("Must need to select the video and Customer");
}
else
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
if (db.bookVideo(Convert.ToInt32(rental_mov_name.Text), Convert.ToInt32(rental_cs_name.Text), dateTimePicker1.Text.ToString()))
{
MessageBox.Show("video is booked ");
RID = 0;
cname.Text = "";
rental_cs_name.Text = "";
cAge.Text = "";
cPhone.Text = "";
caddress.Text = "";
rental_mov_name.Text = "";
vName.Text = "";
year.Text = "";
plot.Text = "";
Cost_txt.Text = "";
copies.Text = "";
genre.Text = "";
rating.Text = "";
}
else
{
MessageBox.Show("Must select the data ");
}
}
}
private void del_mov_Click(object sender, EventArgs e)
{
if (rental_mov_name.Text.Equals("") && vName.Text.Equals("") && rating.Text.Equals("") && year.Text.Equals("") && plot.Text.Equals("") && Cost_txt.Text.Equals("") && copies.Text.Equals("") && genre.Text.Equals(""))
{
MessageBox.Show("Must need to fill the details ");
}
else
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
if (db.delVideo(Convert.ToInt32(rental_mov_name.Text)))
{
MessageBox.Show("Video recoord is deleted ");
rental_mov_name.Text = "";
vName.Text = "";
year.Text = "";
plot.Text = "";
Cost_txt.Text = "";
copies.Text = "";
genre.Text = "";
rating.Text = "";
}
else
{
MessageBox.Show("Check the Video ");
}
}
}
private void add_mov_Click(object sender, EventArgs e)
{
if (vName.Text.Equals("") && rating.Text.Equals("") && year.Text.Equals("") && plot.Text.Equals("") && Cost_txt.Text.Equals("") && copies.Text.Equals("") && genre.Text.Equals(""))
{
MessageBox.Show("Must need to fill the details ");
}
else
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
if (db.addVideo(vName.Text, rating.Text, year.Text, plot.Text, Cost_txt.Text, copies.Text, genre.Text))
{
MessageBox.Show("Video is record ");
vName.Text = "";
year.Text = "";
plot.Text = "";
Cost_txt.Text = "";
copies.Text = "";
genre.Text = "";
rating.Text = "";
}
else
{
MessageBox.Show("Check the Video ");
}
}
}
private void allrented_CheckedChanged(object sender, EventArgs e)
{
if (allrented.Checked == true)
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
DataTable tbl = new DataTable();
tbl = db.SelectQuery("select * from Rental");
dataGridView1.DataSource = tbl;
}
}
private void pop_cs_CheckedChanged(object sender, EventArgs e)
{
if (pop_cs.Checked == true)
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
DataTable tbl = new DataTable();
tbl = db.SelectQuery("select * from Client");
int x = 0, y = 0, c**t = 0;
String Title = "";
for (x = 0; x < tbl.Rows.Count; x++)
{
DataTable tblData1 = new DataTable();
tblData1 = db.SelectQuery("select * from rental where C_ID='" + tbl.Rows[x]["id"].ToString() + "'");
if (tblData1.Rows.Count > c**t)
{
Title = tbl.Rows[x]["Name"].ToString();
c**t = tblData1.Rows.Count;
}
}
MessageBox.Show("Popular Video is " + Title);
}
}
private void return_btn_Click(object sender, EventArgs e)
{
if (RID > 0 && rental_mov_name.Text.Equals("") && rental_cs_name.Text.Equals(""))
{
MessageBox.Show("Must need to select the video and Customer");
}
else
{
Controller.DatabaseClass db = new Controller.DatabaseClass();
if (db.returnVideo(RID, Convert.ToInt32(rental_mov_name.Text), Convert.ToInt32(rental_cs_name.Text), dateTimePicker1.Text.ToString(), dateTimePicker2.Text.ToString()))
{
DataTable tbl = new DataTable();
tbl = db.SelectQuery("select * from Video where id=" + Convert.ToInt32(rental_mov_name.Text) + "");
int Cost = Convert.ToInt32(tbl.Rows[0]["Cost"].ToString());
DataTable tbl1 = new DataTable();
tbl1 = db.SelectQuery("select * from Rental where id=" + RID + "");
String olDate = tbl1.Rows[0]["BookDate"].ToString();
DateTime current_date = DateTime.Now;
//convert the old date from string to Date fromat
DateTime prev_date = Convert.ToDateTime(olDate);
//get the difference in the days fromat
String Daysdiff = (current_date - prev_date).TotalDays.ToString();
// calculate the round off value
Double DaysInterval = Math.Round(Convert.ToDouble(Daysdiff));
int Bill = Cost * Convert.ToInt32(DaysInterval);
MessageBox.Show("video is returned and bill is $" + Bill);
RID = 0;
cname.Text = "";
rental_cs_name.Text = "";
cAge.Text = "";
cPhone.Text = "";
caddress.Text = "";
rental_mov_name.Text = "";
vName.Text = "";
year.Text = "";
plot.Text = "";
Cost_txt.Text = "";
copies.Text = "";
genre.Text = "";
rating.Text = "";
}
else
{
MessageBox.Show("Must select the data ");
}
}
}
