public bool Update(RoleBindingModel model) { try { using (var libraryDb = new LibraryManagementEntities()) { // Check first get item var role = libraryDb.Roles.FirstOrDefault(s => s.Id == model.Id); if (role == null) { throw new ArgumentNullException("No exist"); } role.Name = model.Name; libraryDb.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool Update(SpecialCategoryBindingModel model) { try { using (var libraryDb = new LibraryManagementEntities()) { // Check first get item var specialCategory = libraryDb.SpecialCategories.FirstOrDefault(s => s.Id == model.Id); if (specialCategory == null) { throw new ArgumentNullException("No exist"); } specialCategory.Name = model.Name; specialCategory.Description = model.Description; libraryDb.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public List <ReportModel> Report() { List <ReportModel> listRs = new List <ReportModel>(); try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Categories select a; foreach (var item in qry.ToList()) { // Select cout sach where category var s = from a in libraryDb.Books where a.CategoryId == item.Id select a; listRs.Add(new ReportModel() { Category = item.Name, BookCount = s.Count().ToString(), PageCount = s.Sum(m => m.PageCount).ToString() }); } } return(listRs); } catch (Exception) { return(listRs); } }
public bool UpdateStatusForBorrow(string bookId) { try { using (var libraryDb = new LibraryManagementEntities()) { // Check first get item var book = libraryDb.Books.FirstOrDefault(s => s.Id.Equals(bookId)); if (book == null) { throw new ArgumentNullException("No exist"); } book.Status = SystemConstants.Borrowed; libraryDb.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public static void ChangeLanguage(string language) { LibraryManagementEntities db = new LibraryManagementEntities(); switch (language) { case "Fr": IDLanguage = 1; break; case "En": IDLanguage = 2; break; default: IDLanguage = 1; break; } Settings config = db.Settings.Single(); config.IDLanguage = IDLanguage; db.Entry(config).State = EntityState.Modified; db.SaveChanges(); }
public BookManagement() { this.entities = new LibraryManagementEntities(); }
//public ListResult<CategoryBindingModel> GetList(int? specializedId = null, string name = "", int? pageNumber = 0, int? pageSize = 0) //{ // try // { // using (var libraryDb = new LibraryManagementEntities()) // { // var qry = from a in libraryDb.Categories // select a; // if (!string.IsNullOrWhiteSpace(name)) // qry = from a in qry // where a.Name.Contains(name) // select a; // if (specializedId != null && specializedId >= 1) // qry = from a in qry // where a.SpecializedId == specializedId // select a; // var listRs = ListResult<Category>.GetDataPage(qry.OrderBy(x=>x.Name), pageNumber, pageSize); // if (listRs == null) throw new ArgumentNullException(); // if (listRs.ListOfObjects == null) return new ListResult<CategoryBindingModel>(); // var listResult = new ListResult<CategoryBindingModel>(); // listResult.ListOfObjects = new List<CategoryBindingModel>(); // listResult.TotalRecord = listRs.TotalRecord; // foreach (var item in listRs.ListOfObjects) // { // var category = _entityMapper.Map<Category, CategoryBindingModel>(item); // listResult.ListOfObjects.Add(category); // } // return listResult; // } // } // catch (Exception) // { // throw; // } //} public ListResult <CategoryViewModel> GetList(int?specializedId = null, string name = "", int?pageNumber = 0, int?pageSize = 0) { try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Categories join b in libraryDb.Specializeds on a.SpecializedId equals b.Id select new { Id = a.Id, Name = a.Name, SpecializedId = a.SpecializedId, Specialized = b.Name }; if (!string.IsNullOrWhiteSpace(name)) { qry = from a in qry where a.Name.Contains(name) select a; } if (specializedId != null && specializedId >= 1) { qry = from a in qry where a.SpecializedId == specializedId select a; } List <CategoryViewModel> LR = new List <CategoryViewModel>(); foreach (var item in qry.ToList()) { LR.Add(new CategoryViewModel() { Id = item.Id, Name = item.Name, SpecializedId = item.SpecializedId, Specialized = item.Specialized }); } var listRs = ListResult <CategoryViewModel> .GetDataPage(LR.OrderBy(x => x.Name), pageNumber, pageSize); if (listRs == null) { throw new ArgumentNullException(); } if (listRs.ListOfObjects == null) { return(new ListResult <CategoryViewModel>()); } return(listRs); } } catch (Exception) { throw; } }
public UserAuthentication() { this.entities = new LibraryManagementEntities(); }
public CategoryManagement() { this.entities = new LibraryManagementEntities(); }
public UserRegister() { this.entities = new LibraryManagementEntities(); }
public ReservationManagement() { this.entities = new LibraryManagementEntities(); }
// When you delete specialized you have to delete (category, specialcategory, book, borrower) public bool Delete(int id) { try { using (var libraryDb = new LibraryManagementEntities()) { // Check first get item var specialzed = libraryDb.Specializeds.FirstOrDefault(s => s.Id == id); if (specialzed == null) { throw new ArgumentNullException("No exist"); } //// Check if have child //// 1. Get category //var listCategory = (from a in libraryDb.Categories // where a.Id == model.Id // select a).ToList(); //// 2. Get special category //var listSpecialCategory = (from a in libraryDb.SpecialCategories // where a.Id == model.Id // select a).ToList(); //// 3. Get book by category //List<Book> lstBook = new List<Book>(); //foreach (var item in listCategory) //{ // var book = (from a in libraryDb.Books // where a.CategoryId == item.Id // select a).FirstOrDefault(); // if (book != null) // lstBook.Add(book); //} //foreach (var item in listSpecialCategory) //{ // var book = (from a in libraryDb.Books // where a.SpecialCategoryId == item.Id // select a).FirstOrDefault(); // if (book != null) // lstBook.Add(book); //} //// 4. Get borrower //List<Borrower> lstBorrower = new List<Borrower>(); //foreach (var item in lstBook) //{ // var borrower = (from a in libraryDb.Borrowers // where a.BookId == item.Id // select a).FirstOrDefault(); // if (borrower != null) // lstBorrower.Add(borrower); //} //// Delete Borrowers => Delete books => Delete Category => Delete SpecialCategory => Delete Specialized //libraryDb.Borrowers.RemoveRange(lstBorrower); //libraryDb.Books.RemoveRange(lstBook); //libraryDb.Categories.RemoveRange(listCategory); //libraryDb.SpecialCategories.RemoveRange(listSpecialCategory); libraryDb.Specializeds.Remove(specialzed); libraryDb.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
//public ListResult<UserBindingModel> GetList(string name = "", int? positionId = null, int? unitId = null, int? roleId = null, int? pageNumber = 0, int? pageSize = 0) //{ // try // { // using (var libraryDb = new LibraryManagementEntities()) // { // var qry = from a in libraryDb.Users // select a; // if (!string.IsNullOrWhiteSpace(name)) // qry = from a in qry // where a.Name.Contains(name) // select a; // if (positionId != null) // qry = from a in qry // where a.PositionId == positionId // select a; // if (unitId != null) // qry = from a in qry // where a.UnitId == unitId // select a; // if (roleId != null) // qry = from a in qry // where a.RoleId == roleId // select a; // var listRs = ListResult<User>.GetDataPage(qry.OrderBy(x=>x.Name), pageNumber, pageSize); // if (listRs == null) throw new ArgumentNullException(); // if (listRs.ListOfObjects == null) return new ListResult<UserBindingModel>(); // var listResult = new ListResult<UserBindingModel>(); // listResult.ListOfObjects = new List<UserBindingModel>(); // listResult.TotalRecord = listRs.TotalRecord; // foreach (var item in listRs.ListOfObjects) // { // var user = _entityMapper.Map<User, UserBindingModel>(item); // listResult.ListOfObjects.Add(user); // } // return listResult; // } // } // catch (Exception) // { // throw; // } //} public UserBindingViewModel getUser(string account, string password) { try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Users join b in libraryDb.Positions on a.PositionId equals b.Id join c in libraryDb.Units on a.UnitId equals c.Id join d in libraryDb.Roles on a.RoleId equals d.Id where a.Account == account && a.Password == password select new { Id = a.Id, Account = a.Account, Password = a.Password, Name = a.Name, Gender = a.Gender, DayOfBirth = a.DayOfBirth, Address = a.Address, PhoneNumber = a.PhoneNumber, PositionId = a.PositionId, Position = b.Name, UnitId = a.UnitId, Unit = c.Name, RoleId = a.RoleId, Role = d.Name, Email = a.Email }; List <UserBindingViewModel> LR = new List <UserBindingViewModel>(); foreach (var item in qry.ToList()) { LR.Add(new UserBindingViewModel() { Id = item.Id, Account = item.Account, Password = item.Password, Name = item.Name, Gender = item.Gender, DayOfBirth = item.DayOfBirth, Address = item.Address, PhoneNumber = item.PhoneNumber, PositionId = item.PositionId, Position = item.Position, UnitId = item.UnitId, Unit = item.Unit, RoleId = item.RoleId, Role = item.Role, Email = item.Email }); } return(LR.FirstOrDefault()); } } catch (Exception ex) { return(null); } }
public BaseRepository() { db = new LibraryManagementEntities(); table = db.Set <T>(); }
public BaseManager() { this._dbLibraryManagement = new LibraryManagementEntities(); }
public BaseManager(LibraryManagementEntities dbLibraryManagement) { this._dbLibraryManagement = dbLibraryManagement; }
public ListResult <BookBindingViewModel> GetList(string searching, int?categoryId, int?specialCategoryId, int?bookShelfId, int?phblisherId, int?authorId, int?pageNumber = 0, int?pageSize = 0) { try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Books join b in libraryDb.Categories on a.CategoryId equals b.Id join c in libraryDb.SpecialCategories on a.SpecialCategoryId equals c.Id join d in libraryDb.BookShelves on a.BookShelfId equals d.Id join e in libraryDb.Publishers on a.PublisherId equals e.Id join f in libraryDb.Authors on a.AuthorId equals f.Id select new { Id = a.Id, Name = a.Name, Language = a.Language, ReleaseYear = a.ReleaseYear, PageCount = a.PageCount, Price = a.Price, Note = a.Note, Status = a.Status, AuthorId = a.AuthorId, Author = f.Name, PublisherId = a.PublisherId, Publisher = e.Name, CategoryId = a.CategoryId, Category = b.Name, SpecialCategoryId = a.SpecialCategoryId, SpecialCategory = c.Name, BookShelfId = a.BookShelfId, BookShelf = d.Name }; if (!string.IsNullOrWhiteSpace(searching)) { qry = from a in qry where a.Name.Contains(searching) || a.Id.Contains(searching) || a.Status.Contains(searching) select a; } if (categoryId != null && categoryId >= 1) { qry = from a in qry where a.CategoryId == categoryId select a; } if (specialCategoryId != null && specialCategoryId >= 1) { qry = from a in qry where a.SpecialCategoryId == specialCategoryId select a; } if (bookShelfId != null && bookShelfId >= 1) { qry = from a in qry where a.BookShelfId == bookShelfId select a; } if (phblisherId != null && phblisherId >= 1) { qry = from a in qry where a.PublisherId == phblisherId select a; } if (authorId != null && authorId >= 1) { qry = from a in qry where a.AuthorId == authorId select a; } List <BookBindingViewModel> LR = new List <BookBindingViewModel>(); foreach (var item in qry.ToList()) { LR.Add(new BookBindingViewModel() { Id = item.Id, Name = item.Name, Author = item.Author, AuthorId = item.AuthorId, BookShelf = item.BookShelf, BookShelfId = item.BookShelfId, Category = item.Category, CategoryId = item.CategoryId, Language = item.Language, Note = item.Note, PageCount = item.PageCount, Price = item.Price, Publisher = item.Publisher, PublisherId = item.PublisherId, ReleaseYear = item.ReleaseYear, SpecialCategory = item.SpecialCategory, SpecialCategoryId = item.SpecialCategoryId, Status = item.Status }); } var listRs = ListResult <BookBindingViewModel> .GetDataPage(LR.OrderBy(x => x.Name), pageNumber, pageSize); if (listRs == null) { throw new ArgumentNullException(); } if (listRs.ListOfObjects == null) { return(new ListResult <BookBindingViewModel>()); } return(listRs); } } catch (Exception) { throw; } }
public UserManagement() { this.entities = new LibraryManagementEntities(); }
public LanguageManagement() { this.entities = new LibraryManagementEntities(); }
public ListResult <ReaderBindingViewModel> GetList(string name = "", string gender = "", string phoneNumber = "", int?positionId = null, int?unitId = null, int?pageNumber = 0, int?pageSize = 0) { try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Readers join b in libraryDb.Positions on a.PositionId equals b.Id join c in libraryDb.Units on a.UnitId equals c.Id select new { Id = a.Id, Name = a.Name, Gender = a.Gender, DayOfBirth = a.DayOfBirth, Address = a.Address, PhoneNumber = a.PhoneNumber, Email = a.Email, Position = b.Name, Unit = c.Name, Note = a.Note, PositionId = a.PositionId, UnitId = a.UnitId }; if (!string.IsNullOrWhiteSpace(name)) { qry = from a in qry where a.Name.Contains(name) select a; } if (!string.IsNullOrWhiteSpace(gender)) { qry = from a in qry where a.Gender.Contains(gender) select a; } if (!string.IsNullOrWhiteSpace(phoneNumber)) { qry = from a in qry where a.PhoneNumber.Contains(phoneNumber) select a; } if (positionId != null && positionId >= 1) { qry = from a in qry where a.PositionId == positionId select a; } if (unitId != null && unitId >= 1) { qry = from a in qry where a.UnitId == unitId select a; } List <ReaderBindingViewModel> LR = new List <ReaderBindingViewModel>(); foreach (var item in qry.ToList()) { LR.Add(new ReaderBindingViewModel() { Id = item.Id, Name = item.Name, Address = item.Address, DayOfBirth = item.DayOfBirth, Email = item.Email, Gender = item.Gender, Note = item.Note, PhoneNumber = item.PhoneNumber, Position = item.Position, PositionId = item.PositionId, Unit = item.Unit, UnitId = item.UnitId }); } var listRs = ListResult <ReaderBindingViewModel> .GetDataPage(LR.OrderBy(x => x.Name), pageNumber, pageSize); if (listRs == null) { throw new ArgumentNullException(); } if (listRs.ListOfObjects == null) { return(new ListResult <ReaderBindingViewModel>()); } return(listRs); } } catch (Exception) { throw; } }
//public ListResult<BorrowerBindingModel> GetList(int? readerId, string bookId, DateTime? borrowDate, DateTime? payDate, string note, // int? pageNumber = 0, int? pageSize = 0) //{ // try // { // using (var libraryDb = new LibraryManagementEntities()) // { // var qry = from a in libraryDb.Borrowers // select a; // if (!string.IsNullOrWhiteSpace(note)) // qry = from a in qry // where a.Note.Contains(note) // select a; // if (readerId != null && readerId >= 1) // qry = from a in qry // where a.ReaderId == readerId // select a; // if (!string.IsNullOrWhiteSpace(bookId)) // qry = from a in qry // where a.BookId.Contains(bookId) // select a; // if (borrowDate != null) // qry = from a in qry // where a.BorrowDate >= borrowDate // select a; // if (payDate != null) // qry = from a in qry // where a.PayDate <= payDate // select a; // var listRs = ListResult<Borrower>.GetDataPage(qry.OrderByDescending(x=>x.PayDate), pageNumber, pageSize); // if (listRs == null) throw new ArgumentNullException(); // if (listRs.ListOfObjects == null) return new ListResult<BorrowerBindingModel>(); // var listResult = new ListResult<BorrowerBindingModel>(); // listResult.ListOfObjects = new List<BorrowerBindingModel>(); // listResult.TotalRecord = listRs.TotalRecord; // foreach (var item in listRs.ListOfObjects) // { // var borrower = _entityMapper.Map<Borrower, BorrowerBindingModel>(item); // listResult.ListOfObjects.Add(borrower); // } // return listResult; // } // } // catch (Exception) // { // throw; // } //} public ListResult <BorrowerBindingViewModel> GetList(string searching = "", int?positionId = null, int?unitId = null, int?pageNumber = 0, int?pageSize = 0) { try { using (var libraryDb = new LibraryManagementEntities()) { var qry = from a in libraryDb.Borrowers join b in libraryDb.Books on a.BookId equals b.Id join c in libraryDb.Readers on a.ReaderId equals c.Id join d in libraryDb.Positions on c.PositionId equals d.Id join g in libraryDb.Units on c.UnitId equals g.Id where b.Status.Equals(SystemConstants.Borrowed) select new { ReaderId = c.Id, ReaderName = c.Name, BookId = b.Id, BookName = b.Name, BorrowDate = a.BorrowDate, Note = a.Note, CreatedBy = a.CreatedBy, Unit = g.Name, UnitId = g.Id, Position = d.Name, PositionId = d.Id }; if (!string.IsNullOrWhiteSpace(searching)) { qry = from a in qry where a.ReaderName.Contains(searching) || a.BookId.Contains(searching) || a.BookName.Contains(searching) || a.Note.Contains(searching) select a; } if (positionId != null && positionId >= 1) { qry = from a in qry where a.PositionId == positionId select a; } if (unitId != null && unitId >= 1) { qry = from a in qry where a.UnitId == unitId select a; } List <BorrowerBindingViewModel> LR = new List <BorrowerBindingViewModel>(); foreach (var item in qry.ToList()) { LR.Add(new BorrowerBindingViewModel() { BookId = item.BookId, BookName = item.BookName, ReaderId = item.ReaderId, ReaderName = item.ReaderName, BorrowDate = item.BorrowDate, PositionId = item.PositionId, Position = item.Position, UnitId = item.UnitId, Unit = item.Unit, Note = item.Note, CreatedBy = item.CreatedBy }); } var listRs = ListResult <BorrowerBindingViewModel> .GetDataPage(LR.OrderBy(x => x.ReaderName), pageNumber, pageSize); if (listRs == null) { throw new ArgumentNullException(); } if (listRs.ListOfObjects == null) { return(new ListResult <BorrowerBindingViewModel>()); } return(listRs); } } catch (Exception ex) { return(new ListResult <BorrowerBindingViewModel>()); } }