public static int ThayDoiPhongChoKhach(PhieuDangKy_DTO pdkDTO, Phong_DTO phgDTO) { int count = 0; string maPhongCu = ""; try { string strTruyVan_LayMaPhongCu = string.Format("SELECT MaPhong from ChiTietLoaiPhong where MaPhieuDK = '" + pdkDTO.MaPhieuDK + "'"); maPhongCu = DataProvider.ExecuteScalar(strTruyVan_LayMaPhongCu); string strTruyVan_ThayDoiTTPhong = string.Format("Update Phong SET TinhTrangPhong = 0 WHERE MaPhong = '" + maPhongCu + "'"); count = DataProvider.ExecuteNonQuery(strTruyVan_ThayDoiTTPhong); string strTruyVan_Update = string.Format("UPDATE ChiTietLoaiPhong SET MaPhong = '" + phgDTO.MaPhong + "' WHERE MaPhieuDK = '" + pdkDTO.MaPhieuDK + "'"); count = DataProvider.ExecuteNonQuery(strTruyVan_Update); string strTruyVan_ThayDoiTTPhong_2 = string.Format("Update Phong SET TinhTrangPhong = 1 WHERE MaPhong = '" + phgDTO.MaPhong + "'"); count = DataProvider.ExecuteNonQuery(strTruyVan_ThayDoiTTPhong_2); } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(count); }
public static int LayTienLoaiPhong(string maPhong) { int count = 0; try { string strTruyVan = string.Format("SELECT distinct GiaLoaiPhong FROM Phong as PHG inner join LoaiPhong as LPG on PHG.MaLoaiPhong = LPG.MaLoaiPhong where PHG.MaPhong = '" + maPhong + "' and TinhTrangPhong = 1"); string tam = DataProvider.ExecuteScalar(strTruyVan).ToString().Split('.')[0]; count = int.Parse(tam); } catch (Exception ex) { throw ex; } return(count); }
public static int LayTienDatCoc(string maPhong) { int count = 0; try { string strTruyVan = string.Format("select PDK.TienDatCoc,PDK.MaPhieuDK from PhieuDangKy as PDK inner join ChiTietLoaiPhong as CTLP on PDK.MaPhieuDK = CTLP.MaPhieuDK inner join ChiTietHoaDon as CTHD on CTHD.MaPhong = CTLP.MaPhong where CTLP.MaPhong = '" + maPhong + "'"); string tmp = DataProvider.ExecuteScalar(strTruyVan).ToString().Split('.')[0]; count = int.Parse(tmp); } catch (Exception ex) { throw ex; } return(count); }
public static string TongTien(string maPhong) { string count = ""; try { string strTruyVan = string.Format("select sum(ThanhTien) from DanhSachSDDichVu where MaPhong = '" + maPhong + "'"); count = DataProvider.ExecuteScalar(strTruyVan); } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(count); }
public static int CapNhatLaiTrangThaiPhong(PhieuDangKy_DTO pdkDTO, Phong_DTO phgDTO) { int count = 0; string MaPhong = ""; try { string strTruyVan_LayMaPhongHienTai = string.Format("SELECT MaPhong from ChiTietLoaiPhong WHERE MaPhieuDK = '" + pdkDTO.MaPhieuDK + "'"); MaPhong = DataProvider.ExecuteScalar(strTruyVan_LayMaPhongHienTai); string strTruyVan_UpdateTTP = string.Format("UPDATE Phong SET TinhTrangPhong = 0 WHERE MaPhong = '" + MaPhong + "'"); count = DataProvider.ExecuteNonQuery(strTruyVan_UpdateTTP); return(count); } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(count); }
public static int LayTienDichVu(string maPhong) { int count = 0; try { string strTruyVan = string.Format("create view Tam as select distinct p.MaPhong, p.TenPhong, k.TenKH,ldv.MaLoaiDichVu,ldv.TenLoaiDichVu,dv.MaDichVu,TenDichVu,count(TenDichVu) as [SoLuong],sum(ThanhTien)as [Tong Tien] from DanhSachSDDichVu d join Phong p on p.MaPhong = d.MaPhong join ChiTietLoaiPhong c on p.MaPhong = c.MaPhong join PhieuDangKy ph on ph.MaPhieuDK = c.MaPhieuDK join KhachHang k on k.MaKH = ph.MaKH join DichVu dv on dv.MaDichVu = d.MaDichVu join LoaiDichVu ldv on dv.MaLoaiDichVu = ldv.MaLoaiDichVu where p.MaPhong = '" + maPhong + "' group by TenDichVu, k.TenKH, p.TenPhong, p.MaPhong, dv.MaDichVu, ldv.MaLoaiDichVu, ldv.TenLoaiDichVu"); DataProvider.fillDataSet(strTruyVan); string strTruyVan2 = string.Format("select sum([Tong Tien]) from Tam"); string tmp = DataProvider.ExecuteScalar(strTruyVan2).ToString().Split('.')[0]; count = int.Parse(tmp); string strTruyVan3 = string.Format("drop view Tam"); DataProvider.ExecuteNonQuery(strTruyVan3); } catch (Exception ex) { throw ex; } return(count); }