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);
}
public bool kiemtraCTKM(string msdkm)
{
Tbl_CTKhuyenMai r = db.Tbl_CTKhuyenMais.Where(x => x.msDotKM == msdkm).FirstOrDefault();
if (r != null)
{
return(true);
}
return(false);
}
public static eCTKhuyenMai KhuyenMai(Tbl_CTKhuyenMai tmp)
{
return(new eCTKhuyenMai(tmp.msDotKM, tmp.maSP, Convert.ToDouble(tmp.phantramKM), tmp.ghiChu));
}
