public static ArrayList GetAllInfo() { SqlConnection conn = new SqlConnection(); SqlCommand comm = new SqlCommand(); ArrayList products = new ArrayList(); try { conn.ConnectionString = GSM_CONN_STR; conn.Open(); comm.Connection = conn; comm.CommandText = "SELECT * from Guest b,Booking a where a.guestid=b.guestid "; SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { booking p = new booking(dr["name"].ToString(), dr["phone"].ToString(), dr["email"].ToString(), dr["address"].ToString(), dr["postalcode"].ToString(), dr["country"].ToString(), dr["no_of_adults"].ToString(), dr["no_of_children"].ToString(), dr["check_in_date"].ToString(), dr["check_out_date"].ToString(), dr["no_of_rooms"].ToString(), dr["guestid"].ToString()); products.Add(p); } dr.Close(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(products); }
private void button1_Click(object sender, EventArgs e) { string guestID = "123"; string name; string number; string email; string address; string postal; string country; string checkin; string checkout; string room; string adult; string children; name = textBox1.Text; number = textBox10.Text; email = textBox9.Text; address = textBox8.Text; postal = textBox7.Text; country = textBox6.Text; checkin = dateTimePicker1.Text; checkout = dateTimePicker2.Text; room = comboBox1.Text; adult = comboBox3.Text; children = comboBox4.Text; booking p = new booking(name, number, email, address, postal, country, adult, children, checkin, checkout, room, guestID); DataBase.Insertbookinfo(p); }
public static bool Insertbookinfo(booking u) { bool result = false; SqlConnection conn = new SqlConnection(); SqlCommand comm = new SqlCommand(); if (u != null) { try { conn = new SqlConnection(); conn.ConnectionString = GSM_CONN_STR; conn.Open(); comm.Connection = conn; comm.CommandText = "insert into Booking " + "(check_in_date, check_out_date,no_of_rooms,no_of_adults,no_of_children,guestid,roomno) values " + "(@check_in_date,@check_out_date,@no_of_rooms,@no_of_adults,@no_of_children,@guestid,@roomno);" + "insert into Guest " + "(name,phone,address,postalcode,country,guestid,email) values " + "(@name,@phone,@address,@postalcode,@country,@guestid,@email);" ; comm.Parameters.AddWithValue("@check_in_date", u.Checkin); comm.Parameters.AddWithValue("@check_out_date", u.Checkout); comm.Parameters.AddWithValue("@no_of_rooms", u.NoOfRoom); comm.Parameters.AddWithValue("@no_of_adults", u.NoOfAdult); comm.Parameters.AddWithValue("@no_of_children", u.NoOfChildren); comm.Parameters.AddWithValue("@guestid", u.Guestid); comm.Parameters.AddWithValue("@name", u.Name); comm.Parameters.AddWithValue("@phone", u.Number); comm.Parameters.AddWithValue("@address", u.Address); comm.Parameters.AddWithValue("@postalcode", u.Postal); comm.Parameters.AddWithValue("@country", u.Country); comm.Parameters.AddWithValue("@roomno", u.NoOfRoom); comm.Parameters.AddWithValue("@email", u.Email); int rows = comm.ExecuteNonQuery(); if (rows > 0) { result = true; } } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } } return(result); }