public bool checkin(Customer pr, BookingRoom book) { bool result, result2, result3 = false; SqlConnection cnn = new SqlConnection(strConnection); string sql = "Insert into Customer values(@ID,@NAME,@PHONE,@BIRTHDAY)"; cnn.Open(); SqlCommand cmd = new SqlCommand(sql, cnn); cmd.Parameters.AddWithValue("@ID", pr.customerID); cmd.Parameters.AddWithValue("@NAME", pr.customerName); cmd.Parameters.AddWithValue("@PHONE", pr.phone); cmd.Parameters.AddWithValue("@BIRTHDAY", pr.birthday); result = cmd.ExecuteNonQuery() > 0; string sql2 = "Insert into Booking (customerID,roomno,checkindate,checkoutdate,totalpay,status,prepay) values(@customerID,@roomNo,@checkin,@checkout,@totalpay,@status,@prepay)"; SqlCommand cmd2 = new SqlCommand(sql2, cnn); cmd2.Parameters.AddWithValue("@customerID", pr.customerID); cmd2.Parameters.AddWithValue("@roomNo", book.RoomNo); cmd2.Parameters.AddWithValue("@checkin", book.CheckInDay); cmd2.Parameters.AddWithValue("@checkout", book.CheckOutDay); cmd2.Parameters.AddWithValue("@totalpay", book.TotalPay); cmd2.Parameters.AddWithValue("@status", true); cmd2.Parameters.AddWithValue("@prepay", book.PrePay); result2 = cmd2.ExecuteNonQuery() > 0; string sql3 = "update room set status= @status where roomno = @ROOMNO"; SqlCommand cmd3 = new SqlCommand(sql3, cnn); cmd3.Parameters.AddWithValue("@status", false); cmd3.Parameters.AddWithValue("@ROOMNO", book.RoomNo); result3 = cmd3.ExecuteNonQuery() > 0; cnn.Close(); if (result && result2 && result3) { return(true); } else { return(false); } }
public bool checkinKhachQuen(BookingRoom book, string cusID) { bool result, result2 = false; SqlConnection cnn = new SqlConnection(strConnection); cnn.Open(); string sql2 = "Insert into Booking (customerID,roomno,checkindate,checkoutdate,totalpay,status,prepay) values(@customerID,@roomNo,@checkin,@checkout,@totalpay,@status,@prepay)"; SqlCommand cmd2 = new SqlCommand(sql2, cnn); cmd2.Parameters.AddWithValue("@customerID", cusID); cmd2.Parameters.AddWithValue("@roomNo", book.RoomNo); cmd2.Parameters.AddWithValue("@checkin", book.CheckInDay); cmd2.Parameters.AddWithValue("@checkout", book.CheckOutDay); cmd2.Parameters.AddWithValue("@totalpay", book.TotalPay); cmd2.Parameters.AddWithValue("@status", true); cmd2.Parameters.AddWithValue("@prepay", book.PrePay); result = cmd2.ExecuteNonQuery() > 0; string sql3 = "update room set status= @status where roomno = @ROOMNO"; SqlCommand cmd3 = new SqlCommand(sql3, cnn); cmd3.Parameters.AddWithValue("@status", false); cmd3.Parameters.AddWithValue("@ROOMNO", book.RoomNo); result2 = cmd3.ExecuteNonQuery() > 0; cnn.Close(); if (result && result2) { return(true); } else { return(false); } }