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