// Get 1 schedule theo MaDatPhong
public dsOrderPhong get1Schedule(int MaDatPhong)
{
string sql = "Select * From datphong Where MaDatPhong=@MaDatPhong";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("MaDatPhong", MaDatPhong);
SqlDataReader reader = cmd.ExecuteReader();
dsOrderPhong dsDatPhong = null;
if (reader.Read())
{
dsDatPhong = new dsOrderPhong();
dsDatPhong.MaDatPhong = (int)reader["MaDatPhong"];
dsDatPhong.HoTen = (string)reader["HoTen"];
dsDatPhong.SDT = (string)reader["sdt"];
dsDatPhong.MaPhong = (int)reader["MaPhong"];
dsDatPhong.thoigianvao = (DateTime)reader["thoigianvao"];
dsDatPhong.thoigianra = (DateTime)reader["thoigianra"];
}
conn.Close();
return(dsDatPhong);
}
// Get ra danh sách đặt phòng đã đi vs MaDatPhong=0
public List <dsOrderPhong> getdatphong1()
{
string sql = "Select * From datphong, phong where datphong.MaPhong=phong.MaPhong and datphong.TrangThai=1 ORDER BY MaDatPhong DESC";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
List <dsOrderPhong> li = new List <dsOrderPhong>();
while (reader.Read())
{
dsOrderPhong schedule = new dsOrderPhong();
schedule.MaDatPhong = (int)reader["MaDatPhong"];
schedule.HoTen = (string)reader["HoTen"];
schedule.SDT = (string)reader["sdt"];
schedule.MaPhong = (int)reader["MaPhong"];
schedule.TenPhong = (string)reader["TenPhong"];
schedule.thoigianvao = (DateTime)reader["thoigianvao"];
schedule.thoigianra = (DateTime)reader["thoigianra"];
schedule.TrangThai = (Boolean)reader["TrangThai"];
li.Add(schedule);
}
conn.Close();
return(li);
}
protected void btn_BookRoom_Click(object sender, EventArgs e)
{
dsOrderPhong orderPhong = new dsOrderPhong();
orderPhong.HoTen = txtFullname.Text;
orderPhong.SDT = txtPhone.Text;
orderPhong.thoigianvao = DateTime.Parse(txtTimeStart.Text);
orderPhong.thoigianra = DateTime.Parse(txtTimeEnd.Text);
orderPhong.MaPhong = int.Parse(DDL_Phong.SelectedValue);
DateTime DateIn = (orderPhong.thoigianvao);
DateTime DateOut = (orderPhong.thoigianra);
TimeSpan tmp = DateOut.Subtract(DateIn);
double soGio = tmp.TotalMinutes;
if (DateTime.Parse(txtTimeStart.Text) > DateTime.Parse(txtTimeEnd.Text))
{
err_msg.ForeColor = System.Drawing.Color.Aqua;
err_msg.Text = "Khoảng thời gian không hợp lệ";
}
else
{
try
{
var MaPhong = int.Parse(DDL_Phong.SelectedValue);
if (datPhong.checkPhong(MaPhong))
{
err_msg.Text = "Phòng này đã có người đặt";
}
else
{
// Thêm đặt phòng
Int32 MaDatPhong = datPhong.ThemDatPhong(orderPhong);
// Cập nhật trạng thái phòng = 1
datPhong.phongdaSuDung(orderPhong.MaPhong);
datPhong.taoHoaDon(MaDatPhong, soGio);
err_msg.ForeColor = System.Drawing.Color.Aqua;
err_msg.Text = "Bạn đã đặt phòng thành công!";
}
}
catch (Exception ex)
{
err_msg.ForeColor = System.Drawing.Color.Red;
err_msg.Text = "Đã xảy ra lỗi: " + ex.Message;
}
}
}
// Update schedule
public void updateSchedule(dsOrderPhong dsDatPhong)
{
string sql = "Update datphong Set HoTen=@HoTen, sdt=@sdt, MaPhong=@MaPhong, thoigianvao=@thoigianvao, thoigianra=@thoigianra Where MaDatPhong=@MaDatPhong";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("MaDatPhong", dsDatPhong.MaDatPhong);
cmd.Parameters.AddWithValue("HoTen", dsDatPhong.HoTen);
cmd.Parameters.AddWithValue("sdt", dsDatPhong.SDT);
cmd.Parameters.AddWithValue("MaPhong", dsDatPhong.MaPhong);
cmd.Parameters.AddWithValue("thoigianvao", dsDatPhong.thoigianvao);
cmd.Parameters.AddWithValue("thoigianra", dsDatPhong.thoigianra);
cmd.ExecuteNonQuery();
conn.Close();
}
// Khách hàng Thêm 1 đặt phòng
public int ThemDatPhong(dsOrderPhong dsDatPhong)
{
string sql = "Insert into DatPhong(Hoten,sdt,thoigianvao,thoigianra,maphong) output INSERTED.MaDatPhong values (@hoten,@sdt,@timeIn,@timeOut,@maphong)";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@hoten", dsDatPhong.HoTen);
cmd.Parameters.AddWithValue("@sdt", dsDatPhong.SDT);
cmd.Parameters.AddWithValue("@timeIn", dsDatPhong.thoigianvao);
cmd.Parameters.AddWithValue("@timeOut", dsDatPhong.thoigianra);
cmd.Parameters.AddWithValue("@maphong", dsDatPhong.MaPhong);
int MaDatPhong = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(MaDatPhong);
}