private void dgvKhachSan_CellClick(object sender, DataGridViewCellEventArgs e)
{
int currentRow = e.RowIndex;
if (-1 < currentRow && currentRow < dgvKhachSan.RowCount)
{
tbID.Text = dgvKhachSan.Rows[currentRow].Cells[0].Value.ToString();
tbName.Text = dgvKhachSan.Rows[currentRow].Cells[1].Value.ToString();
KhachSanDTO khachSanDTO = khachSanBUS.SelectKhachSanByID(tbID.Text);
tbAddress.Text = khachSanDTO.DiaChi;
tbPhoneNumber.Text = khachSanDTO.SoDienThoai;
if (!btDelete.Enabled)
{
btUpdate.Enabled = true;
btDelete.Enabled = true;
}
}
}
public Result Update(KhachSanDTO khachSanDTO)
{
string query = "UPDATE KHACHSAN SET " +
"[Ten] = @Ten, [DiaChi] = @DiaChi, [SoDienThoai] = @SoDienThoai " +
"WHERE [MaKhachSan] = @MaKhachSan ";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@MaKhachSan", SqlDbType.VarChar);
parameters[0].Value = khachSanDTO.ID;
parameters[1] = new SqlParameter("@Ten", SqlDbType.NVarChar);
parameters[1].Value = khachSanDTO.Ten;
parameters[2] = new SqlParameter("@DiaChi", SqlDbType.NVarChar);
parameters[2].Value = khachSanDTO.DiaChi;
parameters[3] = new SqlParameter("@SoDienThoai", SqlDbType.NVarChar);
parameters[3].Value = khachSanDTO.SoDienThoai;
return(dbConnection.executeUpdateQuery(query, parameters));
}
public List <KhachSanDTO> LayDanhSachKhachSan(int SoSao, string ThanhPho, decimal GiaMin, decimal GiaMax)
{
using (SqlConnection con = Connect())
{
con.Open();
string strStoredProcedure = "spTimKiemKhachSan";
SqlCommand cmd = new SqlCommand(strStoredProcedure);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@soSao", SoSao);
cmd.Parameters.AddWithValue("@thanhPho", ThanhPho);
cmd.Parameters.AddWithValue("@giaMin", GiaMin);
cmd.Parameters.AddWithValue("@giaMax", GiaMax);
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
List <KhachSanDTO> DanhSachKhachSan = new List <KhachSanDTO>();
foreach (DataRow r in dt.Rows)
{
KhachSanDTO ks = new KhachSanDTO();
ks.MaKS = (int)r["makS"];
ks.TenKS = r["tenKS"].ToString();
ks.SoSao = (int)r["soSao"];
ks.SoNha = r["soNha"].ToString();
ks.Duong = r["duong"].ToString();
ks.Quan = r["quan"].ToString();
ks.ThanhPho = r["thanhPho"].ToString();
ks.GiaTB = (decimal)r["giaTB"];
ks.MoTa = r["moTa"].ToString();
DanhSachKhachSan.Add(ks);
}
con.Close();
return(DanhSachKhachSan);
}
}
private void btAdd_Click(object sender, EventArgs e)
{
KhachSanDTO khachSanDTO = new KhachSanDTO();
khachSanDTO.ID = tbID.Text;
khachSanDTO.Ten = tbName.Text;
khachSanDTO.SoDienThoai = tbPhoneNumber.Text;
khachSanDTO.DiaChi = tbAddress.Text;
Result result = khachSanBUS.Insert(khachSanDTO);
if (result.Flag)
{
MessageBox.Show("Thêm mới khách sạn thành công", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
ResetField();
}
else
{
MessageBox.Show("Thêm mới khách sạn thành công\n Error: " + result.Message, "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public static bool ThemKhachSan(KhachSanDTO ks)
{
return(KhachSanDAO.ThemKhachSan(ks));
}
public Result Update(KhachSanDTO khachSanDTO)
{
return(khachSanDAO.Update(khachSanDTO));
}
public Result Insert(KhachSanDTO khachSanDTO)
{
return(khachSanDAO.Insert(khachSanDTO));
}
public static bool DatPhong(DatPhongDTO dp, KhachSanDTO ks, KhachHangDTO kh)
{
return(DatPhongDAO.DatPhong(dp, ks, kh));
}
