public static bool ThemPhong(DanhMucPhongDTO dmDTO) { SqlConnection con = DataProvider.ConnectionString(); string strsql = "insert into Phong (MaPhong, MaLP, TinhTrang, GhiChu)" + " values(" + dmDTO.MaPhong + "," + dmDTO.LoaiPhong + ",'" + dmDTO.TinhTrang + "','" + dmDTO.GhiChu + "')"; return DataProvider.ExecuteNonQuery(strsql, con); }
public static bool SuaPhong(DanhMucPhongDTO dmDTO) { SqlConnection con = DataProvider.ConnectionString(); string strsql = "update Phong set " + "MaLP = " + dmDTO.LoaiPhong + ",TinhTrang = '" + dmDTO.TinhTrang + "',GhiChu = '" + dmDTO.GhiChu + "' where MaPhong = " + dmDTO.MaPhong; return DataProvider.ExecuteNonQuery(strsql, con); }
public static DataSet LayThongTinPhong(DanhMucPhongDTO dmDTO) { SqlConnection con = DataProvider.ConnectionString(); string strsql = "select * from Phong where MaPhong = " + dmDTO.MaPhong; return DataProvider.GetDataSet(strsql, con); }
public static string LayTenPhong(DanhMucPhongDTO dmDTO) { SqlConnection con = DataProvider.ConnectionString(); string strsql = "select TenLP from LoaiPhong where MaLP = " + dmDTO.LoaiPhong; return DataProvider.ExecuteScalar(strsql, con); }
public static bool ThemPhong(DanhMucPhongDTO dmDTO) { return DanhMucPhongDAO.ThemPhong(dmDTO); }
public static bool SuaPhong(DanhMucPhongDTO dmDTO) { return DanhMucPhongDAO.SuaPhong(dmDTO); }
public static DataSet LayThongTinPhong(DanhMucPhongDTO dmDTO) { return DanhMucPhongDAO.LayThongTinPhong(dmDTO); }
public static string LayTenPhong(DanhMucPhongDTO dmDTO) { return DanhMucPhongDAO.LayTenPhong(dmDTO); }