public async Task <dynamic> suaSanPhamLoai(SanPhamLoai sanPhamLoai)
{
SanPhamLoai sanPhamCN;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
p.Add("@ID", sanPhamLoai.MaSP);
p.Add("TABLE", "SANPHAMLOAI");
sanPhamCN = connection.QuerySingleOrDefault <SanPhamLoai>("SP_GETDETAILBYID", p, commandType: CommandType.StoredProcedure);
}
if (sanPhamCN == null)
{
var response = await tbl.TBLoi(ThongBaoLoi.Loi500, "Product ID not exist!");
return(response.Content);
}
try
{
string hinhAnh = LoaiBoKyTu.bestLower(sanPhamLoai.TenSP) + "-" + LoaiBoKyTu.bestLower(sanPhamLoai.MaSP) + "." + sanPhamLoai.HinhAnh.Split('.')[sanPhamLoai.HinhAnh.Split('.').Length - 1];
hinhAnh = hostImage + hinhAnh;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
p.Add("@MaSP", sanPhamLoai.MaSP);
p.Add("@TenSP", sanPhamLoai.TenSP);
p.Add("@DonGia", sanPhamLoai.DonGia);
p.Add("@SoLuongTon", sanPhamLoai.SoLuongTon);
p.Add("@HinhAnh", hinhAnh);
p.Add("@MoTa", sanPhamLoai.MoTa);
p.Add("@LuotXem", sanPhamLoai.LuotXem);
p.Add("@LuotBC", sanPhamLoai.LuotBC);
p.Add("@SoLanMua", sanPhamLoai.SoLanMua);
p.Add("@MaNCC", sanPhamLoai.MaNCC);
p.Add("@MaNSX", sanPhamLoai.MaNSX);
p.Add("@MaLoaiSP", sanPhamLoai.MaLoaiSP);
p.Add("@TrangThai", sanPhamLoai.TrangThai);
p.Add("@SPMoi", sanPhamLoai.SPMoi);
connection.Query <SanPhamLoai>("SANPHAMLOAI_UPDATE", p, commandType: CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
var response = await tbl.TBLoi(ThongBaoLoi.Loi500, "UnSuitable Value!");
return(response.Content);
}
return(sanPhamLoai);
}
public async Task <dynamic> chiTietSanPhamAD(string maSP)
{
SanPhamLoai sanPhamLoai = null;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
var parameter = new DynamicParameters();
p.Add("@ID", maSP);
p.Add("@TABLE", "SANPHAMLOAI");
sanPhamLoai = connection.QuerySingleOrDefault <SanPhamLoai>("SP_GETDETAILBYID", p, commandType: CommandType.StoredProcedure);
parameter.Add("@MaSP", maSP);
}
if (sanPhamLoai == null)
{
var responsex = await tbl.TBLoi(ThongBaoLoi.Loi500, "Product not exist!");
return(responsex.Content);
}
return(sanPhamLoai);
}
public async Task <ActionResult> SuaSanPhamLoai(SanPhamLoai sanPhamLoaiChinhSua)
{
dynamic result = await _quanLySanPhamRepository.suaSanPhamLoai(sanPhamLoaiChinhSua);
return(Ok(result));
}
public async Task <IActionResult> ThemSanPhamLoai(SanPhamLoai sanPhamLoai)
{
dynamic result = await _quanLySanPhamRepository.themSanPhamLoai(sanPhamLoai);
return(Ok(result));
}
public async Task <dynamic> chiTietSanPham(string maSP)
{
SanPhamLoai sanPhamLoai = null;
SanPhamDetailVM sanPham = new SanPhamDetailVM();
int giamGia;
using (var connection = new SqlConnection(connectionstr))
{
var p = new DynamicParameters();
var parameter = new DynamicParameters();
p.Add("@ID", maSP);
p.Add("@TABLE", "SANPHAMLOAI");
sanPhamLoai = connection.QuerySingleOrDefault <SanPhamLoai>("SP_GETDETAILBYID", p, commandType: CommandType.StoredProcedure);
//parameter.Add("@MaSP", maSP);
//var lstBL = connection.Query<BinhLuanVM>("SP_LAYBINHLUANSP", parameter, commandType: CommandType.StoredProcedure);
//if (lstBL != null)
//{
// foreach (var bl in lstBL)
// {
// BinhLuanVM binhLuan = new BinhLuanVM();
// binhLuan.MaBL = bl.MaBL;
// binhLuan.TaiKhoan = bl.TaiKhoan;
// binhLuan.NgayTao = bl.NgayTao;
// binhLuan.DanhGia = bl.DanhGia;
// binhLuan.NoiDung = bl.NoiDung;
// sanPham.binhLuan.Add(binhLuan);
// }
//}
var lstSP = connection.Query <SanPhamLoai>("SELECT * FROM SANPHAM_LOAI WHERE MaLoaiSP='" + sanPhamLoai.MaLoaiSP + "' AND TrangThai=1", commandType: CommandType.Text);
if (lstSP != null)
{
foreach (var sp in lstSP)
{
SanPhamLoai spTuongTu = new SanPhamLoai();
spTuongTu.MaSP = sp.MaSP;
spTuongTu.MaLoaiSP = sp.MaLoaiSP;
spTuongTu.HinhAnh = sp.HinhAnh;
spTuongTu.DonGia = sp.DonGia;
spTuongTu.TenSP = sp.TenSP;
spTuongTu.SoLuongTon = sp.SoLuongTon;
spTuongTu.MoTa = sp.MoTa;
spTuongTu.MaNCC = sp.MaNCC;
spTuongTu.MaNSX = sp.MaNSX;
spTuongTu.HinhAnh = sp.HinhAnh;
spTuongTu.LuotBC = sp.LuotBC;
spTuongTu.LuotXem = sp.LuotXem;
spTuongTu.SPMoi = sp.SPMoi;
spTuongTu.TrangThai = sp.TrangThai;
sanPham.spTuongTu.Add(spTuongTu);
}
}
DateTime now = DateTime.Now;
string ngay = now.ToString();
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 = '" + maSP + "' AND TrangThai = 1 ";
giamGia = connection.QuerySingleOrDefault <int>(query, commandType: CommandType.Text);
if (giamGia == null)
{
giamGia = 0;
}
}
if (sanPhamLoai == null)
{
var response = await tbl.TBLoi(ThongBaoLoi.Loi500, "Product is not exist!");
return(response.Content);
}
sanPham.MaSP = sanPhamLoai.MaSP;
sanPham.luotBC = sanPhamLoai.LuotBC;
sanPham.TenSP = sanPhamLoai.TenSP;
sanPham.GiaGoc = sanPhamLoai.DonGia;
sanPham.DonGia = sanPhamLoai.DonGia - (sanPhamLoai.DonGia * giamGia / 100);
sanPham.SoLuongTon = sanPhamLoai.SoLuongTon;
sanPham.MoTa = sanPhamLoai.MoTa;
sanPham.MaNCC = sanPhamLoai.MaNCC;
sanPham.MaNSX = sanPhamLoai.MaNSX;
sanPham.HinhAnh = sanPhamLoai.HinhAnh;
sanPham.giamGia = giamGia;
// List<DSBinhLuanMaSP> result = ;
sanPham.binhLuan = await this.layDSBinhLuanSP(maSP);
return(sanPham);
}
