public DonHang GetDonHang(string maDh)
{
using (var context = new ClientDbContext())
{
return(context.DonHang.Find(maDh));
}
}
public string GetTenTSKT(string masp, string mats)
{
using (var context = new ClientDbContext())
{
var temp = context.ThongSoKiThuat.FirstOrDefault(x => x.MaSp == masp && x.ThongSo == mats);
if (temp != null)
{
return(temp.GiaTri);
}
return("");
}
}
public SanPham GetSanPham(string Id)
{
using (var context = new ClientDbContext())
{
try
{
return(context.SanPham.Find(Id));
} catch (Exception)
{
return(new SanPham());
}
}
}
public AnhSanPham GetAnhSanPham(string maSp)
{
using (var context = new ClientDbContext())
{
try
{
return(context.AnhSanPham.SingleOrDefault(x => x.MaSp == maSp));
} catch (Exception)
{
return(new AnhSanPham());
}
}
}
public List <NhaSanXuat> GetNSX()
{
using (var context = new ClientDbContext())
{
try
{
return(context.NhaSanXuat.ToList());
}
catch (Exception)
{
return(new List <NhaSanXuat>());
}
}
}
public List <SanPham> ReadSanPham(string loaiSp)
{
using (var context = new ClientDbContext())
{
try
{
return(context.SanPham.Where(x => x.LoaiSp == loaiSp).ToList());
}
catch (Exception)
{
return(new List <SanPham>());
}
}
}
public List <ThongSo> ReadThongSo(string loaiSp)
{
using (var context = new ClientDbContext())
{
try
{
return(context.ThongSo.Where(x => x.MaLoai == loaiSp).ToList());
}
catch (Exception)
{
return(new List <ThongSo>());
}
}
}
public List <ThongSoKiThuat> ReadThongSoKiThuat(string ma)
{
using (var context = new ClientDbContext())
{
try
{
return(context.ThongSoKiThuat.Where(x => x.MaSp == ma).ToList());
}
catch (Exception)
{
return(new List <ThongSoKiThuat>());
}
}
}
public string GetLoaiSp(string loaiSP)
{
using (var context = new ClientDbContext())
{
try
{
return(context.LoaiSp.Find(loaiSP).TenLoai);
}
catch (Exception)
{
return("");
}
}
}
public List <AspNetUsers> ViewSanPham()
{
using (var context = new ClientDbContext())
{
try
{
return(context.AspNetUsers.ToList());
}
catch (Exception)
{
return(new List <AspNetUsers>());
}
}
}
public AspNetUsers GetUser(string userId)
{
using (var context = new ClientDbContext())
{
try
{
return(context.AspNetUsers.Find(userId));
}
catch (Exception)
{
return(new AspNetUsers());
}
}
}
public bool ExistUser(string id)
{
using (var context = new ClientDbContext())
{
try
{
var a = context.AspNetUsers.Find(id);
return(a != null);
}
catch (Exception)
{
return(false);
}
}
}
public string GetRoleName(string id)
{
using (var context = new ClientDbContext())
{
try
{
var b = context.AspNetUserRoles.SingleOrDefault(x => x.UserId == id);
var res = context.AspNetRoles.SingleOrDefault(x => x.Id == b.RoleId);
return(res.Name);
}
catch (Exception)
{
return("");
}
}
}
public List <LoaiSp> ReadLoaiSp()
{
using (var context = new ClientDbContext())
{
var result = new List <LoaiSp>();
foreach (var item in context.LoaiSp.ToList())
{
if (item.TenLoai != "Phụ Kiện")
{
result.Add(item);
}
}
return(result);
}
}
public List <string> getGiaTriThongSoKiThuat(List <ThongSoKiThuat> lst)
{
using (var context = new ClientDbContext())
{
try
{
var result = new List <string>();
foreach (var item in lst)
{
result.Add(item.GiaTri.ToLower());
}
return(result);
}
catch (Exception)
{
return(new List <string>());
}
}
}
public IQueryable <SanPham> FilterSanphamBySpecialFeature(IQueryable <SanPham> sanphams,
string _featureString, ClientDbContext context)
{
var _filter_ = new List <IQueryable <SanPham> >();
foreach (var _featureValue in _featureString.Split('-'))
{
if (!string.IsNullOrEmpty(_featureValue))
{
var _sanphams = from s in sanphams
join t in context.ThongSoKiThuat
on s.MaSp equals t.MaSp
where t.GiaTri.ToLower().Contains(_featureValue.ToLower()) && s.LoaiSp.Contains("LSP0008")
select s;
_filter_.Add(_sanphams);
}
}
_filter_.ToList().ForEach(item => _filter_[0] = _filter_[0].Union(item));
return(sanphams.Intersect(_filter_[0]));
}
public IQueryable <SanPham> FilterSanPhamWithParam(IQueryable <SanPham> sanphams, string params_list,
string loaiSp, ClientDbContext context)
{
if (!string.IsNullOrEmpty(params_list) && !string.IsNullOrEmpty(loaiSp))
{
sanphams = sanphams.Where(s => s.LoaiSp == loaiSp);
//for Laptop
if (loaiSp == "LSP0008")
{
foreach (var _param in params_list.Split('&'))
{
if (!string.IsNullOrEmpty(_param))
{
if (_param.Contains('f'))
{
var _tmp_param_1 = Regex.Replace(_param, "f", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterLaptopByRam(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('j'))
{
var _tmp_param_1 = Regex.Replace(_param, "j", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterLaptopByCpu(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('w'))
{
var _tmp_param_1 = Regex.Replace(_param, "w", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterLaptopByRequire(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('z'))
{
var _tmp_param_1 = Regex.Replace(_param, "z", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterSanphamBySpecialFeature(sanphams, _tmp_param_1, context);
}
}
}
}
}
else if (loaiSp == "LSP0002")
{
foreach (var _param in params_list.Split('&'))
{
if (!string.IsNullOrEmpty(_param))
{
if (_param.Contains('f'))
{
var _tmp_param_1 = Regex.Replace(_param, "f", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterPhoneByOs(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('j'))
{
var _tmp_param_1 = Regex.Replace(_param, "j", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterPhoneByBattery(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('w'))
{
var _tmp_param_1 = Regex.Replace(_param, "w", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterPhoneByScreenSize(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('z'))
{
var _tmp_param_1 = Regex.Replace(_param, "z", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterPhoneBySpecialFeature(sanphams, _tmp_param_1, context);
}
}
}
}
}
else if (loaiSp == "LSP0007")
{
foreach (var _param in params_list.Split('&'))
{
if (!string.IsNullOrEmpty(_param))
{
if (_param.Contains('f'))
{
var _tmp_param_1 = Regex.Replace(_param, "f", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterTabletByScreenSize(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('j'))
{
var _tmp_param_1 = Regex.Replace(_param, "j", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterTabletByRam(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('w'))
{
var _tmp_param_1 = Regex.Replace(_param, "w", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterTabletBySim(sanphams, _tmp_param_1, context);
}
}
else if (_param.Contains('z'))
{
var _tmp_param_1 = Regex.Replace(_param, "z", "");
if (!string.IsNullOrEmpty(_tmp_param_1))
{
sanphams = FilterPhoneBySpecialFeature(sanphams, _tmp_param_1, context);
}
}
}
}
}
return(sanphams);
}
return(sanphams);
}
public IQueryable <SanPham> FilterTabletBySim(IQueryable <SanPham> sanphams, string _simString, ClientDbContext context)
{
var _filter_ = new List <IQueryable <SanPham> >();
foreach (var _simValue in _simString.Split('-'))
{
if (!string.IsNullOrEmpty(_simValue))
{
var _sanphams = from s in sanphams
join t in context.ThongSoKiThuat
on s.MaSp equals t.MaSp
where t.GiaTri.ToLower().Contains(_simValue.ToLower()) && t.ThongSo == "TS0037" &&
s.LoaiSp == "LSP0007"
select s;
_filter_.Add(_sanphams);
}
}
_filter_.ToList().ForEach(item => _filter_[0] = _filter_[0].Intersect(item));
var result = sanphams.Intersect(_filter_[0]);
return(result);
}
public IQueryable <SanPham> FilterPhoneByScreenSize(IQueryable <SanPham> sanphams, string _screenString, ClientDbContext context)
{
var _filter_ = new List <IQueryable <SanPham> >();
foreach (var _screenValue in _screenString.Split('-'))
{
if (!string.IsNullOrEmpty(_screenValue))
{
switch (_screenValue)
{
case "small":
{
var a1 = from s in context.SanPham
join t in context.ThongSoKiThuat
on s.MaSp equals t.MaSp
where Convert.ToInt32(t.GiaTri.Substring(0, 1)) < 6 && t.ThongSo.Contains("TS0002") &&
s.LoaiSp.Contains("LSP0002")
select s;
_filter_.Add(a1);
break;
}
case "medium":
{
var a1 = from s in context.SanPham
join t in context.ThongSoKiThuat
on s.MaSp equals t.MaSp
where 6 <= Convert.ToInt32(t.GiaTri.ToLower().Substring(0, 1)) &&
Convert.ToInt32(t.GiaTri.ToLower().Substring(0, 1)) < 8 &&
t.ThongSo.Contains("TS0002") && s.LoaiSp.Contains("LSP0002")
select s;
_filter_.Add(a1);
break;
}
case "big":
{
var a1 = from s in context.SanPham
join t in context.ThongSoKiThuat
on s.MaSp equals t.MaSp
where 8 <= Convert.ToInt32(t.GiaTri.ToLower().Substring(0, 1)) &&
t.ThongSo.Contains("TS0002") && s.LoaiSp.Contains("LSP0002")
select s;
_filter_.Add(a1);
break;
}
}
}
}
_filter_.ToList().ForEach(item => _filter_[0] = _filter_[0].Intersect(item));
return(sanphams.Intersect(_filter_[0]));
}
public IQueryable <SanPham> FilterLaptopByRequire(IQueryable <SanPham> sanphams, string _requireString, ClientDbContext context)
{
var _filter_ = new List <IQueryable <SanPham> >();
foreach (var _requireValue in _requireString.Split('-'))
{
if (!string.IsNullOrEmpty(_requireValue))
{
if (_requireValue == "type_1") //học tập
{
var s1 = FilterLaptopByRam(sanphams, "4GB", context);
var s2 = FilterLaptopByCpu(sanphams, "i3", context);
_filter_.Add(s1);
_filter_.Add(s2);
}
else if (_requireValue.Contains("type_2")) //đồ họa
{
var s1 = from s in context.SanPham where s.TenSp.ToLower().Contains("macbook") select s;
var s2 = FilterLaptopByCpu(sanphams, "i5", context);
var s3 = FilterLaptopByRam(sanphams, "8gb", context);
_filter_.Add(s1);
_filter_.Add(s2);
_filter_.Add(s3);
}
else if (_requireValue == "type_3") //văn phòng
{
var s1 = from s in context.SanPham where s.TenSp.ToLower().Contains("macbook") select s;
var s2 = FilterLaptopByCpu(sanphams, "i3", context);
var s3 = FilterLaptopByRam(sanphams, "4gb", context);
_filter_.Add(s1);
_filter_.Add(s2);
_filter_.Add(s3);
}
}
}
_filter_.ToList().ForEach(item => _filter_[0] = _filter_[0].Union(item));
return(sanphams.Intersect(_filter_[0]));
}
