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);
}
