Exemple #1
0
        public ActionResult CheckForLogin(Loginy login)
        {
            var context = new durbaezgomezEntities1();

            if (context.Loginy.Any(o => o.nr_karty == login.nr_karty && o.haslo == login.haslo))
            {
                var time = new WejsciaOnline()
                {
                    data     = DateTime.Now,
                    nr_karty = login.nr_karty
                };

                Uzytkownicy user = context.Uzytkownicy.Where(u => u.nr_karty == login.nr_karty).FirstOrDefault();

                context.WejsciaOnline.Add(time);
                context.SaveChanges();

                return(View("Logged", user));
            }
            else if (context.Pracownicy.Any(p => p.pracownik_id == login.nr_karty && p.nazwisko == login.haslo))
            {
                var worker = context.Pracownicy.Where(p => p.pracownik_id == login.nr_karty).First();
                var orders = context.Zamowienia.ToList();

                AdminViewModel model = new AdminViewModel(worker, orders);

                return(View("~/Views/Admin/AdminView.cshtml", model));
            }
            else
            {
                return(View("ErrorLogin"));
            }
        }
Exemple #2
0
        public ActionResult ListOfBooks(int card)
        {
            var context = new durbaezgomezEntities1();
            var books   = context.Ksiazki.ToList();
            var User    = context.Uzytkownicy.First(m => m.nr_karty == card);

            var viewModel = new RentBookViewModel(User, books);

            return(View(viewModel));
        }
Exemple #3
0
        public void RentBook(int card, int bookId)
        {
            var context = new durbaezgomezEntities1();

            var order = new Zamowienia()
            {
                data       = DateTime.Now,
                nr_karty   = card,
                ksiazka_id = bookId
            };

            var book = context.Ksiazki.First(b => b.ksiazka_id == bookId);

            book.stawka--;

            context.Zamowienia.Add(order);
            context.SaveChanges();
        }
Exemple #4
0
        public void Rent(string bookId, string cardId, string workerId)
        {
            var context   = new durbaezgomezEntities1();
            var from_when = DateTime.Now;
            var to_when   = from_when.AddMonths(1);


            var rent = new Wypozyczenia()
            {
                ksiazka_id   = Int32.Parse(bookId),
                nr_karty     = Int32.Parse(cardId),
                pracownik_id = Int32.Parse(workerId),
                od_kiedy     = from_when,
                do_kiedy     = to_when
            };

            var record = context.Zamowienia.Where(z => z.ksiazka_id == rent.ksiazka_id && z.nr_karty == rent.nr_karty).First();

            context.Zamowienia.Remove(record);

            context.Wypozyczenia.Add(rent);
            context.SaveChanges();
        }