public EmailMassageModel GetMassageModelByReaderId(int readerId) { EmailMassageModel emailMassageModel = new EmailMassageModel(); ReaderHistoryMapper historyMapper = new ReaderHistoryMapper(); List <ReaderHistoryBusinessModel> readerHistoryBusiness = new List <ReaderHistoryBusinessModel>(); List <ReaderHistory> readerHistory = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId && r.FinishDate < DateTime.Now && r.ReturnDate == null) .Select(r => r).ToList(); for (int i = 0; i < readerHistory.Count; i++) { readerHistoryBusiness.Add(historyMapper.Map(readerHistory[i])); } string books = null; foreach (var book in readerHistoryBusiness) { books += book.InventoryBusiness.Item.Name + ", "; } emailMassageModel.FirsName = readerHistoryBusiness.First().ReaderBusiness.FirstName; emailMassageModel.LastName = readerHistoryBusiness.First().ReaderBusiness.LastName; emailMassageModel.Email = readerHistoryBusiness.First().ReaderBusiness.EMail; emailMassageModel.Subject = "Owing Book"; emailMassageModel.Message = "Dear student: " + emailMassageModel.FirsName + " " + emailMassageModel.LastName + ": " + "you owe the books: " + books + "Please back them to the library"; return(emailMassageModel); }
public void UpdateReaderHistory(ReaderHistoryBusinessModel readerHistoryBusiness) { ReaderHistoryMapper mapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = mapper.Map(readerHistoryBusiness); this.uow.ReadersHistories.Update(readerHistory); Inventory inventory = this.uow.Inventories.GetById(readerHistoryBusiness.InventoryBusiness.InventoryId); if (inventory.IsAvailable == false) { if (readerHistoryBusiness.ReturnDate != null) { inventory.IsAvailable = true; } else { inventory.IsAvailable = false; } } else { throw new Exception("This inventory already exist in the Library"); } uow.Commit(); }
public List <ReaderHistoryBusinessModel> GetReaderHistoryByInventoryNumber(string searchString, int?readerId) { var readerHisroryModel = new List <ReaderHistoryBusinessModel>(); List <ReaderHistory> readerHistories; using (LibraryUow uow = new LibraryUow()) { var readerHistoryMapper = new ReaderHistoryMapper(); if (readerId != null) { readerHistories = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId && r.ReturnDate == null) .Select(r => r).ToList(); } else { readerHistories = this.uow.ReadersHistories.GetAll().Where(r => r.ReturnDate == null).Select(r => r).ToList(); } foreach (var readerHistory in readerHistories) { if (readerHistory.Inventory.Number == searchString) { readerHisroryModel.Add(readerHistoryMapper.Map(readerHistory)); } } } return(readerHisroryModel); }
public ReaderHistoryMapperTest() { this.readerHistoryMapper = new ReaderHistoryMapper(); this.readerEntityToMap = new Reader { FirstName = "Bob", LastName = "Hopkins" }; this.readerModelToMap = new ReaderBusinessModel { FirstName = "Bob", LastName = "Hopkins" }; this.inventoryEntityToMap = new Inventory { Number = "0000000001-001" }; this.inventoryModelToMap = new InventoryBusinessModel { Number = "0000000001-001" }; this.readerHistoryEntityToMap = new ReaderHistory { ReaderHistoryId = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), Reader = this.readerEntityToMap, Inventory = this.inventoryEntityToMap }; this.readerHistoryEntityToCompareWith = new ReaderHistory { ReaderHistoryId = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), Reader = this.readerEntityToMap, Inventory = this.inventoryEntityToMap }; this.ReaderHistoryModelToMap = new ReaderHistoryBusinessModel { Id = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), ReaderBusiness = this.readerModelToMap, InventoryBusiness = this.inventoryModelToMap }; this.ReaderHistoryModelToCompareWith = new ReaderHistoryBusinessModel { Id = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), ReaderBusiness = this.readerModelToMap, InventoryBusiness = this.inventoryModelToMap }; }
public ReaderHistoryBusinessModel GetReaderHistoryById(int readerHistoryId) { ReaderHistoryMapper mapper = new ReaderHistoryMapper(); ReaderHistoryBusinessModel readerHistoryBusiness = new ReaderHistoryBusinessModel(); readerHistoryBusiness = mapper.Map(this.uow.ReadersHistories.GetById(readerHistoryId)); return(readerHistoryBusiness); }
public ReaderHistoryMapperTest() { this.readerHistoryMapper = new ReaderHistoryMapper(); this.readerEntityToMap = new Reader { FirstName = "Bob", LastName = "Hopkins" }; this.readerModelToMap = new ReaderBusinessModel { FirstName = "Bob", LastName = "Hopkins" }; this.inventoryEntityToMap = new Inventory { Number = "0000000001-001" }; this.inventoryModelToMap = new InventoryBusinessModel { Number = "0000000001-001" }; this.readerHistoryEntityToMap = new ReaderHistory { ReaderHistoryId = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), Reader = this.readerEntityToMap, Inventory = this.inventoryEntityToMap }; this.readerHistoryEntityToCompareWith = new ReaderHistory { ReaderHistoryId = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), Reader = this.readerEntityToMap, Inventory = this.inventoryEntityToMap }; this.ReaderHistoryModelToMap = new ReaderHistoryBusinessModel { Id = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), ReaderBusiness = this.readerModelToMap, InventoryBusiness = this.inventoryModelToMap }; this.ReaderHistoryModelToCompareWith = new ReaderHistoryBusinessModel { Id = 1, StartDate = Convert.ToDateTime("2013.12.12"), ReturnDate = Convert.ToDateTime("2013.12.20"), FinishDate = Convert.ToDateTime("2013.12.28"), ReaderBusiness = this.readerModelToMap, InventoryBusiness = this.inventoryModelToMap }; }
public void AddNewReaderHistory(ReaderHistoryBusinessModel readerHistoryBusiness, int readerId) { ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = readerHistoryMapper.Map(readerHistoryBusiness); var reader = uow.Readers.GetById(readerId); Inventory inventory = this.uow.Inventories.GetAll().Where(inv => inv.Number == readerHistory.Inventory.Number).Select(inv => inv).Single(); uow.ReadersHistories.Add(new ReaderHistory { StartDate = readerHistory.StartDate, FinishDate = readerHistory.FinishDate, Reader = reader, Inventory = this.uow.Inventories.GetById(inventory.InventoryId) }); uow.Commit(); }
public void GiveBookToStudent(ReaderHistoryBusinessModel readerHistoryBusinessModel) { ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = readerHistoryMapper.Map(readerHistoryBusinessModel); Inventory inventory = this.uow.Inventories.GetAll().Where(inv => inv.Number == readerHistory.Inventory.Number).Select(inv => inv).Single(); if (inventory.IsAvailable == true) { inventory.IsAvailable = false; } else { throw new Exception(); } this.uow.Inventories.Update(inventory); uow.Commit(); }
public IEnumerable<ReaderHistoryBusinessModel> GetReaderHistoriesByReaderId(int? readerId) { List<ReaderHistoryBusinessModel> readerHistoryBusiness = new List<ReaderHistoryBusinessModel>(); ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); List<ReaderHistory> readerHistory = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId) .Select(r => r).ToList(); for (int i = 0; i < readerHistory.Count; i++) { readerHistoryBusiness.Add(readerHistoryMapper.Map(readerHistory[i])); } var readerHistoryBusinessSorted = readerHistoryBusiness.OrderByDescending(x => x.StartDate); /*if (readerHistoryBusinessSorted.Count() == 0) { readerHistoryBusinessSorted.First().ReaderBusiness.ReaderId = readerId; }*/ return readerHistoryBusinessSorted; }
public IEnumerable <ReaderHistoryBusinessModel> GetReaderHistoriesByReaderId(int?readerId) { List <ReaderHistoryBusinessModel> readerHistoryBusiness = new List <ReaderHistoryBusinessModel>(); ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); List <ReaderHistory> readerHistory = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId) .Select(r => r).ToList(); for (int i = 0; i < readerHistory.Count; i++) { readerHistoryBusiness.Add(readerHistoryMapper.Map(readerHistory[i])); } var readerHistoryBusinessSorted = readerHistoryBusiness.OrderByDescending(x => x.StartDate); /*if (readerHistoryBusinessSorted.Count() == 0) * { * readerHistoryBusinessSorted.First().ReaderBusiness.ReaderId = readerId; * }*/ return(readerHistoryBusinessSorted); }
public void GiveBookToStudent(ReaderHistoryBusinessModel readerHistoryBusinessModel) { ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = readerHistoryMapper.Map(readerHistoryBusinessModel); Inventory inventory = this.uow.Inventories.GetAll().Where(inv => inv.Number == readerHistory.Inventory.Number).Select(inv => inv).Single(); if (inventory.IsAvailable == true) { inventory.IsAvailable = false; } else { throw new Exception(); } this.uow.Inventories.Update(inventory); uow.Commit(); }
public EmailMassageModel GetMassageModelByReaderId(int readerId) { EmailMassageModel emailMassageModel = new EmailMassageModel(); ReaderHistoryMapper historyMapper = new ReaderHistoryMapper(); List<ReaderHistoryBusinessModel> readerHistoryBusiness = new List<ReaderHistoryBusinessModel>(); List<ReaderHistory> readerHistory = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId && r.FinishDate < DateTime.Now && r.ReturnDate == null) .Select(r => r).ToList(); for (int i = 0; i < readerHistory.Count; i++) { readerHistoryBusiness.Add(historyMapper.Map(readerHistory[i])); } string books = null; foreach (var book in readerHistoryBusiness) { books += book.InventoryBusiness.Item.Name + ", "; } emailMassageModel.FirsName = readerHistoryBusiness.First().ReaderBusiness.FirstName; emailMassageModel.LastName = readerHistoryBusiness.First().ReaderBusiness.LastName; emailMassageModel.Email = readerHistoryBusiness.First().ReaderBusiness.EMail; emailMassageModel.Subject = "Owing Book"; emailMassageModel.Message = "Dear student: " + emailMassageModel.FirsName + " " + emailMassageModel.LastName + ": " + "you owe the books: " + books + "Please back them to the library"; return emailMassageModel; }
public List<ReaderHistoryBusinessModel> GetReaderHistoryByInventoryNumber(string searchString, int? readerId) { var readerHisroryModel = new List<ReaderHistoryBusinessModel>(); List<ReaderHistory> readerHistories; using (LibraryUow uow = new LibraryUow()) { var readerHistoryMapper = new ReaderHistoryMapper(); if (readerId != null) { readerHistories = this.uow.ReadersHistories.GetAll().Where(r => r.Reader.ReaderId == readerId && r.ReturnDate == null) .Select(r => r).ToList(); } else { readerHistories = this.uow.ReadersHistories.GetAll().Where(r => r.ReturnDate == null).Select(r => r).ToList(); } foreach (var readerHistory in readerHistories) { if (readerHistory.Inventory.Number == searchString) { readerHisroryModel.Add(readerHistoryMapper.Map(readerHistory)); } } } return readerHisroryModel; }
public void UpdateReaderHistory(ReaderHistoryBusinessModel readerHistoryBusiness) { ReaderHistoryMapper mapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = mapper.Map(readerHistoryBusiness); this.uow.ReadersHistories.Update(readerHistory); Inventory inventory = this.uow.Inventories.GetById(readerHistoryBusiness.InventoryBusiness.InventoryId); if (inventory.IsAvailable == false) { if (readerHistoryBusiness.ReturnDate != null) { inventory.IsAvailable = true; } else { inventory.IsAvailable = false; } } else { throw new Exception("This inventory already exist in the Library"); } uow.Commit(); }
public ReaderHistoryBusinessModel GetReaderHistoryById(int readerHistoryId) { ReaderHistoryMapper mapper = new ReaderHistoryMapper(); ReaderHistoryBusinessModel readerHistoryBusiness = new ReaderHistoryBusinessModel(); readerHistoryBusiness = mapper.Map(this.uow.ReadersHistories.GetById(readerHistoryId)); return readerHistoryBusiness; }
public void AddNewReaderHistory(ReaderHistoryBusinessModel readerHistoryBusiness, int readerId) { ReaderHistoryMapper readerHistoryMapper = new ReaderHistoryMapper(); ReaderHistory readerHistory = new ReaderHistory(); readerHistory = readerHistoryMapper.Map(readerHistoryBusiness); var reader = uow.Readers.GetById(readerId); Inventory inventory = this.uow.Inventories.GetAll().Where(inv => inv.Number == readerHistory.Inventory.Number).Select(inv => inv).Single(); uow.ReadersHistories.Add(new ReaderHistory { StartDate = readerHistory.StartDate, FinishDate = readerHistory.FinishDate, Reader = reader, Inventory = this.uow.Inventories.GetById(inventory.InventoryId) }); uow.Commit(); }