internal void Pay(Penny selectedPenny) { using (var db = new LibraryContext()) { selectedPenny.payed = "pay"; var origin = db.Penny.Find(selectedPenny.Id); db.Entry(origin).CurrentValues.SetValues(selectedPenny); db.SaveChanges(); } }
internal void ReturnBook(string addReaderNameForReturnBook, string addReaderSurNameForReturnBook, Book selectedBookForGive) { using (var db = new LibraryContext()) { var returnedbooks = db.Books.SingleOrDefault(x => x.Id == selectedBookForGive.Id);//.Count++; returnedbooks.Count++; db.SaveChanges(); foreach (var item in db.Carts) { if (item.Reader.Name == addReaderNameForReturnBook && item.Reader.Surname == addReaderSurNameForReturnBook && item.Book.Id == selectedBookForGive.Id && item.Status == "Reading") { item.Finish_reading = DateTime.Now; item.Status = "Finish"; var checkPenny = (item.Finish_reading - item.Start_reading).Value.Days; if (checkPenny < 0 || checkPenny >= -5) { var penny = new Penny() { Id = Guid.NewGuid(), Price = 10, pennyStat = db.PennyStat.ToList().Find(x => x.Count_Day_Min == 6) }; item.penny = penny; db.Penny.Add(penny); // db.SaveChanges(); } if (checkPenny < -11) { var penny = new Penny() { Id = Guid.NewGuid(), Price = 50, pennyStat = db.PennyStat.ToList().Find(x => x.Count_Day_Min == 6) }; db.Penny.Add(penny); // db.SaveChanges(); item.penny = db.Penny.ToList().Find(x => x.Id == penny.Id); } break; } } //var cart = db.Carts.SingleOrDefault(x => x.Reader.Name == addReaderNameForReturnBook && x.Reader.Surname == addReaderSurNameForReturnBook && x.Book.Id == selectedBookForGive.Id); //cart.Finish_reading = DateTime.Now; //cart.Status = "Finish"; db.SaveChanges(); } }
public void Initialize() { using (var db = new LibraryContext()) { var statfil1 = new StatFillial() { Id = Guid.NewGuid(), FillialStat = "Village" }; db.StatFillial.Add(statfil1); var statfil2 = new StatFillial() { Id = Guid.NewGuid(), FillialStat = "town" }; db.StatFillial.Add(statfil2); var statfill3 = new StatFillial() { Id = Guid.NewGuid(), FillialStat = "Magistery" }; db.StatFillial.Add(statfill3); var fill1 = new Fillial() { Id = Guid.NewGuid(), Number = 1, Name = "Young", Stat_Fillial = statfil1 }; db.Fillial.Add(fill1); var fill2 = new Fillial() { Id = Guid.NewGuid(), Number = 2, Name = "City", Stat_Fillial = statfil1 }; db.Fillial.Add(fill2); var fill3 = new Fillial() { Id = Guid.NewGuid(), Number = 3, Name = "Students", Stat_Fillial = statfil1 }; db.Fillial.Add(fill3); var adr = new Adress() { Id = Guid.NewGuid(), City = "Zhytomyr", Street = "Kyivs'ka", Fillal = fill1, House_number = "1" }; db.Adresses.Add(adr); var reader = new Reader() { Id = Guid.NewGuid(), Name = "Bogdan", Surname = "Madelyk", Adress = adr }; db.Readers.Add(reader); var category1 = new Category() { Id = Guid.NewGuid(), CategoryName = "Tales", Description = "Tales for kids" }; db.Categorys.Add(category1); var author = new Author() { Id = Guid.NewGuid(), Name = "Belyaev", Surname = "Ivan" }; db.Authors.Add(author); var book = new Book() { Id = Guid.NewGuid(), Author = author, Category = category1, Name = "Man-Amfibian", Count = 3 }; db.Books.Add(book); var pennystat1 = new PennyStat() { Id = Guid.NewGuid(), Status = "5 days", Count_Day_Min = 1, Count_Day_Max = 5, }; db.PennyStat.Add(pennystat1); var pennystat2 = new PennyStat() { Id = Guid.NewGuid(), Status = "20 days", Count_Day_Min = 6, Count_Day_Max = 20, }; db.PennyStat.Add(pennystat2); var pennystat3 = new PennyStat() { Id = Guid.NewGuid(), Status = "50 days", Count_Day_Min = 21, Count_Day_Max = 50, }; db.PennyStat.Add(pennystat3); var pennystat0 = new PennyStat() { Id = Guid.NewGuid(), Status = "Reading", Count_Day_Min = 0, }; db.PennyStat.Add(pennystat0); var penny0 = new Penny() { Id = Guid.NewGuid(), pennyStat = pennystat0, Price = 0 }; db.Penny.Add(penny0); var cart = new Cart() { Id = Guid.NewGuid(), Book = book, Reader = reader, Start_reading = DateTime.Now, penny = penny0, Status = "Reading" }; db.Carts.Add(cart); db.SaveChanges(); } }