protected void Page_Load(object sender, EventArgs e) { //generate meta tag from meta table insert into title string storeprocedurename = "mysp_learnkey_meta_title_defult"; DataTable DT_settings_meta = gl.runstoreprocedure(storeprocedurename, ""); HeaderContent_meta_title = gl.datatable2string(DT_settings_meta, "meta_title"); //toplinkbar //generate html tag from html table insert into toplinkbar storeprocedurename = "mysp_learnkey_html_toplinkbar"; DataTable DT_html_toplinkbar = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_TopLinkkBar = gl.datatable2string(DT_html_toplinkbar, "html_toplinkbar"); //nextcources //generate html tag from html table insert into next cources storeprocedurename = "mysp_learnkey_html_nextcources"; DataTable DT_html_nextcources = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_NextCources = gl.datatable2string(DT_html_nextcources, "html_nextcources"); //certified //generate html tag from html table insert into next certified storeprocedurename = "mysp_learnkey_html_certified"; DataTable DT_html_certified = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_certified = gl.datatable2string(DT_html_certified, "html_certified"); }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["id_news"]; string storeprocedurename; //generate meta tag from meta table insert into title //storeprocedurename = "mysp_learnkey_meta_title"; //DataTable DT_settings_meta = gl.runstoreprocedure(storeprocedurename, ""); //HeaderContent_meta_title = gl.datatable2string(DT_settings_meta, "meta_title"); //toplinkbar //generate html tag from html table insert into toplinkbar storeprocedurename = "mysp_learnkey_html_toplinkbar"; DataTable DT_html_toplinkbar1 = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_TopLinkkBar = gl.datatable2string(DT_html_toplinkbar1, "html_toplinkbar"); //generate html tag from html sharhekhabar //storeprocedurename = "mysp_learnkey_html_sharhenews"; //DataTable DT_html_sharhenews = gl.runstoreprocedure(storeprocedurename, ""); //BodyContent_html_sharhenews = gl.datatable2string(DT_html_sharhenews, "html_sharhenews"); com.CommandText = "SELECT * FROM lk_arj_news$ where id_news=N'" + id + "'"; com.Connection = con; SqlDataReader dr = null; con.Open(); dr = com.ExecuteReader(); dr.Read(); string title = dr["title"].ToString(); string body = dr["body"].ToString(); string date = dr["date"].ToString(); string manba = dr["manba"].ToString(); con.Close(); dr.Close(); HeaderContent_meta_title = title; BodyContent_html_sharhenews += " <h3>"; BodyContent_html_sharhenews += title; BodyContent_html_sharhenews += "</h3>"; BodyContent_html_sharhenews += " <div class=\"postDate\"><span>تاريخ انتشار : </span>"; BodyContent_html_sharhenews += date; BodyContent_html_sharhenews += "</div>"; BodyContent_html_sharhenews += "<div style=\"width: 100%; text-align: center; margin-top: 20px; margin-bottom: 20px;\"></div> <div class=\"entry-content\"><div class=\"simplesocialbuttons\">"; BodyContent_html_sharhenews += "<div class=\"simplesocialbutton ssb-button-googleplus\"><!-- Google Plus One--><div class=\"g-plusone\" data-size=\"medium\" data-href=\"http://arjang.ac.ir/%d8%b3%db%8c%d8%b3%da%a9%d9%88-%d8%b1%d9%88%db%8c-%d9%be%d8%b1%d9%88%da%98%d9%87-80-%d9%85%db%8c%d9%84%db%8c%d9%88%d9%86-%d8%af%d9%84%d8%a7%d8%b1%db%8c-%d9%81%d8%b6%d8%a7%db%8c-%d8%a7%d8%a8%d8%b1-clo/\"></div></div>"; BodyContent_html_sharhenews += "<div class=\"simplesocialbutton ssb-button-fblike\"><!-- Facebook like--><div id=\"fb-root\"></div><div class=\"fb-like\" data-href=\"http://arjang.ac.ir/%d8%b3%db%8c%d8%b3%da%a9%d9%88-%d8%b1%d9%88%db%8c-%d9%be%d8%b1%d9%88%da%98%d9%87-80-%d9%85%db%8c%d9%84%db%8c%d9%88%d9%86-%d8%af%d9%84%d8%a7%d8%b1%db%8c-%d9%81%d8%b6%d8%a7%db%8c-%d8%a7%d8%a8%d8%b1-clo/\" data-send=\"false\" data-layout=\"button_count\" data-width=\"100\" data-show-faces=\"false\"></div></div>"; BodyContent_html_sharhenews += "<div class=\"simplesocialbutton ssb-buttom-twitter\"><!-- Twitter--><a href=\"https://twitter.com/share\" class=\"twitter-share-button\" data-text=\""; BodyContent_html_sharhenews += title; BodyContent_html_sharhenews += " \" data-url=\"http://arjang.ac.ir/%d8%b3%db%8c%d8%b3%da%a9%d9%88-%d8%b1%d9%88%db%8c-%d9%be%d8%b1%d9%88%da%98%d9%87-80-%d9%85%db%8c%d9%84%db%8c%d9%88%d9%86-%d8%af%d9%84%d8%a7%d8%b1%db%8c-%d9%81%d8%b6%d8%a7%db%8c-%d8%a7%d8%a8%d8%b1-clo/\" data-via=\"arjangins\" rel=\"nofollow\"></a></div>"; BodyContent_html_sharhenews += "</div><p dir=\"RTL\">"; BodyContent_html_sharhenews += body; BodyContent_html_sharhenews += "</p><p dir=\"RTL\"><a href=\""; BodyContent_html_sharhenews += manba; BodyContent_html_sharhenews += "\" target=\"_blank\">لینک خبر</a></p></div>"; }
protected void Page_Load(object sender, EventArgs e) { string storeprocedurename; //generate meta tag from meta table insert into title storeprocedurename = "mysp_learnkey_meta_title_maghalat"; DataTable DT_settings_meta = gl.runstoreprocedure(storeprocedurename, ""); HeaderContent_meta_title = gl.datatable2string(DT_settings_meta, "meta_title"); //toplinkbar //generate html tag from html table insert into toplinkbar storeprocedurename = "mysp_learnkey_html_toplinkbar"; DataTable DT_html_toplinkbar = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_TopLinkkBar = gl.datatable2string(DT_html_toplinkbar, "html_toplinkbar"); //generate html tag from html table insert into maghalat storeprocedurename = "mysp_learnkey_html_maghalat"; DataTable DT_html_maghalat = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_maghalat = gl.datatable2string(DT_html_maghalat, "html_maghalat"); }
protected void Page_Load(object sender, EventArgs e) { string storeprocedurename; //generate meta tag from meta table insert into title storeprocedurename = "mysp_learnkey_meta_title_darbarema"; DataTable DT_settings_meta = gl.runstoreprocedure(storeprocedurename, ""); HeaderContent_meta_title = gl.datatable2string(DT_settings_meta, "meta_title"); //toplinkbar //generate html tag from html table insert into toplinkbar storeprocedurename = "mysp_learnkey_html_toplinkbar"; DataTable DT_html_toplinkbar = gl.runstoreprocedure(storeprocedurename, ""); BodyContent_html_TopLinkkBar = gl.datatable2string(DT_html_toplinkbar, "html_toplinkbar"); //generate html tag from html table insert into darbarema //storeprocedurename = "mysp_learnkey_html_darbarema"; //DataTable DT_html_darbarema = gl.runstoreprocedure(storeprocedurename, ""); //BodyContent_html_darbarema = gl.datatable2string(DT_html_darbarema, "html_darbarema"); com.CommandText = "SELECT * FROM lk_arj_aboutus$ where id_darbarema=N'1'"; com.Connection = con; SqlDataReader dr = null; con.Open(); dr = com.ExecuteReader(); dr.Read(); string matn = dr["matn"].ToString(); string img = dr["img"].ToString(); con.Close(); dr.Close(); string str_html_darbarema = ""; str_html_darbarema += "<div class=\"about-us-page\"><div class=\"post hentry single\" id=\"post-73\"><div class=\"postContent\"><h2 class=\"entry-title\">درباره ما</h2><div class=\"entry-content\"><div class=\"simplesocialbuttons\">"; str_html_darbarema += "<div class=\"simplesocialbutton ssb-button-googleplus\"><!-- Google Plus One--><div class=\"g-plusone\" data-size=\"medium\" data-href=\"http://arjang.ac.ir/remis/\"></div></div><div class=\"simplesocialbutton ssb-button-fblike\"><!-- Facebook like--><div id=\"fb-root\"></div><div class=\"fb-like\" data-href=\"http://arjang.ac.ir/remis/\" data-send=\"false\" data-layout=\"button_count\" data-width=\"100\" data-show-faces=\"false\"></div></div><div class=\"simplesocialbutton ssb-buttom-twitter\"><!-- Twitter--><a href=\"https://twitter.com/share\" class=\"twitter-share-button\" data-text=\"درباره ما\" data-url=\"http://arjang.ac.ir/remis/\" data-via=\"arjangins\" rel=\"nofollow\"></a></div></div><ul class=\"nav nav-tabs\"><li class=\"active\"><a href=\"#about_arjang\" data-toggle=\"tab\">درباره آموزشگاه</a></li><li><a href=\"#our_team\" data-toggle=\"tab\">تیم ما</a></li></ul><div class=\"tab-content\"><div class=\"tab-pane active\" id=\"about_arjang\"><div><p><strong>موسسه آموزشی مجازی مصباح سافت</strong>\""; str_html_darbarema += matn; str_html_darbarema += "</p>"; com.CommandText = "SELECT * FROM lk_arj_nextcourses$ "; com.Connection = con; SqlDataReader dr1 = null; con.Open(); dr1 = com.ExecuteReader(); while (dr1.Read()) { string name = dr1["name"].ToString(); str_html_darbarema += "<li><strong>"; str_html_darbarema += name; str_html_darbarema += "</strong></li>"; } con.Close(); dr1.Close(); str_html_darbarema += "</ul><div class=\"clearfix\"><div><p style=\"text-align: center;\"> </p><p> </p><p>اساتید موسسه آموزشی مجازی مصباح سافت:<p><a href=\""; str_html_darbarema += img; str_html_darbarema += "><img class=\"aligncenter size-full wp-image-3812\" alt=\"\" src=\""; str_html_darbarema += img; str_html_darbarema += "\" width=\"650\" height=\"389\" /></a></p></div></div></div></div>"; str_html_darbarema += "<div class=\"tab-pane\" id=\"our_team\"><div><div style=\"width: 600px; height: 340px;\">"; str_html_darbarema += "<div style=\"width: 320px; height: 320px; margin-right: 178px; background: url('http://arjang.ac.ir/wp-content/themes/remis/images/ourteam/manager-bg-team.png') no-repeat;\">"; str_html_darbarema += "<div><img style=\"border-radius: 10px; margin-right: 35px; margin-top: 30px;\" alt=\"\" src=\""; com.CommandText = "SELECT * FROM lk_arj_taem$ where modiriat=N'1'"; com.Connection = con; SqlDataReader dr2 = null; con.Open(); dr2 = com.ExecuteReader(); dr2.Read(); string image_modir = dr2["img"].ToString(); string name_modir = dr2["name"].ToString(); string semate_modir = dr2["semat"].ToString(); str_html_darbarema += image_modir; con.Close(); dr2.Close(); str_html_darbarema += "\" /></div><div style=\"margin-top: 10px; color: #fff;\"><p style=\"font-family: 'BNazanin', tahoma; font-size: 24px; margin-right: 95px;\"><strong>"; str_html_darbarema += name_modir; str_html_darbarema += "</strong></p><p style=\"margin-right: 95px;\">"; str_html_darbarema += semate_modir; str_html_darbarema += "</p></div></div></div><div style=\"color: #fff; margin-right: 37px; width: 600px; height: 290px; background: url('http://arjang.ac.ir/wp-content/themes/remis/images/ourteam/training-girls-bg.png') no-repeat;\">"; str_html_darbarema += "<div style=\"width: 150px; min-height: 100px; float: right; margin: 10px; margin-top: 30px; margin-right: 30px;\"><div><img style=\"border-radius: 10px;\" alt=\"\" src=\""; com.CommandText = "SELECT * FROM lk_arj_taem$ where karshenas_amozesh=N'1' and shomare=N'1'"; com.Connection = con; SqlDataReader dr3 = null; con.Open(); dr3 = com.ExecuteReader(); string name_amozesh1 = ""; string semat_amozesh1 = ""; dr3.Read(); { string image_amozesh1 = dr3["img"].ToString(); name_amozesh1 = dr3["name"].ToString(); semat_amozesh1 = dr3["semat"].ToString(); str_html_darbarema += image_amozesh1; } con.Close(); dr3.Close(); str_html_darbarema += " \" /></div><div style=\"margin-top: 10px;\"><p style=\"text-align: center;\"><strong>"; str_html_darbarema += name_amozesh1; str_html_darbarema += "</strong></p><p style=\"text-align: center;\">"; str_html_darbarema += semat_amozesh1; str_html_darbarema += "</p></div></div><div style=\"width: 150px; min-height: 100px; float: right; margin: 10px; margin-top: 30px;\"><div><div><img alt=\"\" src=\""; com.CommandText = "SELECT * FROM lk_arj_taem$ where karshenas_amozesh=N'1' and shomare=N'2'"; com.Connection = con; SqlDataReader dr4 = null; con.Open(); dr4 = com.ExecuteReader(); string name_amozesh2 = ""; string semat_amozesh2 = ""; dr4.Read(); { string image_amozesh2 = dr4["img"].ToString(); name_amozesh2 = dr4["name"].ToString(); semat_amozesh2 = dr4["semat"].ToString(); str_html_darbarema += image_amozesh2; } con.Close(); dr4.Close(); str_html_darbarema += "\" /></div></div><div style=\"margin-top: 10px;\"><p style=\"text-align: center;\"><strong>"; str_html_darbarema += name_amozesh2; str_html_darbarema += "<br /></strong></p><p style=\"text-align: center;\">"; str_html_darbarema += semat_amozesh2; str_html_darbarema += "</p></div><div style=\"width: 150px; min-height: 100px; float: right; margin: 10px; margin-top: 30px;\"><div><img style=\"border-radius: 10px;\" alt=\"\" src=\""; com.CommandText = "SELECT * FROM lk_arj_taem$ where karshenas_amozesh=N'1' and shomare=N'3'"; com.Connection = con; SqlDataReader dr5 = null; con.Open(); dr5 = com.ExecuteReader(); string name_amozesh3 = ""; string semat_amozesh3 = ""; dr5.Read(); { string image_amozesh3 = dr5["img"].ToString(); name_amozesh3 = dr5["name"].ToString(); semat_amozesh3 = dr5["semat"].ToString(); str_html_darbarema += image_amozesh3; } con.Close(); dr5.Close(); str_html_darbarema += "\" /></div><div style=\"margin-top: 10px;\"><p style=\"text-align: center;\"><strong>"; str_html_darbarema += name_amozesh3; str_html_darbarema += "</strong></p><p style=\"text-align: center;\">"; str_html_darbarema += semat_amozesh3; str_html_darbarema += "</p></div></div></div><p><br style=\"color: #fff; margin-right: 37px; width: 600px; height: 320px; background: url('http://arjang.ac.ir/wp-content/themes/remis/images/ourteam/technical-boys-bg.png') no-repeat;\" /></p><div style=\"color: #fff; margin-right: 37px; width: 600px; height: 320px; background: url('http://arjang.ac.ir/wp-content/themes/remis/images/ourteam/technical-boys-bg.png') no-repeat;\">"; str_html_darbarema += "<div style=\"width: 150px; min-height: 100px; float: right; margin: 10px; margin-top: 30px;\"><div><img style=\"border-radius: 10px;\" alt=\"\" src=\""; com.CommandText = "SELECT * FROM lk_arj_taem$ where karshenase_fani=N'1' "; com.Connection = con; SqlDataReader dr6 = null; con.Open(); dr6 = com.ExecuteReader(); string name_fani = ""; string semat_fani = ""; dr6.Read(); { string image_fani = dr6["img"].ToString(); name_fani = dr6["name"].ToString(); semat_fani = dr6["semat"].ToString(); str_html_darbarema += image_fani; } con.Close(); dr6.Close(); str_html_darbarema += "\" /></div><div style=\"margin-top: 10px;\"><p style=\"text-align: center;\"><strong>"; str_html_darbarema += name_fani; str_html_darbarema += "</strong></p><p style=\"text-align: center;\">"; str_html_darbarema += semat_fani; str_html_darbarema += "</p></div></div><div style=\"width: 150px; min-height: 100px; float: right; margin: 10px; margin-top: 30px;\"></div></div></div></div></div><p><!-- tab content --></p></div></div></div></div>"; BodyContent_html_darbarema = str_html_darbarema; }