def update_attendance_record_by_id(_id, date, enrollment_id, status_id):
query = f"update {ATTENDANCE_RECORD} " \
f"set {ATTENDANCE_DATE} = '{date}', " \
f"{ENROLLMENT_ID} = '{enrollment_id}', " \
f"{STATUS_ID} ='{status_id}' " \
f"where {ID} = {_id}"
return database.insert_query(query)
def insert_user_by_id(_id, user):
query = f"insert into {USER}({ID},{USER_NAME},{FATHER_NAME},{CNIC},{EMAIL},{MOTHER_TONGUE},{CONTACT}," \
f"{GENDER_ID},{GUARDIAN_NAME},{GUARDIAN_CONTACT},{DOB},{AGE})" \
f"values({_id},'{user[gc.NAME]}','{user[gc.FATHER_NAME]}','{user[gc.CNIC]}','{user[gc.EMAIL]}'," \
f"'{user[gc.MOTHER_TONGUE]}','{user[gc.CONTACT]}',{user[gc.GENDER_ID]}," \
f"'{user[gc.GUARDIAN_NAME]}','{user[gc.GUARDIAN_CONTACT]}','{user[gc.DATE_OF_BIRTH]}','{user[gc.AGE]}')"
return database.insert_query(query)
def insert_course_by_id(_id, name):
query = f"insert into {COURSE}({ID},{COURSE_NAME}) values({_id},'{name}')"
return database.insert_query(query)
def update_course_by_id(_id, name):
query = f"update {COURSE} set {COURSE_NAME} = '{name}' where {ID} = {_id}"
return database.insert_query(query)
def delete_course_by_id(_id):
query = f'delete from {COURSE} where {ID} = {_id}'
return database.insert_query(query)
def insert_madrassa_by_id(_id, name):
query = f"insert into {MADRASSA}({ID},{MADRASSA_NAME}) values({_id},'{name}')"
return database.insert_query(query)
def insert_attendance_record_by_id(_id, date, enrollment_id, status_id):
query = f"insert into {ATTENDANCE_RECORD}({ID},{ATTENDANCE_DATE},{ENROLLMENT_ID},{STATUS_ID}) values ({_id},{date},{enrollment_id},{status_id})"
return database.insert_query(query)
def insert_gender_by_id(_id, name):
query = f"insert into {GENDER}({ID},{GENDER}) values({_id},'{name}')"
return database.insert_query(query)
def update_role_by_id(_id, name):
query = f"update {ROLE} set {ROLE_NAME} = '{name}' where id = {_id}"
return database.insert_query(query)
def delete_role_by_id(_id):
query = f'delete from {ROLE} where {ID} ={_id}'
return database.insert_query(query)
def insert_madrassa_detail_by_id(_id, shift_id, course_id, madrassa_id):
query = f"insert into {MADRASSA_DETAILS}({ID}, {SHIFT_ID}, {COURSE_ID}, {MADRASSA_ID})" \
f"values({_id}, {shift_id}, {course_id}, {madrassa_id})"
return database.insert_query(query)
def insert_shift_by_id(_id, name, start_time, end_time):
query = f"insert into shift({ID},{SHIFT_NAME},{START_TIME},{END_TIME}) " \
f"values({_id},'{name}','{start_time}','{end_time}')"
return database.insert_query(query)
def update_shift_by_id(_id, name, start_time, end_time):
query = f"update {SHIFT} " \
f"set {SHIFT_NAME} = '{name}' , {START_TIME} = '{start_time}', {END_TIME}= '{end_time}' " \
f"where {ID} = {_id} "
return database.insert_query(query)
def delete_shift_by_id(_id):
query = f'delete from {SHIFT} where {ID} ={_id}'
return database.insert_query(query)
def delete_gender_by_id(_id):
query = f'delete from {GENDER} where {ID}={_id}'
return database.insert_query(query)
def update_gender_by_id(_id, name):
query = f"update {GENDER} set {GENDER} = '{name}' where id = {_id}"
return database.insert_query(query)
def insert_role_by_id(_id, name):
query = f"insert into {ROLE}({ID}, {ROLE_NAME}) values({_id},'{name}')"
return database.insert_query(query)
def insert_new_attendance_status_by_id(_id, status):
query = f"insert into {ATTENDANCE}({ID},{STATUS}) values ({_id},'{status}')"
return database.insert_query(query)
def delete_madrassa_by_id(_id):
query = f'delete from {MADRASSA} where {ID}={_id}'
return database.insert_query(query)
def update_madrassa_by_id(_id, name):
query = f"update {MADRASSA} set {MADRASSA_NAME} = '{name}' where id = {_id}"
return database.insert_query(query)
def enroll_user_in_madrassa_by_id(_id, user, madrassa_detail, role, enrollment_date):
query = f"insert into {ENROLLMENT}({ID},{ENROLLMENT_DATE},{USER_ID},{ROLE_ID},{MADRASSA_DETAIL_ID}) " \
f"values({_id},'{enrollment_date}',{user[gc.ID]},{role[gc.ID]},{madrassa_detail[gc.ID]})"
return database.insert_query(query)
