import Read_Studio_Excel_Sheet
import Write_Studio_Excel_Sheet
def AppointmentIndexInCoachesDataBase (member_ID) :
for i in Coaches_DataBase :
for j in Coaches_DataBase[i] :
if str(member_ID) == str(j[0]) :
Appointment_index = Coaches_DataBase[i].index(j)
return Appointment_index,i
print("****************************************************************************")
print("* *")
print("* Welcome to Health Management System *")
print("* *")
print("* Your Daily Health Guide *")
print("* *")
print("****************************************************************************")
tries = 0
tries_flag = ""
while tries_flag != "Close the program" :
Members_DataBase = Read_Studio_Excel_Sheet.Read_Members_DataBase()
Coaches_DataBase = Read_Studio_Excel_Sheet.Read_Coaches_DataBase()
print("-----------------------------------------")
print("|Enter 1 for Admin mode |\n|Enter 2 for member mode |")
print("-----------------------------------------")
Admin_user_mode = input("Enter your mode : ")
if Admin_user_mode == "1" : #Admin mode
print("*****************************************\n| Welcome to Admin mode |\n*****************************************")
Password = input("Please enter your password : ")
while True :
if Password == "12345" :
print("-----------------------------------------")
print("|To manage members Enter 1 |\n|To manage downline coaches Enter 2 |\n|To manage appointments Enter 3 |\n|To be back Enter E |")
print("-----------------------------------------")
AdminOptions = input ("Enter your choice : ")
AdminOptions = AdminOptions.upper()
if AdminOptions == "1" : #Admin mode --> Members Management
print("-----------------------------------------")
print("|To add new member Enter 1 |")
print("|To display member Enter 2 |")
print("|To delete member data Enter 3 |")
print("|To edit member data Enter 4 |")
print("|To Back enter E |")
print("-----------------------------------------")
Admin_choice = input ("Enter your choice : ")
Admin_choice = Admin_choice.upper()
if Admin_choice == "1" : #Admin mode --> Members Management --> Enter new member data
try :
member_ID = int(input("Enter member ID : "))
while member_ID in Members_DataBase : #if Admin entered used ID
member_ID = int(input("This ID is unavailable, please try another ID : "))
Programme=input("Enter member programme : ")
CoachName=input("Enter name of coach guiding the member : ")
Name =input("Enter member name : ")
Age =input("Enter member age : ")
Gender =input("Enter member gender : ")
Address =input("Enter member address : ")
OriginalWeight =input("Enter member original weight : ")
CurrentWeight =input("Enter member current weight : ")
PhoneNumber=input("Enter member phone number : ")
Members_DataBase[member_ID]=[Programme,CoachName,Name,Age,Gender,Address,OriginalWeight,CurrentWeight,PhoneNumber]
print("----------------------Member added successfully----------------------")
except :
print("Member ID should be an integer number")
elif Admin_choice == "2" : #Admin mode --> Members Management --> Display member data
try :
member_ID = int(input("Enter member ID : "))
while member_ID not in Members_DataBase :
member_ID = int(input("Incorrect ID, Please Enter member ID : "))
print("\nmember name : ",Members_DataBase[member_ID][2])
print("member age : ",Members_DataBase[member_ID][3])
print("member gender : ",Members_DataBase[member_ID][4])
print("member address : ",Members_DataBase[member_ID][5])
print("member original weight : ",Members_DataBase[member_ID][6])
print("member current weight : ",Members_DataBase[member_ID][7])
print("member phone number : ",Members_DataBase[member_I