public List <Project_Sce.CodeLayer.Student> GetStudents(Project_Sce.CodeLayer.Student student) { List <Project_Sce.CodeLayer.Student> students = new List <Project_Sce.CodeLayer.Student>(); DataBase db = DataBase.Instance; SqlCommand cmd = new SqlCommand ( "SELECT * from Student", db.Con // at this time get all students, in the future by all keys // WHERE (key='" + course.key + "') ); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { //int example1 = reader.GetInt32(0); string example2 = reader.GetString(1); // another way to get values sergei note int id = Convert.ToInt32(reader["StudID"]); string name = reader["Name"].ToString().Trim(); int year = (int)reader["Year"]; float average = (float)(double)reader["Average"]; string address = reader["Address"].ToString().Trim(); string email = reader["Email"].ToString().Trim(); string semester = reader["Semester"].ToString().Trim(); bool cyber = reader["Cyber"] == DBNull.Value ? false : Convert.ToBoolean(reader["Cyber"]); //Convert.ToInt32(var); students.Add(new Project_Sce.CodeLayer.Student(id, name, year, average, address, email, semester, cyber)); } } return(students); }
public bool DeleteStudent(Project_Sce.CodeLayer.Student toDeleteStudent) { DataBase db = DataBase.Instance; SqlCommand cmd = new SqlCommand ( "DELETE from Student WHERE (StudID='" + toDeleteStudent.ID + "')", db.Con ); int result = cmd.ExecuteNonQuery(); return(result == 0 ? false : true); }
public DataTable GetDataTable <T>(T t) { if (t is Course) { Course course = t as Course; DataTable courses = ConvertToDataTable <T>((List <T>)(object) GetCourses(course)); return(courses); } else if (t is Project_Sce.CodeLayer.Student) { //Project_Sce.CodeLayer.Student student = t as Student; //return student.get_All_Students(); Project_Sce.CodeLayer.Student student = t as Project_Sce.CodeLayer.Student; DataTable students = ConvertToDataTable <T>((List <T>)(object) GetStudents(student)); return(students); } else if (t is Lecturer) { //Project_Sce.CodeLayer.Student student = t as Student; //return student.get_All_Students(); Lecturer lecturer = t as Lecturer; DataTable lecturers = ConvertToDataTable <T>((List <T>)(object) GetLecturers(lecturer)); return(lecturers); } else if (t is Project_Sce.CodeLayer.Constraint) { //Project_Sce.CodeLayer.Student student = t as Student; //return student.get_All_Students(); Project_Sce.CodeLayer.Constraint constraint = t as Project_Sce.CodeLayer.Constraint; DataTable constraints = ConvertToDataTable <T>((List <T>)(object) GetConstraints(constraint)); return(constraints); } else if (t is Classroom) { //Project_Sce.CodeLayer.Student student = t as Student; //return student.get_All_Students(); Classroom classRoom = t as Classroom; DataTable classRooms = ConvertToDataTable <T>((List <T>)(object) GetClassrooms(classRoom)); return(classRooms); } else if (t is Lesson) { Lesson lesson = t as Lesson; DataTable lessons = ConvertToDataTable <T>((List <T>)(object) GetLessons(lesson)); return(lessons); } return(null); }
public bool Delete <T>(T t) { if (t is Lecturer) { Lecturer lecturer = t as Lecturer; bool result = DeleteLecturer(lecturer); return(result); } else if (t is Project_Sce.CodeLayer.Student) { Project_Sce.CodeLayer.Student student = t as Project_Sce.CodeLayer.Student; bool result = DeleteStudent(student); return(result); } return(false); }
public bool UpdateStudent(Project_Sce.CodeLayer.Student student) { DataBase db = DataBase.Instance; SqlCommand cmd = new SqlCommand ( "UPDATE Student SET Name=@Name, Year=@Year, Average=@Average, Address=@Address, Email=@Email, Semester=@Semester, Cyber=@Cyber WHERE StudID='" + student.ID + "';", db.Con ); cmd.Parameters.Add("@Name", SqlDbType.NChar, 50).Value = student.Name; cmd.Parameters.Add("@Year", SqlDbType.Int).Value = student.Year; cmd.Parameters.Add("@Average", SqlDbType.Float).Value = student.Average; cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = student.Address; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = student.Email; cmd.Parameters.Add("@Semester", SqlDbType.NVarChar).Value = student.Semester; cmd.Parameters.Add("@Cyber", SqlDbType.Bit).Value = student.Cyber; int result = cmd.ExecuteNonQuery(); return(result == 0 ? false : true); }
public bool Update <T>(T t) { if (t is Lecturer) { Lecturer lecturer = t as Lecturer; bool result = UpdateLecturer(lecturer); return(result); } else if (t is Course) { Course course = t as Course; bool result = UpdateCourse(course); return(result); } else if (t is Project_Sce.CodeLayer.Student) { Project_Sce.CodeLayer.Student student = t as Project_Sce.CodeLayer.Student; bool result = UpdateStudent(student); return(result); } return(false); }