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);
}
