public int themcthoadon(eCTMuaHangNCC ctmh)
{
if (kiemtract(ctmh.maHD, ctmh.maSP))
{
var r = from c in db.Tbl_CTMuaHangNCCs
where c.maHD == ctmh.maHD
select new { c.soluong };
int kq = Convert.ToInt32(ctmh.soluong);
foreach (var k in r)
{
kq += Convert.ToInt32(k.soluong);
}
IQueryable <Tbl_CTMuaHangNCC> hd1 = db.Tbl_CTMuaHangNCCs.Where(x => x.maHD.Equals(ctmh.maHD) && x.maSP.Equals(ctmh.maSP));
hd1.First().soluong = kq;
return(0);
}
Tbl_CTMuaHangNCC si = new Tbl_CTMuaHangNCC();
si.maHD = ctmh.maHD;
si.maSP = Convert.ToInt32(ctmh.maSP);
si.soluong = ctmh.soluong;
si.ghichu = ctmh.ghiChu;
si.dongiaMua = Convert.ToInt32(ctmh.dongiaMua);
db.Tbl_CTMuaHangNCCs.InsertOnSubmit(si);
db.SubmitChanges();
return(1);
}
public bool kiemtra(string ma)
{
Tbl_CTMuaHangNCC r = db.Tbl_CTMuaHangNCCs.Where(x => x.maHD == ma).FirstOrDefault();
if (r != null)
{
return(true);
}
return(false);
}
public bool kiemtract(string hd, int sp)
{
Tbl_CTMuaHangNCC r = db.Tbl_CTMuaHangNCCs.Where(x => x.maHD == hd && x.maSP == Convert.ToInt16(sp)).FirstOrDefault();
if (r != null)
{
return(true);
}
return(false);
}
public static eCTMuaHangNCC e(Tbl_CTMuaHangNCC p)
{
return(new eCTMuaHangNCC(Convert.ToString(p.maHD), Convert.ToInt32(p.maSP), Convert.ToInt32(p.soluong), Convert.ToString(p.dongiaMua), p.ghichu));
}
