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