public int InsertChiTietHoaDon(eChiTietChuongTrinhKhuyenMai Ctiet) { var Sanpham = from i in db.SanPhams where i.MaSP == Ctiet.MaSP select i; if (Sanpham.Any()) { var Chitiet = from i in db.ChiTietKhuyenMais where i.MaCT == Ctiet.MaCT && i.MaSp == Ctiet.MaSP select i; if (Chitiet.Any()) { throw new Exception("There Already Have"); } else { ChiTietKhuyenMai Ct = new ChiTietKhuyenMai(); Ct.MaCT = Ctiet.MaCT; Ct.MaSp = Ctiet.MaSP; Ct.DonGia = Convert.ToDecimal(Ctiet.DonGia); Ct.MucGiam = Ctiet.MucGiam; Ct.GiaKhuyenMai = Convert.ToDecimal(Ctiet.GiaKhuyenMai); db.ChiTietKhuyenMais.InsertOnSubmit(Ct); db.SubmitChanges(); return(1); } } else { throw new Exception("Invaild SanPham"); } }
public List <eChiTietChuongTrinhKhuyenMai> GetALLChitietKhuyenMaiByMaCT(string Ma) { var Chitiet = from i in db.ChiTietKhuyenMais where i.MaCT == Ma select i; List <eChiTietChuongTrinhKhuyenMai> Ls = new List <eChiTietChuongTrinhKhuyenMai>(); foreach (ChiTietKhuyenMai Ct in Chitiet.ToList()) { eChiTietChuongTrinhKhuyenMai newCt = new eChiTietChuongTrinhKhuyenMai(); newCt.MaCT = Ct.MaCT; newCt.MaSP = Ct.MaSp; newCt.MucGiam = Convert.ToDouble(Ct.MucGiam); newCt.DonGia = Convert.ToDouble(Ct.DonGia); newCt.GiaKhuyenMai = Convert.ToDouble(Ct.GiaKhuyenMai); Ls.Add(newCt); } return(Ls); }