protected void btnAddPost_Click(object sender, EventArgs e)
{
String str;
str = edited_html.InnerText;
string mesag = str;
// we could save database in clean HTML
//System.Text.StringBuilder sb = new System.Text.StringBuilder(
// HttpUtility.HtmlEncode(str));
//string mesag = "";
//mesag = sb.ToString();
//convertHTMLcode conv = new convertHTMLcode();
//mesag = conv.convertHTMLtext(mesag);
blogpostsModel.blogdbEntities bl = new blogpostsModel.blogdbEntities();
if (s == null)
{
blogpostsModel.blogpost po = new blogpostsModel.blogpost();
//po.blogID = 3;
po.blogMsgText = mesag;
po.posted = DateTime.Now;
bl.AddToblogposts(po);
bl.SaveChanges();
}
else
{
int requestID2;
requestID2 = Convert.ToInt16(s);
blogpostsModel.blogpost ite = bl.blogposts.First(c => c.blogID == requestID2);
ite.blogMsgText = mesag;
ite.lastedited = DateTime.Now;
bl.SaveChanges();
}
try
{
FormsAuthentication.SignOut();
}
catch { }
Response.Redirect("blog.aspx");
}
protected void addComment(object sender, EventArgs e)
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
DataControlFieldCell Datafld = (DataControlFieldCell)row.Controls[0];
Label lbl = (Label)Datafld.Controls[1];
TextBox txtB = (TextBox)Datafld.Controls[3];
String stroka;
stroka = txtB.Text;
if (stroka.Trim().Length<1)
return;
System.Text.StringBuilder sb2 = new System.Text.StringBuilder(
HttpUtility.HtmlEncode(stroka));
string commm;
commm = sb2.ToString();
commm = Regex.Replace(commm, "\\n", "<br />", RegexOptions.IgnoreCase);
int commmID;
commmID = Convert.ToInt16(lbl.Text);
blogpostsModel.blogdbEntities bl = new blogpostsModel.blogdbEntities();
blogpostsModel.blogcomment po = new blogpostsModel.blogcomment();
po.commentID =commmID;
po.commentMsgText = commm;
bl.AddToblogcomments(po);
bl.SaveChanges();
Response.Redirect(Request.Path);
}
protected void Page_Load(object sender, EventArgs e)
{
s = Request.QueryString["id"];
if (s == null)
{
}
else
{
btnAddPost.Text ="Update post";
if (!Page.IsPostBack){
int requestID;
requestID = Convert.ToInt16(s);
blogpostsModel.blogdbEntities bl = new blogpostsModel.blogdbEntities();
blogpostsModel.blogpost ite = bl.blogposts.First(c => c.blogID == requestID);
string mesaga;
mesaga = ite.blogMsgText;
edited_html.Value = mesaga;
//ClientScriptManager cs = Page.ClientScript;
//String csName = "MyScript";
//Type csType = this.GetType();
//if (!cs.IsClientScriptBlockRegistered(csType, csName))
//{
// ClientScript.RegisterClientScriptBlock(csType, csName,
// "<script type=\"text/javascript\">" +
// "alert('fgfg');" +
// "</script>");
//}
}
}
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "RemoveRecord")
{
string lbltext;
try
{
int index = Convert.ToInt32(e.CommandArgument);
GridView gr = sender as GridView;
GridViewRow row = gr.Rows[index];
Label lbl = row.FindControl("cID") as Label;
lbltext = lbl.Text.Trim();
}
catch {
return;
}
blogpostsModel.blogdbEntities bl = new blogpostsModel.blogdbEntities();
blogpostsModel.blogcomment bc = new blogpostsModel.blogcomment();
// remove using command
string qStr = "Delete FROM blogcomments where cID="+lbltext;
bl.ExecuteStoreCommand(qStr);
bl.SaveChanges();
Response.Redirect(Request.Path);
}
}