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);
}
