public List <Project_Sce.CodeLayer.Student> GetStudents(Project_Sce.CodeLayer.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 UpdateStudent(Project_Sce.CodeLayer.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);
}
