//add topic
public int AddTopic(Coursedetail topic, int courseid, int userid)
{
open();
string query = "Insert into subcourse(courseid,title,t1,t1_detail,t2,t2_detail,t3,t3_detail,t4,t4_detail,t5,t5_detail,teacherid) values(" + courseid + ",'" + topic.topictitle + "','" + topic.title1 + "','" + topic.title1_detail + "','" + topic.title2 + "','" + topic.title2_detail + "','" + topic.title3 + "','" + topic.title3_detail + "','" + topic.title4 + "','" + topic.title4_detail + "','" + topic.title5 + "','" + topic.title5_detail + "'," + userid + ")";
SqlCommand cmd = new SqlCommand(query, con);
var res = cmd.ExecuteNonQuery();
close();
return(res);
}
public int UpdateTopic(Coursedetail topic, int courseid, int userid)
{
open();
string query = "Update subcourse set t1='" + topic.title1 + "',t1_detail='" + topic.title1_detail + "',t2='" + topic.title2 + "',t2_detail='" + topic.title3_detail + "',t4='" + topic.title4 + "',t4_detail='" + topic.title4_detail + "',t5='" + topic.title5 + "',t5_detail='" + topic.title5_detail + "' where teacherid=" + userid;
SqlCommand cmd = new SqlCommand(query, con);
var res = cmd.ExecuteNonQuery();
close();
return(res);
}
//student view sub topic
public IEnumerable <Coursedetail> Selectsubtopics(int courseid)
{
open();
string query = "select * from subcourse where courseid=" + courseid;
List <Coursedetail> subcourse = new List <Coursedetail>();
SqlCommand cmd = new SqlCommand(query, con);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var subcourses = new Coursedetail {
id = dr.GetInt32(0), topictitle = dr.GetString(12), title1 = dr.GetString(2), title1_detail = dr.GetString(3), title2 = dr.GetString(4), title2_detail = dr.GetString(5), title3 = dr.GetString(6), title3_detail = dr.GetString(7), title4 = dr.GetString(8), title4_detail = dr.GetString(9), title5 = dr.GetString(10), title5_detail = dr.GetString(11)
};
subcourse.Add(subcourses);
}
}
return(subcourse);
close();
}
//course detail
public IEnumerable <Coursedetail> Detailcourse()
{
open();
string query = "select course.*,coursedetail.* from subcourse as course inner join subcourse as coursedetail on course.id = coursedetail.courseid";
List <Coursedetail> coursedetail = new List <Coursedetail>();
SqlCommand cmd = new SqlCommand(query, con);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var coursedetails = new Coursedetail {
coursename = dr.GetString(1), title1 = dr.GetString(4), title1_detail = dr.GetString(5), title2 = dr.GetString(6), title2_detail = dr.GetString(7), title3 = dr.GetString(8), title3_detail = dr.GetString(9), title4 = dr.GetString(10), title4_detail = dr.GetString(11), title5 = dr.GetString(12), title5_detail = dr.GetString(13)
};
coursedetail.Add(coursedetails);
}
}
return(coursedetail);
close();
}