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")); } }
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)); }
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(); }
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(); }