protected void submitBtn_Click(object sender, EventArgs e) { if (FileUploadControl.HasFile) { string filename; try { filename = Path.GetFileName(FileUploadControl.FileName); FileUploadControl.SaveAs(Server.MapPath("~/images/") + filename); } catch (Exception ex) { return; } newsData _data = new newsData() { Title = Title.Value.Replace(">", "").Replace("<", ""), Image = "images/" + filename, Text = Content.Value.Replace(">", "").Replace("<", "") }; DatabaseConnector.Inst.saveNewsData(Server.MapPath("~/ ") + "/json/updatableNews.json", _data, (string)Session["loggedIn"]); Response.Redirect("default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { string title = Request.QueryString["title"]; if (title == null) { Response.Redirect("default.aspx"); } newsData target = new newsData(); List <newsData> news = DatabaseConnector.Inst.readNewsData(Server.MapPath("~/ ") + "/json/news.json"); List <newsData> uNews = DatabaseConnector.Inst.readNewsData(Server.MapPath("~/ ") + "/json/updatableNews.json"); news = news.Concat(uNews).ToList();; for (int i = 0; i < news.Count; i++) { if (news[i].Title == title) { target = news[i]; break; } } HtmlGenericControl myDiv = new HtmlGenericControl("div"); myDiv.ID = "myDiv"; if (target.Image.Substring(target.Image.LastIndexOf('.') + 1) == "mp4") { myDiv.InnerHtml += "<video controls class=\"updateVideo\"><source src=\"" + target.Image + "\" type=\"video/mp4\"/></video>"; } else { myDiv.InnerHtml += "<div class=\"image\">" + "<img src=\"" + target.Image + "\" />" + "</div>"; } myDiv.InnerHtml += "<div class=\"title\">" + title + "</div>"; myDiv.InnerHtml += "<div class=\"text\">" + target.Text + "</div>"; PlaceHolder1.Controls.Add(myDiv); }
public void saveNewsData(string path, newsData data, string user) { string CS = "Server=.\\MY_TEST_INSTANCE; Database = WebApp; Trusted_Connection = True"; string cmdString = "UPDATE UpdatableNews Set [User]=@user, Title=@title, Text=@text, Image=@image"; using (SqlConnection con = new SqlConnection(CS)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = cmdString; cmd.Parameters.AddWithValue("@user", user); cmd.Parameters.AddWithValue("@title", data.Title); cmd.Parameters.AddWithValue("@text", data.Text); cmd.Parameters.AddWithValue("@image", data.Image); con.Open(); cmd.ExecuteNonQuery(); } } }
private string createUpdatableNewsElementVideo(newsData e) { return(string.Format("<div class=\"updatableNews\"><a href=\"{0}\"><video controls class=\"updateVideo\"><source src=\"{1}\" type=\"video/mp4\"/></video><div class=\"textContent\" ><div class=\"title\">{2}</div><div class=\"text\">{3}</div></div></a></div>" , createNewsLink(e.Title), e.Image, e.Title, e.Text)); }
private string createUpdatableNewsElement(newsData e) { return(string.Format("<div class=\"updatableNews\"><a href=\"{0}\"><img src =\"{1}\" class=\"image\"/><div class=\"textContent\" ><div class=\"title\">{2}</div><div class=\"text\">{3}</div></div></a></div>" , createNewsLink(e.Title), e.Image, e.Title, e.Text)); }
private string getNewsAsHtmlString() { List <newsData> news = new List <newsData>(); List <newsData> uNews = new List <newsData>(); string CS = "Server=.\\MY_TEST_INSTANCE; Database = WebApp; Trusted_Connection = True"; using (SqlConnection con = new SqlConnection(CS)) { con.Open(); string query = "SELECT Title, Text, Image from Articles"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var article = new newsData(); article.Title = reader.GetString(0).Trim(); article.Text = reader.GetString(1).Trim(); article.Image = reader.GetString(2).Trim(); news.Add(article); } reader.Close(); string query2 = "SELECT TOP 1 * FROM UpdatableNews"; cmd = new SqlCommand(query2, con); reader = cmd.ExecuteReader(); while (reader.Read()) { var article = new newsData(); article.Title = reader.GetString(1).Trim(); article.Text = reader.GetString(2).Trim(); article.Image = reader.GetString(3).Trim(); uNews.Add(article); } reader.Close(); } // List<newsData> news = DatabaseConnector.Inst.readNewsData(Server.MapPath("~/ ") + "/json/news.json"); // List<newsData> uNews = DatabaseConnector.Inst.readNewsData(Server.MapPath("~/ ") + "/json/updatableNews.json"); string retString = ""; for (int i = 0; i < uNews.Count; i++) { if (uNews[i].Image.Substring(uNews[i].Image.LastIndexOf('.') + 1) == "mp4") { retString += createUpdatableNewsElementVideo(uNews[i]); } else { retString += createUpdatableNewsElement(uNews[i]); } } for (int i = 0; i < news.Count; i++) { retString += createNewsElement(news[i]); } return(retString); }
protected void Page_Load(object sender, EventArgs e) { string title = Request.QueryString["title"]; if (title == null) { Response.Redirect("default.aspx"); } newsData target = new newsData(); List <newsData> news = new List <newsData>(); List <newsData> uNews = new List <newsData>(); string CS = "Server=.\\MY_TEST_INSTANCE; Database = WebApp; Trusted_Connection = True"; using (SqlConnection con = new SqlConnection(CS)) { con.Open(); string query = "SELECT Title, Text, Image from Articles"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var article = new newsData(); article.Title = reader.GetString(0).Trim(); article.Text = reader.GetString(1).Trim(); article.Image = reader.GetString(2).Trim(); news.Add(article); } reader.Close(); string query2 = "SELECT TOP 1 * FROM UpdatableNews"; cmd = new SqlCommand(query2, con); reader = cmd.ExecuteReader(); while (reader.Read()) { var article = new newsData(); article.Title = reader.GetString(1).Trim(); article.Text = reader.GetString(2).Trim(); article.Image = reader.GetString(3).Trim(); uNews.Add(article); } reader.Close(); } news = news.Concat(uNews).ToList();; for (int i = 0; i < news.Count; i++) { if (news[i].Title == title) { target = news[i]; break; } } if (target.Title == null) { Response.Redirect("default.aspx"); } HtmlGenericControl myDiv = new HtmlGenericControl("div"); myDiv.ID = "myDiv"; if (target.Image.Substring(target.Image.LastIndexOf('.') + 1) == "mp4") { myDiv.InnerHtml += "<video controls class=\"updateVideo\"><source src=\"" + target.Image + "\" type=\"video/mp4\"/></video>"; } else { myDiv.InnerHtml += "<div class=\"image\">" + "<img src=\"" + target.Image + "\" />" + "</div>"; } myDiv.InnerHtml += "<div class=\"title\">" + title + "</div>"; myDiv.InnerHtml += "<div class=\"text\">" + target.Text + "</div>"; PlaceHolder1.Controls.Add(myDiv); }