void LuuRap() { if (txbRMaRap.Text == "") { return; } RapDAO ttRap = new RapDAO() { MaRap = txbRMaRap.Text, TenRap = txbRTenRap.Text, DiaChi = txbRDiaChi.Text, DienThoai = txbRDienThoai.Text }; if (rap.KiemTraRap(ttRap.MaRap)) { rap.SuaRap(ttRap); } else { rap.ThemRap(ttRap); } MessageBox.Show("Lưu rạp thành công!"); LoadDtgvRap(); }
public bool SuaRap(RapDAO rap) { string query = string.Format("UPDATE dbo.Rap SET tenrap=N'{0}',diachi=N'{1}',dienthoai='{2}' WHERE marap ='{3}'", rap.TenRap, rap.DiaChi, rap.DienThoai, rap.MaRap); return(DataProvider.Instance.ExcuteNonQuery(query) > 0); }
public bool ThemRap(RapDAO rap) { string query = string.Format("INSERT INTO dbo.Rap( marap, tenrap, diachi, dienthoai, sophong,tongsoghe) VALUES( '{0}', N'{1}', N'{2}', '{3}', {4},{5})", rap.MaRap, rap.TenRap, rap.DiaChi, rap.DienThoai, 0, 0); return(DataProvider.Instance.ExcuteNonQuery(query) > 0); }