public int Update_KhuCanHo(KhuCanHoDAL kch) { //Check bieu thuc chinh quy string query = "UPDATE KHUCANHO SET tenKhu='" + kch.tenKhu + "', soTang=" + kch.soTang + ", soCanHo=" + kch.soCan + ",diaChi=N'" + kch.diaChi + "' where maKhu='" + kch.maKhu + "'"; return(DataProvider.Instance.ExcuteNonQuery(query)); //Return Thong bao loi hoac thanh cong }
public EditKhuCanHo(KhuCanHoDAL kch) { InitializeComponent(); soCan_suaKhuCanHo.Text = kch.soCan.ToString(); soTang_suaKhuCanHo.Text = kch.soTang.ToString(); diaChi_suaKhuCanHo.Text = kch.diaChi; maKhu_suaKhuCanHo.Text = kch.maKhu; tenKhu_suaKhuCanHo.Text = kch.tenKhu; }
public int Del_KhuCanHo(KhuCanHoDAL kch) { string query = "DELETE KHUCANHO WHERE maKhu='" + kch.maKhu + "'"; return(DataProvider.Instance.ExcuteNonQuery(query)); }
public int Add_KhuCanHo(KhuCanHoDAL kch) { string query = "insert into KHUCANHO values('" + kch.maKhu + "', '" + kch.tenKhu + "', " + kch.soCan + ", " + kch.soTang + ", N'" + kch.diaChi + "');"; return(DataProvider.Instance.ExcuteNonQuery(query)); }