private void button1_Click(object sender, EventArgs e)
{
database d = new database();
bool g = d.issuemovie(comboBox1.SelectedValue.ToString(), comboBox2.SelectedValue.ToString(), dateTimePicker1.Text);
if (g == true)
{
MessageBox.Show("Book Issued");
}
}
private void button1_Click(object sender, EventArgs e)
{
database d = new database();
bool r = d.deletemovie(comboBox1.SelectedValue.ToString());
if (r == true)
{
MessageBox.Show("Delete successfully");
}
}
private void button1_Click(object sender, EventArgs e)
{
database d = new database();
bool m = d.updatemovie(comboBox1.SelectedValue.ToString(), textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox6.Text, textBox7.Text);
if (m == true)
{
MessageBox.Show("Updated");
}
}
private void button1_Click(object sender, EventArgs e)
{
database d = new database();
bool f = d.returnmovie(comboBox1.SelectedValue.ToString(), dateTimePicker1.Text);
if (f == true)
{
MessageBox.Show("Returned");
}
}
private void button1_Click(object sender, EventArgs e)
{
database d = new database();
bool f = d.addcustomer(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text);
if (f == true)
{
MessageBox.Show("New Customer Added");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
// MessageBox.Show(comboBox1.SelectedValue.ToString());
database d = new database();
DataSet d1 = d.moviedata(comboBox1.SelectedValue.ToString());
textBox1.Text = d1.Tables[0].Rows[0][1].ToString();
textBox2.Text = d1.Tables[0].Rows[0][2].ToString();
textBox3.Text = d1.Tables[0].Rows[0][3].ToString();
textBox4.Text = d1.Tables[0].Rows[0][5].ToString();
textBox6.Text = d1.Tables[0].Rows[0][6].ToString();
textBox7.Text = d1.Tables[0].Rows[0][7].ToString();
}
catch (Exception e1)
{
}
}