public static void UpdateClass(string TeacherId, string StudentId, string Date, int Hour, int Id) { string com = "update Classes set TeacherId = '" + TeacherId + "' and StudentId = '" + StudentId + "', ClassDate = '" + Date + "' , ClassHour = '" + Hour + "' where ClassCode=" + Id + ""; OLEDBHelper.Execute(com); }
public static void DeleteClass(int Id) { string com = "Delete From Classes where ClassCode = " + Id + ""; OLEDBHelper.Execute(com); }
public static DataTable GetAllClasses() { string com = "select * from Classes"; return(OLEDBHelper.GetTable(com)); }
public static DataTable GetAllClassesForTeacher(string Id) { string com = "select * from Classes where TeacherId = '" + Id + "'"; return(OLEDBHelper.GetTable(com)); }
public static void DeleteStudent(int Id) { string com = "Delete From Students where StudentId = '" + Id + "'"; OLEDBHelper.Execute(com); }
public static void AddClass(string TeacherId, string StudentId, string Date, int Hour) { string com = "insert into Classes (TeacherId , StudentId , ClassDate, ClassHour) VALUES ('" + TeacherId + "', '" + StudentId + "' , '" + Date + "' , '" + Hour + "')"; OLEDBHelper.Execute(com); }
public static DataTable GetAllStudents() { string com = "select * from Students"; return(OLEDBHelper.GetTable(com)); }
public static void UpdateStudent(string Name, string Last, string Phone, int Id) { string com = "update Students set StudentName = '" + Name + "' , StudentLast = '" + Last + "', StudentPhone = '" + Phone + "' where StudentId='" + Id + "'"; OLEDBHelper.Execute(com); }
public static void AddStudent(string Name, string Last, string Phone) { string com = "insert into Students (StudentName , StudentLast , StudentPhone) VALUES ('" + Name + "', '" + Last + "' , '" + Phone + "')"; OLEDBHelper.Execute(com); }
public static void DeleteTeacher(int Id) { string com = "Delete From Teachers where TeacherId =" + Id + ""; OLEDBHelper.Execute(com); }
public static void UpdateTeacher(string Name, string Last, string Phone, int Id) { string com = "update Teachers set TeacherName = '" + Name + "' , TeacherLast = '" + Last + "' , TeacherPhone = '" + Phone + "' where TeacherId=" + Id + ""; OLEDBHelper.Execute(com); }
public static DataTable GetAllTeachers() { string com = "select * from Teachers"; return(OLEDBHelper.GetTable(com)); }
public static void AddTeacher(string Name, string Last, string Phone) { string com = "insert into Teachers (TeacherName , TeacherLast , TeacherPhone) VALUES ('" + Name + "', '" + Last + "' , '" + Phone + "')"; OLEDBHelper.Execute(com); }