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