public async Task <List <SanPhamKM> > layDSSanPhamKMInsert()
{
List <SanPhamKM> danhSachSP = new List <SanPhamKM>();
using (var connection = new SqlConnection(connectionstr))
{
IEnumerable <SanPhamLoai> dsSanPham = null;
var p = new DynamicParameters();
p.Add("@KEYWORD", null);
p.Add("@TABLE", "SANPHAMLOAI");
DateTime now = DateTime.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 KM.TrangThai =1 ";
int giamGia = connection.QuerySingleOrDefault <int>(query, commandType: CommandType.Text);
if (giamGia == 0)
{
SanPhamKM sp = new SanPhamKM();
sp.MaSP = item.MaSP;
sp.TenSP = item.TenSP;
sp.GiamGia = 0;
danhSachSP.Add(sp);
}
}
}
return(danhSachSP);
}
public async Task <dynamic> layThongTinKhuyenMai(int MaKM)
{
var connection = new SqlConnection(connectionstr);
string queryGroupByMaKM = "SELECT SP.HinhAnh, SP.MaSP, (SELECT SPL.TenSP From SANPHAM_LOAI SPL WHERE SPL.MaSP = SP.MaSP) as TenSP, CTKM.GiamGia FROM CHITIETKHUYENMAI CTKM LEFT JOIN SANPHAM_LOAI SP ON CTKM.MaSP = SP.MaSP WHERE MaKM=" + MaKM;
var dsSanPham = connection.Query <SanPhamKM>(queryGroupByMaKM, commandType: CommandType.Text);
var p = new DynamicParameters();
p.Add("@ID", MaKM);
p.Add("@TABLE", "KHUYENMAI");
KhuyenMai khuyenMai = connection.QuerySingleOrDefault <KhuyenMai>("SP_GETDETAILBYID", p, commandType: CommandType.StoredProcedure);
if (khuyenMai == null)
{
var response = await tbl.TBLoi(ThongBaoLoi.Loi500, "Discount not exist!");
return(response.Content);
}
ChiTietKhuyenMaiVM thongTinCTKM = new ChiTietKhuyenMaiVM();
thongTinCTKM.MaKM = MaKM;
thongTinCTKM.NgayBD = khuyenMai.NgayBD;
thongTinCTKM.NgayKT = khuyenMai.NgayKT;
thongTinCTKM.MoTa = khuyenMai.MoTa;
thongTinCTKM.Code = khuyenMai.Code;
thongTinCTKM.MaNV = khuyenMai.MaNV;
// load thong tin nhân viên ???
foreach (var sanPham in dsSanPham)
{
SanPhamKM sanPhamKM = new SanPhamKM();
sanPhamKM.MaSP = sanPham.MaSP;
sanPhamKM.TenSP = sanPham.TenSP;
sanPhamKM.HinhAnh = sanPham.HinhAnh;
sanPhamKM.GiamGia = sanPham.GiamGia;
thongTinCTKM.giamGia = sanPham.GiamGia;
thongTinCTKM.DSSanPhamKM.Add(sanPhamKM);
}
return(thongTinCTKM);
}
