string courses_to_html(course_info c_inf)
{
StringBuilder str = new StringBuilder();
str.Append(" <div class=\"card w-150\">\n");
str.Append(" <div class=\"card-body row\">\n");
str.Append(" <div class=\"col-md-1\">\n");
str.Append(" <div class = \"rank\" >\n");
str.Append(" <span class=\"material-icons\">keyboard_arrow_up</span>\n");
str.Append(string.Format(" <p>{0}</p>\n", c_inf.course_rate));
str.Append(" </div> \n </div>\n");
str.Append(" <div class=\"col-md-9\">\n");
str.Append(string.Format(" <h5 class=\"card-title\">{0}</h5>\n", c_inf.course_name));
str.Append(" <br/>\n");
str.Append(" <div class=\"add-by\">\n");
str.Append(" <p class = \"added\"> أضيف بواسطة</p>\n");
str.Append(" <div class=\"profile-Pic\"></div>\n");
str.Append(string.Format(" <a href = \"{1}\"> {0}</a>\n", c_inf.added_by, c_inf.profile_link));
str.Append(" </div>\n");
str.Append(string.Format(" <a class = \"comments\" href=\"{0}\"> {1} تعليقات</a>\n", c_inf.comments_link, c_inf.comments_count));
str.Append(" <div class=\"hash-list\">\n");
str.Append(string.Format(" <h5><span class=\"badge badge-secondary\">{0}</span></h5>\n", c_inf.course_level));
str.Append(" <h5><span class=\"badge badge-secondary\">جديد</span></h5>\n");
str.Append(string.Format(" <h5><span class=\"badge badge-secondary\">{0}</span></h5>\n", c_inf.course_type));
str.Append(" </div>\n </div> \n");
str.Append(" <div class=\"col-md-2\">\n");
str.Append(" <div class =\"save-it\">\n");
str.Append(" <span class=\"material-icons\" style=\"display: inline-block; \">collections_bookmark</span>\n");
str.Append(" <p style = \"display: inline-block; vertical-align: middle; \" > حفظ </ p >\n");
str.Append(" </div>\n </div>\n </div>\n </div>\n");
return(str.ToString());
}
string load_courses(string sub_path_id)
{
StringBuilder str = new StringBuilder();
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("SELECT id,name,level,type,sub_path_id,rate from courses_data where sub_path_id = '" + sub_path_id + "';", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
course_info c_info = new course_info();
c_info.course_name = dr[1].ToString();
c_info.course_type = courses_types[dr[3].ToString()];
c_info.course_rate = dr[5].ToString();
c_info.course_level = courses_levels[dr[2].ToString()];
str.Append(courses_to_html(c_info));
}
}
dr.Close();
con.Close();
}
catch (Exception ex)
{
}
return(str.ToString());
}
