private void btnthemkm_Click(object sender, EventArgs e) { eKhuyenMai k = new eKhuyenMai(); k.ghiChu = txtghiChukm.Text; k.msDotKM = txtMaSoDotKhuyenMai.Text; k.ngayBD = Convert.ToDateTime(dtpngaybatdaukm.Text); k.ngayKT = Convert.ToDateTime(dtpngayketthuckm.Text); k.tenDotKM = txtghiChukm.Text; int m = kmbll.themKM(k); if (m == 0) { MessageBox.Show("Trùng mã !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } else { if (m == 1) { MessageBox.Show("Thêm thành công !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } dgvkhuyenmai.DataSource = kmbll.getAllKM(); dgvctkhuyenmai.DataSource = kmbll.getAllCTKM(); } btnthemkm.Enabled = true; }
private void dgvkhuyenmai_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e) { if (dgvkhuyenmai.SelectedRows.Count > 0) { eKhuyenMai ekm = (eKhuyenMai)bds2.Current; txtMaSoDotKhuyenMai.Text = e.Row.Cells["msDotKM"].Value.ToString(); cmbmsDotKm.Text = e.Row.Cells["msDotKM"].Value.ToString(); dtpngaybatdaukm.Text = e.Row.Cells["ngayBD"].Value.ToString(); dtpngayketthuckm.Text = e.Row.Cells["ngayKT"].Value.ToString(); txtTenDotKhuyenMai.Text = e.Row.Cells["tenDotKM"].Value.ToString(); txtghiChukm.Text = e.Row.Cells["ghiChu"].Value.ToString(); } }
public List <eKhuyenMai> getAllKM() { var km = db.Tbl_KhuyenMais.ToList(); List <eKhuyenMai> kq = new List <eKhuyenMai>(); foreach (Tbl_KhuyenMai tmp in km) { eKhuyenMai newkm = new eKhuyenMai(); newkm.ghiChu = tmp.ghiChu; newkm.msDotKM = tmp.msDotKM; newkm.ngayBD = tmp.ngayBD; newkm.ngayKT = tmp.ngayKT; newkm.tenDotKM = tmp.tenDotKM; kq.Add(newkm); } return(kq); }
public int themKM(eKhuyenMai km) { var tkm = db.Tbl_KhuyenMais.Where(x => x.msDotKM == km.msDotKM).FirstOrDefault(); if (tkm != null) { return(0); } Tbl_KhuyenMai p = new Tbl_KhuyenMai(); p.msDotKM = km.msDotKM; p.tenDotKM = km.tenDotKM; p.ngayBD = km.ngayBD; p.ngayKT = km.ngayKT; p.ghiChu = km.ghiChu; db.Tbl_KhuyenMais.InsertOnSubmit(p); db.SubmitChanges(); return(1); }