C# Class SmsDb.DbInteraction

Exibir arquivo Open project: sayan801/SchoolManagementSystem

Public Methods

Method Description
DeleteAdmission ( string admissionToDelete ) : void
DeleteStudent ( string studentToDelete ) : void
DeleteTeacher ( string teacherToDelete ) : void
DoEnterAttendance ( AttendanceInfo NewAttendance ) : int
GetAllAdmissionList ( ) : List
GetAllAttendanceList ( ) : List
GetAllResidenceList ( ) : List
GetAllStudentList ( ) : List
RegisterNewAdmission ( AdmissionInfo NewAdmissionForm ) : int
RegisterNewAdmissionForm ( AdmissionInfo NewAdmissionForm ) : int
RegisterNewStudent ( StudentInfo NewStudent ) : int
RegisterNewTeacher ( TeacherInfo NewTeacher ) : int

Private Methods

Method Description
DoRegisterNewTeacherindb ( TeacherInfo NewTeacher ) : int
OpenDbConnection ( ) : MySql.Data.MySqlClient.MySqlConnection
QueryAllAdmissionListinDb ( ) : List
QueryAllStudentList ( ) : List
QueryAllTeacherList ( ) : List

Method Details

DeleteAdmission() public static method

public static DeleteAdmission ( string admissionToDelete ) : void
admissionToDelete string
return void

DeleteStudent() public static method

public static DeleteStudent ( string studentToDelete ) : void
studentToDelete string
return void

DeleteTeacher() public static method

public static DeleteTeacher ( string teacherToDelete ) : void
teacherToDelete string
return void

DoEnterAttendance() public static method

public static DoEnterAttendance ( AttendanceInfo NewAttendance ) : int
NewAttendance SmsData.AttendanceInfo
return int

GetAllAdmissionList() public static method

public static GetAllAdmissionList ( ) : List
return List

GetAllAttendanceList() public static method

public static GetAllAttendanceList ( ) : List
return List

GetAllResidenceList() public static method

public static GetAllResidenceList ( ) : List
return List

GetAllStudentList() public static method

public static GetAllStudentList ( ) : List
return List

RegisterNewAdmission() public static method

public static RegisterNewAdmission ( AdmissionInfo NewAdmissionForm ) : int
NewAdmissionForm SmsData.AdmissionInfo
return int

RegisterNewAdmissionForm() public static method

public static RegisterNewAdmissionForm ( AdmissionInfo NewAdmissionForm ) : int
NewAdmissionForm SmsData.AdmissionInfo
return int

RegisterNewStudent() public static method

public static RegisterNewStudent ( StudentInfo NewStudent ) : int
NewStudent SmsData.StudentInfo
return int

RegisterNewTeacher() public static method

public static RegisterNewTeacher ( TeacherInfo NewTeacher ) : int
NewTeacher SmsData.TeacherInfo
return int