public bool ThemTinQuangCao(TinQC pTinQC)
{
string query = "INSERT INTO dbo.TINDANG_QUANGCAO " +
"(NOIDUNG, NGUOIDANG, NGAYDANG, MAHOPDONG) " +
"VALUES (@noidung, @nguoidang, @ngaydang, @mahopdong) ";
SqlConnection conn = DBUtils.GetDBConnection();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@noidung", SqlDbType.Text).Value = pTinQC.NoiDung;
cmd.Parameters.Add("@nguoidang", SqlDbType.Int).Value = pTinQC.NguoiDang;
cmd.Parameters.Add("@ngaydang", SqlDbType.Date).Value = pTinQC.NgayDang;
cmd.Parameters.Add("@mahopdong", SqlDbType.Int).Value = pTinQC.MaHopDong;
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
DateTime curDate = DateTime.Today;
TinQC tinqc = new TinQC(Id, txtNoiDung.Text, curDate.Date);
if (bus_quanlyquangcao.CapNhatTinQuangCao(tinqc))
{
HienThiQC();
}
else
{
MessageBox.Show("Đã xảy ra lỗi!");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
DateTime curDate = DateTime.Today;
TinQC tinqc = new TinQC(Id);
if (bus_quanlyquangcao.XoaTinQuangCao(tinqc))
{
HienThiQC();
}
else
{
MessageBox.Show("Đã xảy ra lỗi!");
}
}
private void btnDang_Click(object sender, EventArgs e)
{
DateTime curDate = DateTime.Today;
TinQC tinqc = new TinQC(txtNoiDung.Text, Int32.Parse(txtMaNV.Text), curDate.Date, cbxTenDoiTac.SelectedValue.ToString());
if (bus_quanlyquangcao.ThemTinQuangCao(tinqc))
{
HienThiQC();
}
else
{
MessageBox.Show("Đã xảy ra lỗi!");
}
}
public bool XoaTinQuangCao(TinQC pTinQC)
{
string query = "DELETE dbo.TINDANG_QUANGCAO WHERE ID=@id";
SqlConnection conn = DBUtils.GetDBConnection();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = pTinQC.ID;
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatTinQuangCao(TinQC pTinQC)
{
string query = "UPDATE dbo.TINDANG_QUANGCAO SET NOIDUNG = @noidung, NGAYSUA=@ngaysua WHERE ID=@id";
SqlConnection conn = DBUtils.GetDBConnection();
try
{
conn.Open();
DateTime dtDate = DateTime.Today;
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = pTinQC.ID;
cmd.Parameters.Add("@noidung", SqlDbType.Text).Value = pTinQC.NoiDung;
cmd.Parameters.Add("@ngaysua", SqlDbType.Date).Value = dtDate.Date;
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatTinQuangCao(TinQC pTinQC)
{
return(dal_quanlyquangcao.CapNhatTinQuangCao(pTinQC));
}
public bool XoaTinQuangCao(TinQC pTinQC)
{
return(dal_quanlyquangcao.XoaTinQuangCao(pTinQC));
}
public bool ThemTinQuangCao(TinQC pTinQC)
{
return(dal_quanlyquangcao.ThemTinQuangCao(pTinQC));
}
