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