Esempio n. 1
0
        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));
        }
Esempio n. 3
0
        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));
        }
Esempio n. 7
0
        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));
        }