public List <OnlineGym_Model.Izlazi> Get(IzlazSearchRequest search) { var query = _context.Set <Database.Izlazi>().Include(c => c.Narudzbe).AsQueryable(); if (search?.Datum.HasValue == true) { DateTime date = new DateTime(); date = search.Datum.Value; query = query.Where(x => x.Datum.Date.CompareTo(date.Date) == 0); } if (search?.Zakljucen.HasValue == true) { query = query.Where(x => x.Zakljucen == search.Zakljucen); } if (search?.NarudzbaId.HasValue == true) { query = query.Where(x => x.NarudzbaId == search.NarudzbaId); } query = query.OrderBy(x => x.Datum); var list = query.ToList(); return(_mapper.Map <List <OnlineGym_Model.Izlazi> >(list)); }
public List <OnlineGym_Model.Narudzbe> Get(NarudzbaSearchRequest search) { var query = _context.Set <Database.Narudzbe>().Include(c => c.Clan).AsQueryable(); if (search?.Datum.HasValue == true) { DateTime date = new DateTime(); date = search.Datum.Value; query = query.Where(x => x.Datum.Date.CompareTo(date.Date) == 0); } if (search?.Procesirana.HasValue == true) { query = query.Where(x => x.Procesirana == search.Procesirana); } if (search?.ClanId.HasValue == true) { query = query.Where(x => x.ClanId == search.ClanId); } if (search?.NarudzbaId.HasValue == true) { query = query.Where(x => x.NarudzbaId == search.NarudzbaId); } query = query.OrderBy(x => x.Datum); var list = query.ToList(); return(_mapper.Map <List <OnlineGym_Model.Narudzbe> >(list)); }
public List <OnlineGym_Model.Proizvod> Get(OnlineGym_Model.Proizvod proizvod) { if (proizvod.ProizvodId != 0) { UcitajProizvode(proizvod.ProizvodId); List <Database.RecenzijeProizvoda> ocjenePosmatranogProizvoda = _context.RecenzijeProizvoda.Where(p => p.ProizvodId == proizvod.ProizvodId).OrderBy(p => p.ClanId).ToList(); List <Database.RecenzijeProizvoda> zajednickeOcjene1 = new List <Database.RecenzijeProizvoda>(); List <Database.RecenzijeProizvoda> zajednickeOcjene2 = new List <Database.RecenzijeProizvoda>(); List <OnlineGym_Model.Proizvod> preporuceniProizvodi = new List <OnlineGym_Model.Proizvod>(); foreach (var p in proizvodi) { foreach (Database.RecenzijeProizvoda o in ocjenePosmatranogProizvoda) { if (p.Value.Where(x => x.ClanId == o.ClanId).Count() > 0) { zajednickeOcjene1.Add(o); zajednickeOcjene2.Add(p.Value.Where(x => x.ClanId == o.ClanId).First()); } } double slicnost = GetSlicnost(zajednickeOcjene1, zajednickeOcjene2); if (slicnost > 0.5) { var entityTemp = _context.Proizvod.Find(p.Key); OnlineGym_Model.Proizvod ProizvodTemp = _mapper.Map <OnlineGym_Model.Proizvod>(entityTemp); preporuceniProizvodi.Add(ProizvodTemp); } zajednickeOcjene1.Clear(); zajednickeOcjene2.Clear(); } return(preporuceniProizvodi); } else { List <OnlineGym_Model.Proizvod> preporuceniProizvodii = new List <OnlineGym_Model.Proizvod>(); var query = _context.Set <Database.Proizvod>().AsQueryable(); query = query.Where(x => x.ProizvodId != proizvod.ProizvodId && x.ProsjecnaOcjena > 4); var list = query.ToList(); foreach (Database.Proizvod item in list) { OnlineGym_Model.Proizvod temp = _mapper.Map <OnlineGym_Model.Proizvod>(item); preporuceniProizvodii.Add(temp); } return(preporuceniProizvodii); } }
public List <OnlineGym_Model.Teretana> Get(int gradId) { if (gradId != 0) { var query = _context.Set <Database.Teretana>().AsQueryable(); query = query.Where(x => x.GradId == gradId); query = query.OrderBy(x => x.Naziv); var list = query.ToList(); return(_mapper.Map <List <OnlineGym_Model.Teretana> >(list)); } else { return(null); } }
public List <OnlineGym_Model.Clan> Get(ClanSearchRequest request) { var query = _context.Set <Database.Clan>().Include(c => c.Grad).AsQueryable(); if (!string.IsNullOrWhiteSpace(request?.Ime)) { query = query.Where(x => x.Ime.StartsWith(request.Ime) || x.Prezime.StartsWith(request.Ime)); } if (!string.IsNullOrWhiteSpace(request?.Prezime)) { query = query.Where(x => x.Prezime.StartsWith(request.Prezime)); } if (!string.IsNullOrWhiteSpace(request?.Username)) { query = query.Where(x => (String.Equals(x.KorisnickoIme, request.Username))); } query = query.OrderBy(x => x.KorisnickoIme); var list = query.ToList(); return(_mapper.Map <List <OnlineGym_Model.Clan> >(list)); }
public List <OnlineGym_Model.NarudzbeStavke> Get(NarudzbaStavkaSearchRequest search) { var query = _context.Set <Database.NarudzbeStavke>().Include(x => x.Proizvod).Include(n => n.Narudzba).AsQueryable(); if (search?.NarudzbeStavkeId.HasValue == true) { query = query.Where(x => x.NarudzbeStavkeId == search.NarudzbeStavkeId); } if (search?.KategorijaId.HasValue == true) { query = query.Where(x => x.Proizvod.KategorijaProizvodaId == search.KategorijaId); } if (search?.NarudzbaId.HasValue == true) { query = query.Where(x => x.NarudzbaId == search.NarudzbaId); } query = query.OrderBy(x => x.NarudzbeStavkeId); var list = query.ToList(); return(_mapper.Map <List <OnlineGym_Model.NarudzbeStavke> >(list)); }
public OnlineGym_Model.Korisnik Update(int id, KorisniciInsertRequest request) { var query = _context.Set <Database.Korisnik>().Include(c => c.KorisniciUloge).AsQueryable(); var entity = query.Where(x => x.KorisnikId == id).FirstOrDefault(); var entityRequest = _mapper.Map <Database.Korisnik>(request); if (entity != null) { if (request.StariPassword != null) { var newHash = GenerateHash(entity.LozinkaSalt, request.StariPassword); if (newHash != entity.LozinkaHash) { return(null); //throw new Exception("Unesite ispravnu staru lozinku!"); } else { _context.Korisnik.Attach(entity); _context.Korisnik.Update(entity); _context.SaveChanges(); if (!string.IsNullOrWhiteSpace(request.Password)) { if (request.Password != request.PasswordPotvrda) { throw new Exception("Passwordi se ne slažu"); } entity.LozinkaSalt = GenerateSalt(); entity.LozinkaHash = GenerateHash(entity.LozinkaSalt, request.Password); } _mapper.Map(request, entity); _context.SaveChanges(); return(_mapper.Map <OnlineGym_Model.Korisnik>(entity)); } } else { _context.Korisnik.Attach(entity); _context.Korisnik.Update(entity); foreach (var postojecaUloga in entity.KorisniciUloge) { _context.KorisniciUloge.Remove(postojecaUloga); } _context.SaveChanges(); foreach (var novaUloga in request.Uloge) { Database.KorisniciUloge korisniciUloge = new Database.KorisniciUloge(); korisniciUloge.KorisnikId = entity.KorisnikId; korisniciUloge.UlogaId = novaUloga; _context.KorisniciUloge.Add(korisniciUloge); } _context.SaveChanges(); _context.SaveChanges(); if (!string.IsNullOrWhiteSpace(request.Password)) { if (request.Password != request.PasswordPotvrda) { throw new Exception("Passwordi se ne slažu"); } entity.LozinkaSalt = GenerateSalt(); entity.LozinkaHash = GenerateHash(entity.LozinkaSalt, request.Password); } _mapper.Map(request, entity); _context.SaveChanges(); return(_mapper.Map <OnlineGym_Model.Korisnik>(entity)); } } return(null); }
public virtual List <TModel> Get(TSearch search) { var list = _context.Set <TDatabase>().ToList(); return(_mapper.Map <List <TModel> >(list)); }