public int themCTKM(eCTKhuyenMai ctkm) { if (kiemtraCTKM(ctkm.msDotKM)) { var r = from c in db.Tbl_CTKhuyenMais where c.msDotKM == ctkm.msDotKM select new { c.phantramKM }; int kq = Convert.ToInt32(ctkm.phantramKM); foreach (var k in r) { kq += Convert.ToInt32(k.phantramKM); } IQueryable <Tbl_CTKhuyenMai> ct1 = db.Tbl_CTKhuyenMais.Where(x => x.msDotKM.Equals(ctkm.msDotKM)); ct1.First().phantramKM = kq; return(0); } Tbl_CTKhuyenMai p = new Tbl_CTKhuyenMai(); p.ghiChu = ctkm.ghiChu; p.maSP = ctkm.maSP; p.msDotKM = ctkm.msDotKM; p.phantramKM = ctkm.phantramKM; db.Tbl_CTKhuyenMais.InsertOnSubmit(p); db.SubmitChanges(); return(1); }
private void dgvctkhuyenmai_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e) { if (dgvctkhuyenmai.SelectedRows.Count > 0) { eCTKhuyenMai ectkm = (eCTKhuyenMai)bds.Current; txtMaSoDotKhuyenMai.Text = e.Row.Cells["msDotKM"].Value.ToString(); txtmaSpkm.Text = e.Row.Cells["maSP"].Value.ToString(); txtphanTramKM.Text = e.Row.Cells["phantramKM"].Value.ToString(); txtghiChukmct.Text = e.Row.Cells["ghiChu"].Value.ToString(); } }
private void btnthemctkm_Click(object sender, EventArgs e) { eCTKhuyenMai m = new eCTKhuyenMai(); m.msDotKM = cmbmsDotKm.Text; m.ghiChu = txtghiChukmct.Text; m.maSP = txtmaSpkm.Text; m.phantramKM = Convert.ToDouble(txtphanTramKM.Text); int k = kmbll.themCTKM(m); 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(); }
public List <eCTKhuyenMai> getAllCTKM() { var ctkm = db.Tbl_CTKhuyenMais.ToList(); List <eCTKhuyenMai> kq = new List <eCTKhuyenMai>(); foreach (Tbl_CTKhuyenMai tmp in ctkm) { eCTKhuyenMai newctkm = new eCTKhuyenMai(); newctkm.ghiChu = tmp.ghiChu; newctkm.maSP = tmp.maSP; newctkm.msDotKM = tmp.msDotKM; newctkm.phantramKM = tmp.phantramKM; kq.Add(newctkm); } return(kq); }