private void button2_Click(object sender, EventArgs e)
{
ForPayment fr = new ForPayment();
fr.Show();
this.Hide();
int a = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[a];
int idd = Convert.ToInt32(selectedRow.Cells[0].Value);
Trip trip = new Trip();
trip = db.Trips.FirstOrDefault(x => x.id == idd);
if (comboBox3.Text == "A1")
{
trip.A1 = "Booked";
seat = "A1";
db.SubmitChanges();
}
else if (comboBox3.Text == "A2")
{
trip.A2 = "Booked";
seat = "A2";
db.SubmitChanges();
}
else if (comboBox3.Text == "A3")
{
trip.A3 = "Booked";
seat = "A3";
db.SubmitChanges();
}
else if (comboBox3.Text == "A4")
{
trip.A4 = "Booked";
seat = "A4";
db.SubmitChanges();
}
// db.Trips.DeleteOnSubmit(businfo);
//db.SubmitChanges();
//Form form = (Form)Application.OpenForms["delete"];
}
private void button3_Click(object sender, EventArgs e)
{
int a = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[a];
int Id = Convert.ToInt32(selectedRow.Cells[0].Value);
var businfo = db.Trips.FirstOrDefault(x => x.id == Id);
db.Trips.DeleteOnSubmit(businfo);
db.SubmitChanges();
MessageBox.Show("Trip Deleted");
}
private void button3_Click(object sender, EventArgs e)
{
Trip tr = new Trip();
tr.busName = textBox1.Text;
tr.route = comboBox1.Text;
tr.category = comboBox2.Text;
tr.schedual = textBox5.Text;
tr.rent = textBox4.Text;
tr.date = dateTimePicker1.Value.Date;
busticketDataContext up = new busticketDataContext();
up.Trips.InsertOnSubmit(tr);
up.SubmitChanges();
MessageBox.Show("Updated up successfully");
}
private void button1_Click(object sender, EventArgs e)
{
try {
User s = new User();
s.name = textBox1.Text;
s.age = textBox2.Text;
//s.gender = checkBox1.Text;
//s.gender = checkBox2.Text;
if (checkBox1.Checked)
{
s.gender = "Male";
}
if (checkBox2.Checked)
{
s.gender = "Female";
}
s.contactno = textBox3.Text;
s.email = textBox4.Text;
s.password = textBox5.Text;
busticketDataContext st = new busticketDataContext();
st.Users.InsertOnSubmit(s);
st.SubmitChanges();
MessageBox.Show("Sign up successfully");
s.name = " ";
s.age = " ";
s.gender = " ";
s.contactno = " ";
s.email = " ";
s.password = "******";
}
catch
{
MessageBox.Show("Fill up all info ");
}
}
