//adding courses
public int Addcourses(subject subject)
{
open();
string query = "Insert into subject(course) values('" + subject.subjectname + "')";
SqlCommand cmd = new SqlCommand(query, con);
var res = cmd.ExecuteNonQuery();
close();
return(res);
}
public IEnumerable <subject> Listcourses()
{
open();
string query = "select * from course";
List <subject> courses = new List <subject>();
SqlCommand cmd = new SqlCommand(query, con);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var course = new subject {
subjectid = dr.GetInt32(0), subjectname = dr.GetString(1)
};
courses.Add(course);
}
}
return(courses);
close();
}
