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 "); } }