private void InsertData(int index)
{
ConnectData.Connect();
//
//string user = "******";
string user = usernamelink.Text;
//
string numRoom = danhsachphongtrong.Rows[index].Cells[5].Value.ToString();
int num;
int.TryParse(numRoom, out num);
DateTime dateIn = DateTime.Parse(ngaynhanphongdt.Text);
DateTime dateOut = dateIn.AddDays(int.Parse(ngayolai.Text));
string sql = "sp_booking";
int result;
//+ user +"," + numRoom + "," + checkIn + "," + checkOut + "," + result
result = ConnectData.ExcuteProcedure(sql, user, num, dateIn, dateOut);
ConnectData.DisConnect();
if (result == 1)
{
MessageBox.Show("Xin lỗi quý khách !! \nPhòng này đã có người sử dụng !", "Error");
danhsachphongtrong.CancelEdit();
}
else
{
MessageBox.Show("Đặt phòng thành công !!");
}
}
private void InsertData(int index)
{
ConnectData.Connect();
//
string user = "******";
//string user = usernamelink.Name;
//
string numRoom = danhsachphongtrong.Rows[index].Cells[5].Value.ToString();
int num;
int.TryParse(numRoom, out num);
DateTime dateIn = DateTime.Now;
DateTime dateOut = dateIn.AddDays(3);
string sql = "sp_booking";
int result;
//+ user +"," + numRoom + "," + checkIn + "," + checkOut + "," + result
result = ConnectData.ExcuteProcedure(sql, user, num, dateIn, dateOut);
if (result == 1)
{
MessageBox.Show("We're sorry about this !! \n This room is booked. Please try book the another!", "Error");
danhsachphongtrong.CancelEdit();
}
else
{
MessageBox.Show("Successfull !!");
ConnectData.Connect();
Application.Restart();
}
}