public static List <Students> GetStudentsList() { using (var db = new LibraryDBEntities()) { return(db.Students.ToList()); } }
// method to assigne books public HttpResponseMessage Post([FromBody] BooksAssigned assignedBooks) { try { using (LibraryDBEntities entities = new LibraryDBEntities()) { foreach (var book in assignedBooks.Books) { var entity = entities.AssignedBooks.ToList().Where(e => e.UserID == assignedBooks.UserId && e.BookID == book); //var bookQty = entities.AssignedBooks.ToList().Where(e => e.UserID == assignedBooks.UserId && e.BookID.Value == book); //if(bookQty.Count() < 3) if (entity.Count() == 0) { entities.AssignedBooks.Add(new AssignedBook { UserID = assignedBooks.UserId, BookID = book }); } } entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, "true"); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ViewResult Contact() { var context = new LibraryDBEntities(); var model = context.BookTables.ToList(); return(View(model)); }
public IEnumerable <AssignedBook> Get() { using (LibraryDBEntities entities = new LibraryDBEntities()) { return(entities.AssignedBooks.ToList()); } }
public static Fines GetFinesByID(int id) { using (var db = new LibraryDBEntities()) { return(db.Fines.Find(id)); } }
public static List <Fines> GetFinesList() { using (var db = new LibraryDBEntities()) { return(db.Fines.ToList()); } }
public static Students GetStudentByID(int id) { using (var db = new LibraryDBEntities()) { return(db.Students.Find(id)); } }
private void ShowInfo_Click(object sender, RoutedEventArgs e) { try { if (Books.SelectedItems.Count != 0) { dynamic selectedItem = Books.SelectedItems[0]; if (selectedItem != null) { int recordId = (int)selectedItem.Id; int bookId; using (var db = new LibraryDBEntities()) { var recordToShow = db.Wishlists.Find(recordId); bookId = (int)recordToShow.BookID; } BookInfo bookInfo = new BookInfo(bookId, userId); if (bookInfo.ShowDialog() == true) { MessageBox.Show("The book has been added to your wishlist"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static Programs GetById(int id) { using (var db = new LibraryDBEntities()) { return(db.Programs.Find(id)); } }
public static Designations GetById(int id) { using (var db = new LibraryDBEntities()) { return(db.Designations.Find(id)); } }
public static string GetByNameFromID(int id) { using (var db = new LibraryDBEntities()) { var department = db.Departments.Where(x => x.DepartmentID == id).First(); return(department.Name); } }
public static List <BorrowHistory> GetBorrowBooks() { using (LibraryDBEntities context = new LibraryDBEntities()) { var borrowHistories = context.BorrowHistories.Include(b => b.Book).Include(b => b.Student).ToList(); return(borrowHistories); } }
public static int GetByName(string name) { using (var db = new LibraryDBEntities()) { var bookCategory = db.BookCategories.Where(x => x.Name == name).First(); return(bookCategory.BookCategoryID); } }
public static void Update(UserPrivileges up) { using (var db = new LibraryDBEntities()) { db.Entry(up).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void Add(UserPrivileges up) { using (var db = new LibraryDBEntities()) { db.UserPrivileges.Add(up); db.SaveChanges(); } }
public static void Add(IssueBooks ib) { using (var db = new LibraryDBEntities()) { db.IssueBooks.Add(ib); db.SaveChanges(); } }
public static void Update(Departments d) { using (var db = new LibraryDBEntities()) { db.Entry(d).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static int GetByName(string name) { using (var db = new LibraryDBEntities()) { var department = db.Departments.Where(x => x.Name == name).First(); return(department.DepartmentID); } }
public static void Add(Departments d) { using (var db = new LibraryDBEntities()) { db.Departments.Add(d); db.SaveChanges(); } }
public static int GetByName(string name) { using (var db = new LibraryDBEntities()) { var session = db.Sessions.Where(x => x.Name == name).First(); return(session.SessionID); } }
public static void Add(ReturnBooks rb) { using (var db = new LibraryDBEntities()) { db.ReturnBooks.Add(rb); db.SaveChanges(); } }
public static void Add(Sessions s) { using (var db = new LibraryDBEntities()) { db.Sessions.Add(s); db.SaveChanges(); } }
public static void Update(IssueBooks ib) { using (var db = new LibraryDBEntities()) { db.Entry(ib).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void Add(Users u) { using (var db = new LibraryDBEntities()) { db.Users.Add(u); db.SaveChanges(); } }
public static UserPrivileges GetByStaffID(int staffID) { using (var db = new LibraryDBEntities()) { var userPrivileges = db.UserPrivileges.Where(x => x.StaffID == staffID).First(); return(userPrivileges); } }
public static int GetUserIDbyName(string name) { using (var db = new LibraryDBEntities()) { var user = db.Users.Where(x => x.UserName == name).First(); return(user.UserID); } }
public static void Add(BookCategories bc) { using (var db = new LibraryDBEntities()) { db.BookCategories.Add(bc); db.SaveChanges(); } }
public static void Add(Books b) { using (var db = new LibraryDBEntities()) { db.Books.Add(b); db.SaveChanges(); } }
public static string GetByNameFromID(int id) { using (var db = new LibraryDBEntities()) { var booksCategory = db.BookCategories.Where(x => x.BookCategoryID == id).First(); return(booksCategory.Name); } }
public static BorrowHistory GetBorrowBook(int id) { using (LibraryDBEntities context = new LibraryDBEntities()) { BorrowHistory borrowBook = context.BorrowHistories.Include(e => e.Book).Include(s => s.Student).Where(b => b.Id == id).First(); return(borrowBook); } }