protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Get Recent Blog
DbParameter[] parameters = new DbParameter[1];
parameters = null;
DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters);
DataTable dtn = dt.Clone();
for (int i = 0; i < 3; i++)
{
dtn.ImportRow(dt.Rows[i]);
}
lstRecentPost.DataSource = dtn;
lstRecentPost.DataBind();
//Get Recent Tag
DbParameter[] paramTag = new DbParameter[1];
paramTag = null;
DataTable dtTag = AmplodisConnect.ExecuteStoredProcedure("sp_fetchTag", paramTag);
lstTag.DataSource = dtTag;
lstTag.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DbParameter[] parameters = new DbParameter[1];
if (Request.QueryString["ID"] != null)
{
parameters[0] = new SqlParameter("@Id", Request.QueryString["ID"].ToString());
parameters[0].Direction = ParameterDirection.Input;
parameters[0].DbType = DbType.String;
}
else
{
parameters = null;
}
DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters);
if (dt.Columns.Contains("Answer"))
{
lblDate.Text = dt.Rows[0]["AnswerDate"].ToString();
lblBlogName.Text = dt.Rows[0]["BlogName"].ToString();
lblDesc.Text = dt.Rows[0]["Answer"].ToString();
lblTagName.Text = dt.Rows[0]["TagName"].ToString();
imgUser.Src = dt.Rows[0]["ImageUrl"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblMsg.Text = "";
if (!IsPostBack)
{
DbParameter[] parameters = new DbParameter[1];
parameters = null;
DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters);
ddlBlog.DataSource = dt;
ddlBlog.DataValueField = "Id";
ddlBlog.DataTextField = "BlogName";
ddlBlog.DataBind();
}
}
protected void btnSaveAns_Click(object sender, EventArgs e)
{
DbParameter[] parameters = new DbParameter[2];
parameters[0] = new SqlParameter("@Answer", txtAnswer.Text);
parameters[0].Direction = ParameterDirection.Input;
parameters[0].DbType = DbType.String;
parameters[1] = new SqlParameter("@BlogId", ddlBlog.SelectedValue);
parameters[1].Direction = ParameterDirection.Input;
parameters[1].DbType = DbType.String;
AmplodisConnect.ExecuteNonQueryStoredProcedure("sp_insertAnswer", parameters);
lblMsg.Text = "Answer Saved Successfully";
txtAnswer.Text = "";
}
protected void btnSave_Click(object sender, EventArgs e)
{
DbParameter[] parameters = new DbParameter[3];
parameters[0] = new SqlParameter("@BlogName", txtBlog.Text);
parameters[0].Direction = ParameterDirection.Input;
parameters[0].DbType = DbType.String;
parameters[1] = new SqlParameter("@Description", txtDesc.Text);
parameters[1].Direction = ParameterDirection.Input;
parameters[1].DbType = DbType.String;
parameters[2] = new SqlParameter("@ParentId", null);
parameters[2].Direction = ParameterDirection.Input;
parameters[2].DbType = DbType.String;
AmplodisConnect.ExecuteNonQueryStoredProcedure("sp_insertBlogParentChildRelation", parameters);
lblMsg.Text = "Blog Saved Successfully";
txtBlog.Text = "";
txtDesc.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dtTag = AmplodisConnect.ExecuteStoredProcedure("sp_fetchTag", null);
String category = null;
foreach (DataRow DRow in dtTag.Rows)
{
category += "<a class='category-btn " + DRow["ClassName"] + "-btn' href='amplodis-forum.aspx?tid=" + DRow["TagId"] + "'>" + DRow["TagName"] + "</a>";
}
dvContainerTag.InnerHtml = category;
this.strClass = "all-blog";
DbParameter[] parameters = new DbParameter[1];
if (Request.QueryString["ID"] != null)
{
parameters[0] = new SqlParameter("@Id", Request.QueryString["ID"].ToString());
parameters[0].Direction = ParameterDirection.Input;
parameters[0].DbType = DbType.String;
}
else
{
parameters[0] = new SqlParameter("@TagId", Request.QueryString["tid"] == null || Request.QueryString["tid"] == "" ? null : Request.QueryString["tid"].ToString());
parameters[0].Direction = ParameterDirection.Input;
parameters[0].DbType = DbType.String;
}
DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters);
{
grdBlog.Visible = true;
grdBlog.DataSource = dt;
if (dt.Rows.Count > 0)
{
this.strClass = dt.Rows[0]["ClassName"].ToString();
grdBlog.DataBind();
}
}
}
}
