private void submit_pictureBox_Click(object sender, EventArgs e) { Choch choach = new Choch(); choach.Choch_No = choch_no_textfield.Text.ToString(); choach.Registration = registration_no_textfield.Text.ToString(); choach.Date_Time = date_time_textfield.Text.ToString(); choach.Source = source_textfield.Text.ToString(); choach.Destination = destination_textfield.Text.ToString(); choach.Total_Seat = total_ticket_textfield.Text.ToString(); choach.Seat_no = No_of_seat_textbox.Text.ToString(); choach.Available_Seat = seat_available_text.Text.ToString(); choach.Amount = Amount_text.Text.ToString(); Choach_service service1 = new Choach_service(); if (service1.Add_chaoach(choach) > 0) { MessageBox.Show("Succesfully added"); } }
// Choch person = new Choch(); #region Get_destination_method public Choch GetBydestination(string destination) { string query = "select Choach_No,Register,Date_Time,Source,Destination,Total_Seat,No_Seat,Seat_available from Choach where Destination =" + destination; SqlDataReader reader = Connection_Database.GetData(query); reader.Read(); Choch chach = null; if (reader.HasRows) { chach = new Choch(); chach.Choch_No = reader["Choach_No"].ToString(); chach.Registration = reader["Register"].ToString(); chach.Date_Time = reader["Date_Time"].ToString(); chach.Source = reader["Source"].ToString(); chach.Destination = reader["Destination"].ToString(); chach.Total_Seat = reader["Total_Seat"].ToString(); chach.Seat_no = reader["No_Seat"].ToString(); chach.Available_Seat = reader["Seat_available"].ToString(); } return(chach); }
private void submit_Click(object sender, EventArgs e) { User_service service = new User_service(); User_Entity passenger = new User_Entity(); Choch set = new Choch(); passenger.Name = nametextbox.Text; passenger.Phone = phntextbox.Text; passenger.Choch_No = Coach.Text; passenger.Seat_no = membertextbox.Text; User_service userservice = new User_service(); if (userservice.Add_passrnger(passenger) > 0) { MessageBox.Show("passenger add successfully"); } set.Seat_no = seatnotextbox.Text; conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE Choach SET No_Seat=No_Seat+'" + seatnotextbox.Text + "' where Choach_No='" + Coach.Text + "'"; cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Succesfully submitted"); passengername = nametextbox.Text; date = dateTimePicker.Text; bus_no = Coach.Text; seat_member = seatnotextbox.Text; No_of_seat = membertextbox.Text; source = fromComboBox.SelectedValue.ToString(); destination = toComboBox.SelectedValue.ToString(); Payment pay = new Payment(); pay.Show(); this.Hide(); }
public int Add_Choach(Choch choach) { string query = string.Format("INSERT INTO Choach(Choach_No,Register,Date_Time,Source,Destination,Total_Seat,No_Seat,Seat_available,Amount) VALUES('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", choach.Choch_No, choach.Registration, choach.Date_Time, choach.Source, choach.Destination, choach.Total_Seat, Convert.ToInt32(choach.Seat_no), Convert.ToInt32(choach.Available_Seat), Convert.ToInt32(choach.Amount)); return(Connection_Database.ExecuteQuery(query)); }
public int Edit_seat(Choch seat) { return(useraccess.Edit_seat(seat)); }
public int Edit_seat(Choch seat) { string query = "UPDATE Choach SET No_Seat=No_Seat+'" + seat.Seat_no + "' WHERE Choach_No=" + seat.Choch_No; return(Connection_Database.ExecuteQuery(query)); }
public int Add_chaoach(Choch choach) { return(useraccess.Add_Choach(choach)); }