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