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);
}
public bool kiemtract(string hd, string sp)
{
Tbl_CTHDBanSi r = db.Tbl_CTHDBanSis.Where(x => x.maHD == hd && x.maSP == sp).FirstOrDefault();
if (r != null)
{
return(true);
}
return(false);
}
public static eCTHDBanSi e(Tbl_CTHDBanSi p)
{
return(new eCTHDBanSi(p.maHD, p.maSP, Convert.ToInt32(p.soluong), Convert.ToString(p.dongiaBan), p.ghiChu));
}
