private void btn_Them_Click(object sender, EventArgs e)
{
if (cbo_tensp.Text == "" || txtnoidung.Text == "" || txtphamtram.Text == "")
{
MessageBox.Show("Không được để trống");
return;
}
var ktkc = from ct in ql.CT_KHUYENMAIs where ct.MAKHUYENMAI == kHUYENMAIDataGridView.CurrentRow.Cells[0].Value.ToString() &&
ct.MASP == cbo_tensp.SelectedValue.ToString()
select ct;
if (ktkc.Count() > 0)
{
MessageBox.Show("trùng khóa chính");
return;
}
CT_KHUYENMAI k = new CT_KHUYENMAI();
k.MAKHUYENMAI = kHUYENMAIDataGridView.CurrentRow.Cells[0].Value.ToString();
k.MASP = cbo_tensp.SelectedValue.ToString();
k.PHANTRAM = Convert.ToDouble(txtphamtram.Text);
k.NOIDUNGKM = txtnoidung.Text;
ql.CT_KHUYENMAIs.InsertOnSubmit(k);
ql.SubmitChanges();
frm_khuyenmai_Load(sender, e);
MessageBox.Show("Thành công");
btn_Them.Enabled = true;
}
private void buttonX6_Click(object sender, EventArgs e)
{
CT_KHUYENMAI ctkm = new CT_KHUYENMAI();
ctkm.MAKM = dataGridView2.CurrentRow.Cells[0].Value.ToString();
ctkm.MASP = cb_sp.SelectedValue.ToString();
ctkm.NBD = Convert.ToDateTime(dateTimeInput_ndb.Text.ToString());
ctkm.NKT = Convert.ToDateTime(dateTimeInput_nkt.Text.ToString());
if (ctkm_bll.ktkc_ctkm(ctkm) == false)
{
if (ctkm_bll.suactkm(ctkm) == true)
{
MessageBox.Show("sửa thành công");
dataGridView2.DataSource = ctkm_bll.loadbang_ct_sp_makm(txt_mkm.Text.ToString());
}
else
{
MessageBox.Show("thất bại");
}
}
else
{
MessageBox.Show("dữ liệu chưa tồn tại");
}
}
public bool them(CT_KHUYENMAI pmh)
{
try
{
da.CT_KHUYENMAIs.InsertOnSubmit(pmh);
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool xoa(CT_KHUYENMAI pmh)
{
try
{
CT_KHUYENMAI mh = da.CT_KHUYENMAIs.Where(t => t.MAKM == pmh.MAKM.ToString() && t.MASP == pmh.MASP.ToString() && t.NBD == Convert.ToDateTime(pmh.NBD.ToString())).FirstOrDefault();
da.CT_KHUYENMAIs.DeleteOnSubmit(mh);
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool sua(CT_KHUYENMAI pmh)
{
try
{
CT_KHUYENMAI thanhvien = da.CT_KHUYENMAIs.Where(t => t.MAKM == pmh.MAKM.ToString() && t.MASP == pmh.MASP.ToString() && t.NBD == Convert.ToDateTime(pmh.NBD.ToString())).FirstOrDefault();
thanhvien.MASP = pmh.MASP;
thanhvien.NBD = pmh.NBD;
thanhvien.NKT = pmh.NKT;
da.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool ktkc(CT_KHUYENMAI pmh)
{
int r = da.CT_KHUYENMAIs.Count(t => t.MAKM == pmh.MAKM.ToString() && t.MASP == pmh.MASP.ToString() && t.NBD == Convert.ToDateTime(pmh.NBD.ToString()));
try
{
if (r == 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtMaKM.Text == "" || txt_TenKm.Text == "" || edtngaybd.Text == "" || editnkt.Text == "" ||
cbo_tensp.Text == "" || txtnoidung.Text == "" || txtphamtram.Text == "")
{
MessageBox.Show("Không được để trống");
return;
}
var ktkc = from km in ql.KHUYENMAIs where km.MAKHUYENMAI == txtMaKM.Text select km;
if (ktkc.Count() > 0)
{
MessageBox.Show(" trùng khóa chính");
return;
}
var ktk = from ct in ql.CT_KHUYENMAIs
where ct.MAKHUYENMAI == txtMaKM.Text &&
ct.MASP == cbo_tensp.SelectedValue.ToString()
select ct;
if (ktk.Count() > 0)
{
MessageBox.Show("trùng khóa chính bảng CT_ Khuyến mãi");
return;
}
KHUYENMAI k = new KHUYENMAI();
CT_KHUYENMAI ctkm = new CT_KHUYENMAI();
k.MAKHUYENMAI = txtMaKM.Text;
k.TENKHUYENMAI = txt_TenKm.Text;
k.NGAYBD = Convert.ToDateTime(edtngaybd.Text);
k.NGAYKT = Convert.ToDateTime(editnkt.Text);
ctkm.MAKHUYENMAI = txtMaKM.Text;
ctkm.MASP = cbo_tensp.SelectedValue.ToString();
ctkm.PHANTRAM = Convert.ToDouble(txtphamtram.Text);
ctkm.NOIDUNGKM = txtnoidung.Text;
ql.CT_KHUYENMAIs.InsertOnSubmit(ctkm);
ql.KHUYENMAIs.InsertOnSubmit(k);
ql.SubmitChanges();
this.kHUYENMAITableAdapter.Fill(this.fPT_SHOPDataSet.KHUYENMAI);
MessageBox.Show("Thành công");
btn_Them.Enabled = true;
}
private void buttonX3_Click(object sender, EventArgs e)
{
CT_KHUYENMAI ctkm = new CT_KHUYENMAI();
ctkm.MAKM = dataGridView1.CurrentRow.Cells[0].Value.ToString();
ctkm.MASP = cb_sp.SelectedValue.ToString();
ctkm.NBD = Convert.ToDateTime(dateTimeInput_ndb.Text.ToString());
if (ctkm_bll.ktkc_ctkm(ctkm) == false)
{
if (ctkm_bll.xoactkm(ctkm) == true)
{
MessageBox.Show("xóa thành công");
dataGridView2.DataSource = ctkm_bll.loadbang_ct_sp_makm(txt_mkm.Text.ToString());
}
else
{
MessageBox.Show("bạn không có quyền xóa");
}
}
}
private void buttonX2_Click(object sender, EventArgs e)
{
if (txtmakm.Text == "" || txtmasp.Text == "" || dateNBD.Text == "" || dateNKT.Text == "")
{
MessageBox.Show("không được để trống");
return;
}
CT_KHUYENMAI ct = new CT_KHUYENMAI();
var kt = from s in db.CT_KHUYENMAIs where s.MAKM == txtmakm.Text && s.MASP == txtmasp.Text select s;
if (kt.Count() > 0)
{
MessageBox.Show("Trùng khóa chính");
return;
}
ct.MAKM = txtmakm_ct.Text;
ct.MASP = txtmasp.Text;
ct.NBD = Convert.ToDateTime(dateNBD.Text);
ct.NKT = Convert.ToDateTime(dateNKT.Text);
db.CT_KHUYENMAIs.InsertOnSubmit(ct);
db.SubmitChanges();
frm_KhuyenMai_Load(sender, e);
MessageBox.Show("thành công");
}
public bool xoactkm(CT_KHUYENMAI n)
{
return(ctkm.xoa(n));
}
public bool suactkm(CT_KHUYENMAI n)
{
return(ctkm.sua(n));
}
public bool themctkm(CT_KHUYENMAI n)
{
return(ctkm.them(n));
}
public bool ktkc_ctkm(CT_KHUYENMAI n)
{
return(ctkm.ktkc(n));
}
