public int themcthoadon(eCTHDBanSi ctbs)
{
if (kiemtract(ctbs.maHD, ctbs.maSP))
{
var r = from c in db.Tbl_CTHDBanSis
where c.maHD == ctbs.maHD
select new { c.soluong };
int kq = Convert.ToInt32(ctbs.soluong);
foreach (var k in r)
{
kq += Convert.ToInt32(k.soluong);
}
IQueryable <Tbl_CTHDBanSi> hd1 = db.Tbl_CTHDBanSis.Where(x => x.maHD.Equals(ctbs.maHD) && x.maSP.Equals(ctbs.maSP));
//hd1.First().maNV = hd;
hd1.First().soluong = kq;
// hd1.First().dongiaBan = Convert.ToInt32(dg);
//hd1.First().maNV=m
//hd1.First().ghiChu = ghichu;
return(0);
}
Tbl_CTHDBanSi si = new Tbl_CTHDBanSi();
si.maHD = ctbs.maHD;
si.maSP = ctbs.maSP;
si.soluong = ctbs.soluong;
si.ghiChu = ctbs.ghiChu;
si.dongiaBan = Convert.ToInt16(ctbs.dongiaBan);
db.Tbl_CTHDBanSis.InsertOnSubmit(si);
db.SubmitChanges();
return(1);
}
private void button1_Click(object sender, EventArgs e)
{
eCTHDBanSi n = new eCTHDBanSi()
{
maHD = txtmahopdongbansikh.Text,
maSP = txtmasanphambansikh.Text,
soluong = Convert.ToInt16(txtsoluongbansikh.Text),
dongiaBan = txtdongiaban.Text,
ghiChu = txtghichubansikh.Text
};
int kq1 = blbs.themcthoadon(n);
if (kq1 == 1 || kq1 != 1)
{
MessageBox.Show("them thanh cong");
}
dataGridView1.DataSource = blbs.GetallctHDbansi1();
}
