protected void Page_Load(object sender, EventArgs e)
{
List<Article> articleList = aArticleManager.GetArticleList();
List<Article> customArticlList = new List<Article>();
foreach (Article article in articleList)
{
Article customArticle = new Article();
customArticle.Id = article.Id;
string source = article.Description;
var reg = new Regex("src=(?:\"|\')?(?<imgSrc>[^>]*[^/].(?:jpg|bmp|gif|png))(?:\"|\')?");
var match = reg.Match(source);
if (match.Success)
{
string encod = match.Groups["imgSrc"].Value;
customArticle.Image = encod;
}
string strippedDescription = Regex.Replace(article.Description, "<.*?>", string.Empty);
int length = strippedDescription.Length;
if (length > 200)
{
length = 200;
}
string customDescription = strippedDescription.Substring(0, length);
customArticle.Description = customDescription;
customArticle.Title = article.Title;
customArticlList.Add(customArticle);
}
AllPost.DataSource = customArticlList;
AllPost.DataBind();
}
public List<Article> GetDetailArticle(string articleId)
{
SqlConnection connection = new SqlConnection(dbConnectionString);
string query = "SELECT * FROM tbl_article WHERE id = '" + articleId + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List<Article> articleList = new List<Article>();
while (reader.Read())
{
Article article = new Article();
article.Id = int.Parse(reader["id"].ToString());
article.Title = reader["title"].ToString();
article.PostUserName = reader["user_name"].ToString();
article.Description = reader["description"].ToString();
article.Date = reader["date"].ToString();
article.ArticleHitCount = int.Parse(reader["article_hit_count"].ToString());
articleList.Add(article);
}
reader.Close();
connection.Close();
return articleList;
}
public List<Article> GetArticleList()
{
SqlConnection connection = new SqlConnection(dbConnectionString);
string query = "SELECT TOP(5) * FROM tbl_article ORDER BY id DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List<Article> articleList = new List<Article>();
while (reader.Read())
{
Article article = new Article();
article.Id = int.Parse(reader["id"].ToString());
article.Title = reader["title"].ToString();
article.Description = reader["description"].ToString();
article.Date = reader["date"].ToString();
article.PostUserName = reader["user_name"].ToString();
articleList.Add(article);
}
reader.Close();
connection.Close();
return articleList;
}
public string Save(Article article)
{
if (articleGateway.Save(article) > 0)
{
return "Article Save Success";
}
else
{
return "Article Save Faild!";
}
}
protected void postArticle_Click(object sender, EventArgs e)
{
Article article = new Article();
article.Title = articletitleTextbox.Text;
article.Description = Request.Form["edit"];
article.Status = Request.Form["status"];
User sessionUser = (User)Session["user"];
article.PostUserName = sessionUser.Id.ToString();
//User aUser = (User)Session["user"];
//article.PostUserName = aUser.UserName;
//User aUser = userGateway.GetUserId();
//article.UserId = aUser.Id;
msg.InnerHtml = articleManager.Save(article);
//msg.InnerHtml = "Article Post Success";
}
public int Save(Article article)
{
SqlConnection connection = new SqlConnection(dbConnectionString);
string query = "INSERT INTO tbl_article(title,description,status,date,user_name,article_hit_count) VALUES ('" + article.Title +
"','" +
article.Description + "','" + article.Status + "','" + DateTime.Now + "','" + article.PostUserName + "','0')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowA = command.ExecuteNonQuery();
connection.Close();
return rowA;
}
