def __init__(self):
self.borrowDAO = borrowDAO()
self.studentDAO = StudentDAO()
self.borrowUtil = BorrowUtil()
self.bookManager = BookManager()
class StudentManager:
# StudentManager Class deals with all the operations related to student
def __init__(self):
self.borrowDAO = borrowDAO()
self.studentDAO = StudentDAO()
self.borrowUtil = BorrowUtil()
self.bookManager = BookManager()
# To register new students. Adds student details to the database
def register_student(self):
try:
studentDTO = self.get_student_details_console()
#print("calling student DAO")
self.studentDAO.insert_student_details(studentDTO)
print("Registered student " "successfully")
except Exception as e:
raise e
# Method to get the user input and pass them to calling function as DTO
def get_student_details_console(self):
try:
name = input("Name: ")
Id = int(input("Id: "))
gender = input("Gender(M/F) : ")
dept = input("Department: ")
contact = input("Contact number: ")
lib_id = input("Library Id: ")
studentDTO = StudentDTO(Id, name, gender, dept, contact, lib_id)
print("StudentDTO inside the student Manager", studentDTO)
return studentDTO
except Exception as e:
print(e)
#Method to grant book to the student. It checks the eligibility criteria of the book to be granted and updates the details to database
def grant_book(self, req_book_id, student_id):
borrowDTO = BorrowDTO(student_id, req_book_id, date.today(), "0")
flag = 0
book_type = self.borrowUtil.get_book_type(req_book_id)
return_status = self.borrowUtil.get_return_status(req_book_id)
borrow_count_stu = self.borrowUtil.borrow_limit_stu(student_id)
try:
if 'r' in book_type[-1] or return_status is 1:
print("book is not available for borrow")
return
else:
if borrow_count_stu > 4: # checking the student borrow limit. Max limit : 4
print(" Borrow limit reached")
return
else:
# print("limit not reached")
self.borrowDAO.insert_student__borrow_details(borrowDTO)
print("Succesfully updated the details")
except Exception as e:
raise e
# to return the book. takes the student Id, Book id and updates the database accordingly
def return_book(self):
try:
stu_id = input("please enter the student Id: ")
return_id = input("please Enter the book id: ")
self.borrowDAO.stu_return_book(stu_id, return_id)
print("successfully updated the details")
except Exception as e:
raise e
#Displays details of all the students
def show_all_students(self):
try:
rows = self.studentDAO.show_students()
headers = ["ID", "Name", "Gender", "Dept", "Contact", "lib_id"]
print(tabulate(rows, headers, "grid"))
except Exception as e:
print(e)
# Displays borrow history of the given student
def show_records_by_id(self):
try:
stu_id = int(input("Enter the Student Id: "))
data = self.borrowDAO.stu_show_records(stu_id)
headers = ["ID", "Title", "Issued on", "Return Status"]
print(tabulate(data, headers, "grid"))
except Exception as e:
print(e)
def __init__(self):
self.StudentDAO = StudentDAO()
self.BookDAO = BookDAO()
class StudentManagement:
def __init__(self):
self.StudentDAO = StudentDAO()
self.BookDAO = BookDAO()
@staticmethod
def extra_fine(x):
c = x.split("|")
try:
c.remove('')
except ValueError as e:
pass
t = Watch.time_stamp()
k = 0
for i in c:
j = i.split("_")
k += (t - int(j[1]))
return DataPacker(k)
def invoke_student_registration(self):
student_details = self.get_student_details()
self.StudentDAO.register_a_student(student_details)
print("ID: ", end="")
print(self.StudentDAO.get_recent_SID().one[0][0])
y = input("Press enter to continue...")
def get_student_details(self):
name = input("Enter the student's name: ")
roll_no = int(input("Enter the institute roll no: "))
department = input("Enter department name ex: ECE: ")
gender = input("Gender: ")
mobile = int(input("Enter mobile: "))
regtime = Watch.time_stamp()
return DataPacker(name, roll_no, gender, department, mobile, regtime)
def get_student_info(self):
SID = int(input("Enter the student ID: "))
info = self.StudentDAO.get_student_info(SID)
if not info.one:
print("No student details with this ID exists.")
y = input("Press enter to continue...")
return None
else:
print("Student ID: ", info.one[0][0])
print("Name: ", info.one[0][1])
print("Roll no: ", info.one[0][2])
print("Gender: ", info.one[0][3])
print("Department: ", info.one[0][4])
print("Mobile no: ", info.one[0][5])
print("No of book(s) issued: ", info.one[0][7])
print("Fine: Rs", info.one[0][9])
print("Fine paid: Rs.", info.one[0][10])
info.two = self.extra_fine(info.one[0][8]).one
print("Ongoing extra Fine Rs.", info.two)
y = input("Press enter to continue...")
return info
def Invoke_delete_student(self):
info = self.get_student_info()
if not info:
pass
elif info.one[0][9] - info.one[0][10] == 0 and info.two == 0:
self.StudentDAO.delete_student(info.one[0][0])
print("The Student got Deleted successfully.")
y = input("Press enter to continue...")
elif info.one[0][9] - info.one[0][10] + info.two != 0:
print(
"This student is yet pay some more fine or even return a book."
)
y = input(
"Enter y to force delete the student ID | press enter to Cancel"
)
if y == 'y' or y == 'Y':
self.StudentDAO.delete_student(info.one[0][0])
print("The Student got Deleted successfully.")
y = input("Press enter to continue...")
else:
print("Request cancelled...")
y = input("Press enter to continue...")
else:
print("Something went wrong...")
y = input("Press enter to continue...")
def Invoke_active_SID(self):
n = self.StudentDAO.all_active_SID()
m = self.StudentDAO.get_recent_SID()
print("The number of active student Registrations are: ",
m.one[0][0] - len(n.one))
y = input("Press enter to continue...")
def Invoke_fine_payment(self):
info = self.get_student_info()
payment = int(input("Enter the amount paid: Rs."))
payment += info.one[0][10]
info.two = payment
self.StudentDAO.update_student_fine(info)
print("Student Fine has been paid successfully.")
y = input("Press enter to continue...")
def main_panel(self):
s = True
while s:
print("====> Student Management <====")
print("Enter 1 to register a New Student into the Library.")
print("Enter 2 to issue a Book to a Student.")
print("Enter 3 to get student details using ID.")
print("Enter 4 to delete a Student from the Library.")
print("Enter 5 to see total number of active ID.")
print("Enter 6 for Fine payment using Student ID.")
print("Enter b to go back to previous menu.")
x = input()
if x == 'b' or x == 'B':
s = False
elif x == '1':
self.invoke_student_registration()
elif x == '2':
print("Please go to Book Management menu")
y = input("Press enter to continue...")
elif x == '3':
self.get_student_info()
elif x == '4':
self.Invoke_delete_student()
elif x == '5':
self.Invoke_active_SID()
elif x == '6':
self.Invoke_fine_payment()
class BookManagement:
def __init__(self):
self.BookDAO = BookDAO()
self.StudentDAO = StudentDAO()
self.Watch = Watch()
def invoke_book_registration(self):
book_details = self.get_book_details()
BID = self.BookDAO.register_a_book(book_details)
if not BID:
print("The registration was unsuccessful, please try again...")
y = input("Press enter to continue...")
else:
print("Book was registered successfully.")
print("Book ID: ", BID.one[0][0])
y = input("Press enter to continue...")
@staticmethod
def get_book_details():
title = input("Enter the title of the book: ")
department = input("Enter department name ex: ECE: ")
author = input("Enter the author name: ")
type_of_book = input("Enter book type v/r: ")
regtime = Watch.time_stamp()
return DataPacker(title, author, type_of_book, department, regtime)
def invoke_issue_book(self):
validated_data = self.validate_SID_BID()
if not validated_data:
pass
else:
n = self.BookDAO.out_book_tally()
if not n.one:
validated_data.four = 1
validated_data.seven = 1
else:
validated_data.four = n.one[0][3] + 1
validated_data.seven = n.one[0][2] + 1
self.BookDAO.issue_a_book(validated_data)
print("This has been successfully Issued to the Student.")
y = input("Press enter to continue...")
@staticmethod
def collect_SID_BID():
SID = int(input("Enter the student ID: "))
BID = int(input("Enter the book ID: "))
return DataPacker(SID, BID)
def validate_SID_BID(self):
group = self.collect_SID_BID()
y = self.StudentDAO.get_student_info(group.one)
if not y.one:
print("Student with this ID does not exists.")
y = input("Press enter to continue...")
return None
elif y.one[0][6] == 0:
print("This Student ID is in Delete status.")
y = input("Press enter to continue...")
return None
else:
z = self.BookDAO.get_book_info(group.two)
if not z.one:
print("Book with this ID does not exists.")
y = input("Press enter to continue...")
return None
else:
if y.one[0][7] >= 7:
print("This student has already issued 7 books.")
y = input("Press enter to continue...")
return None
elif type(z.one[0][6]) is int:
print("This book is already issued.")
y = input("Press enter to continue...")
return None
elif z.one[0][3] == 'r':
print(
"This book is only for reference. Please select another book."
)
y = input("Press enter to continue...")
return None
elif z.one[0][3] == 'd':
print(
"This book has been deleted. Please choose another book."
)
y = input("Press enter to continue...")
return None
else:
group.three = Watch.time_stamp()
group.six = y.one[0][7] + 1
group.five = y.one[0][8]
return group
@staticmethod
def string_changer(a, b):
c = a.one[0][8].split("|")
b = str(b)
try:
c.remove('')
except ValueError as e:
pass
k = -1
for i in c:
j = i.split("_")
k += 1
if j[0] == b:
break
try:
c.pop(k)
except IndexError as e:
pass
d = "|".join(c)
return DataPacker(a.one[0][7] - 1, d)
def invoke_return_book(self):
BID = int(input("Enter the book ID: "))
book_info = self.BookDAO.get_book_info(BID)
if not book_info.one:
print("This book ID does not exist.")
y = input("Press enter to continue...")
elif not book_info.one[0][6]:
print("This book is not issued! and already inside the library. ")
y = input("Press enter to continue...")
else:
book_info.four = self.Watch.time_stamp()
time_lapsed = book_info.four - book_info.one[0][8]
# charges = Rs.2 per minute
stud_details = self.StudentDAO.get_student_info(
book_info.one[0][6])
book_info.two = (time_lapsed // 60) * 2 + stud_details.one[0][9]
print("The book fine is Rs.", book_info.two)
SID_updates = self.string_changer(stud_details,
book_info.one[0][0])
book_info.three = self.BookDAO.out_book_tally().one[0][3] - 1
self.BookDAO.return_a_book(book_info, SID_updates)
print("The book has been successfully Returned the Library.")
y = input("Press enter to continue...")
def Invoke_book_details(self):
BID = input("Enter the book ID: ")
details = self.BookDAO.get_book_info(BID)
if not details.one:
print("No Book with this ID exists.")
y = input("Press enter to continue...")
return 0
else:
print("Book ID: ", details.one[0][0])
print("Title: ", details.one[0][1])
print("Author: ", details.one[0][2])
print("Type: ", details.one[0][3])
print("Department: ", details.one[0][4])
print("Book status: ", end="")
if not details.one[0][6] and details.one[0][3] == 'v':
print("Avialable for Issue")
y = input("Press enter to continue...")
return 1
elif details.one[0][3] == 'd':
print("This book has been Deleted.")
y = input("Press enter to continue...")
return 2
else:
print("Issued to student ID: ", details.one[0][6])
y = input("Press enter to continue...")
return 3
def Invoke_delete_book(self):
BID = self.Invoke_book_details()
if BID == 0:
pass
elif BID == 1:
confirm = input("Enter y to confirm delete | Enter n to cancel: ")
if confirm == 'y' or confirm == 'Y':
self.BookDAO.delete_a_book(BID)
print("The book got Deleted successfully.")
y = input("Press enter to continue...")
else:
print("Request got cancelled.")
y = input("Press enter to continue...")
elif BID == 2:
pass
elif BID == 3:
print("This book is presently issued to a student.")
confirm = input("Enter y to confirm delete | Enter n to cancel: ")
if confirm == 'y' or confirm == 'Y':
self.BookDAO.delete_a_book(BID)
y = input("Press enter to continue...")
else:
print("Request got cancelled.")
y = input("Press enter to continue...")
else:
print("Request got cancelled.")
y = input("Press enter to continue...")
def invoke_active_books(self):
max = self.BookDAO.get_recent_BID()
d = self.BookDAO.get_delete_BID()
r = self.BookDAO.get_reference_BID()
print("The total number of books in Library = ",
max.one[0][0] - len(d.one))
print("The total number of vendable books = ",
max.one[0][0] - len(d.one) - len(r.one))
print("The total number of reference books = ", len(r.one))
print("The total number of deleted books = ", len(d.one))
y = input("Press enter to continue...")
def create_default_tables(self):
self.BookDAO.create_default_tables()
def main_panel(self):
s = True
while s:
print("====> Book Management <====")
print("Enter 1 to register a New Book into the Library.")
print("Enter 2 to issue a Book.")
print("Enter 3 to return a Book.")
print("Enter 4 to delete a Book from the Library.")
print("Enter 5 to get book details using book ID.")
print("Enter 6 to get recent BID.")
print("Enter 7 to get total active books.")
print("Enter b to go back to previous menu.")
x = input()
if x == 'b' or x == 'B':
s = False
elif x == '1':
self.invoke_book_registration()
elif x == '2':
self.invoke_issue_book()
elif x == '3':
self.invoke_return_book()
elif x == '4':
self.Invoke_delete_book()
elif x == '5':
self.Invoke_book_details()
elif x == '6':
bid = self.BookDAO.get_recent_BID()
print("The recently registered book's ID is: ", end="")
if not bid.one:
print("No book registrations yet.")
else:
print(bid.one[0][0])
y = input("Press enter to continue...")
elif x == '7':
self.invoke_active_books()
def __init__(self):
self.borrowDAO = borrowDAO()
self.studentDAO = StudentDAO()
self.bookDAO = BookDAO()