public ActionResult ThemSP1KhuyenMai([Bind(Include = "MaKM,MaSP,MoTa,GiamGia")] SanPhamKhuyenMai spkm)
{
KhuyenMaiModel spm = new KhuyenMaiModel();
spm.ThemSPKhuyenMai(spkm);
return(RedirectToAction("DSSanPham", new { makm = spkm.MaKM }));
}
public ActionResult ThemSP1KhuyenMai([Bind(Include = "Id,Id,MoTa,GiamGia")] SanPhamKhuyenMai spkm)
{
var spm = new KhuyenMaiModel();
spm.ThemSPKhuyenMai(spkm);
return(RedirectToAction("DSSanPham", new { makm = spkm.KhuyenMaiId }));
}
internal void ThemSPKhuyenMai(SanPhamKhuyenMai item)
{
db.SanPhamKhuyenMais.Add(item);
db.SaveChanges();
var s = new SanPhamModel();
s.UpdateGiaBan(item.SanPhamId);
}
public async Task <List <SanPhamKhuyenMai> > layDSSanPhamCL(string key)
{
List <SanPhamKhuyenMai> dsSanPhamBig = new List <SanPhamKhuyenMai>();
using (var connection = new SqlConnection(connectionstr))
{
IEnumerable <SanPhamLoai> dsSanPham = null;
var p = new DynamicParameters();
p.Add("@KEYWORD", key);
p.Add("@TABLE", "SANPHAMLOAI");
DateTime now = DateTime.Now;
//Console.WriteLine("Now is " + now);
string ngay = now.ToString();
dsSanPham = connection.Query <SanPhamLoai>("SP_GETALL", p, commandType: CommandType.StoredProcedure);
foreach (var item in dsSanPham)
{
string query = @"select CT.GiamGia
from CHITIETKHUYENMAI CT inner join KHUYENMAI KM
ON CT.MaKM = KM.MaKM
WHERE '" + ngay + "' BETWEEN KM.NgayBD AND KM.NgayKT AND CT.MaSP = '" + item.MaSP + "' AND TrangThai = 1 ";
int giamGia = connection.QuerySingleOrDefault <int>(query, commandType: CommandType.Text);
if (giamGia == null)
{
giamGia = 0;
}
SanPhamKhuyenMai sp = new SanPhamKhuyenMai();
sp.MaSP = item.MaSP;
sp.TenSP = item.TenSP;
sp.DonGia = item.DonGia;
sp.SoLuongTon = item.SoLuongTon;
sp.HinhAnh = item.HinhAnh;
sp.MoTa = item.MoTa;
sp.LuotXem = item.LuotXem;
sp.LuotBC = item.LuotBC;
sp.SoLanMua = item.SoLanMua;
sp.MaNCC = item.MaNCC;
sp.MaNSX = item.MaNSX;
sp.MaLoaiSP = item.MaLoaiSP;
sp.TrangThai = item.TrangThai;
sp.SPMoi = item.SPMoi;
sp.GiamGia = giamGia;
dsSanPhamBig.Add(sp);
}
}
return(dsSanPhamBig);
}
