public int themctpdnnk(eCTPhieuDNNK ctpdnnk)
{
if (kiemtractpdnnk(ctpdnnk.soPDNXK, ctpdnnk.maSP))
{
var r = from c in db.Tbl_CTPhieuDNNKs
where c.maSP == ctpdnnk.maSP
select new { c.soluong };
int kq = Convert.ToInt32(ctpdnnk.soluong);
foreach (var k in r)
{
kq += Convert.ToInt32(k.soluong);
}
IQueryable <Tbl_CTPhieuDNNK> dnnk1 = db.Tbl_CTPhieuDNNKs.Where(x => x.soPDNNK.Equals(ctpdnnk.soPDNXK) && x.maSP.Equals(ctpdnnk.maSP));
dnnk1.First().soluong = kq;
db.SubmitChanges();
return(0);
}
Tbl_CTPhieuDNNK nhap = new Tbl_CTPhieuDNNK();
nhap.soPDNNK = ctpdnnk.soPDNXK;
nhap.maSP = ctpdnnk.maSP;
nhap.soluong = Convert.ToInt32(ctpdnnk.soluong);
nhap.ghiChu = ctpdnnk.Ghichu;
db.Tbl_CTPhieuDNNKs.InsertOnSubmit(nhap);
db.SubmitChanges();
return(1);
}
public bool kiemtractpdnnk(string spdnnk, string msp)
{
Tbl_CTPhieuDNNK r = db.Tbl_CTPhieuDNNKs.Where(x => x.soPDNNK == spdnnk && x.maSP == msp).FirstOrDefault();
if (r != null)
{
return(true);
}
return(false);
}
public static eCTPhieuDNNK e(Tbl_CTPhieuDNNK k)
{
return(new eCTPhieuDNNK(k.soPDNNK, k.maSP, Convert.ToInt32(k.soluong), k.ghiChu));
}
