protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (!this.IsPostBack)
{
username = this.Page.User.Identity.Name;
DataTable dt = GetProfile();
GetMergedAll.DataSource = dt;
ViewState["DataTable"] = dt;
GetMergedAll.DataSource = dt;
GetMergedAll.DataBind();
// if (dt.Rows.Count > 0)
{
}
}
}
}
public DataTable GetProfile()
{
SqlConnection constr = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlDataAdapter adp = new SqlDataAdapter("GetUserPOSTS", constr);
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
// adp.SelectCommand.Parameters.AddWithValue("@Email", username);
adp.SelectCommand.Parameters.AddWithValue("@UserName", username);
adp.SelectCommand.Parameters.AddWithValue("@Id", Id);
DataTable dt = new DataTable();
//
adp.Fill(dt);
return dt;
}
protected void linkbtn_Click(object sender, EventArgs e)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
}
protected void GetMergedAll_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "SharePost")
{
int index = Convert.ToInt32(e.CommandArgument);
DataTable dt = (DataTable)ViewState["DataTable"];
IEnumerable<DataRow> query = from i in dt.AsEnumerable()
where i.Field<int>("Id").Equals(index)
select i;
DataTable detailTable = query.CopyToDataTable();
SharePost.DataSource = detailTable;
SharePost.DataBind();
}
}
protected void btnSharenow_Click(object sender, EventArgs e)
{
string modelId = (SharePost.Row.FindControl("lblModalId") as Label).Text;
string userName = (SharePost.Row.FindControl("lblUserName") as Label).Text;
string fuserName = (SharePost.Row.FindControl("lblfUserName") as Label).Text;
string contentPost = (SharePost.Row.FindControl("lblpost") as Label).Text;
string comment = (SharePost.Row.FindControl("txtcommentshare") as TextBox).Text;
string img = (SharePost.Row.FindControl("Image2") as System.Web.UI.WebControls.Image).ImageUrl;
string img2 = (SharePost.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl;
string fname = (SharePost.Row.FindControl("lblfname") as Label).Text;
DateTime sendDate = DateTime.Now;
InsertDatabase(userName, fuserName, contentPost, sendDate, modelId, comment, img, img2, fname);
sb.Append(@"<script type='text/javascript'>");
sb.Append("$(function () {");
sb.Append(" $('#myModal9t').modal('hide');});");
sb.Append("</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModelScript", sb.ToString(), false);
}
private void InsertDatabase(string userName, string fuserName, string contentPost, DateTime sendDate, string modelId, string comment, string img, string img2, string fname )
{
using (SqlConnection con = new SqlConnection(constrr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO USERPost VALUES(@UserName,@FriendUserName,@ContentPost,@SendDate,@ShareId,@Comments,@ImageName3,@ImageName1,@fName,@TotalCount)", con))
{
// cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@UserName", username = this.Page.User.Identity.Name);
cmd.Parameters.AddWithValue("@FriendUserName", userName);
cmd.Parameters.AddWithValue("@ContentPost", contentPost);
cmd.Parameters.AddWithValue("@SendDate", sendDate);
cmd.Parameters.AddWithValue("@ShareId", modelId);
cmd.Parameters.AddWithValue("@Comments", comment);
cmd.Parameters.AddWithValue("@ImageName3", img);
cmd.Parameters.AddWithValue("@ImageName1", img2);
cmd.Parameters.AddWithValue("@fName", fname);
cmd.Parameters.AddWithValue("@TotalCount", comment);
// cmd.Parameters.AddWithValue("@ADStatus", comment);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
html model pop up
<!-- Trigger the modal with a button --><!-- Modal share POST MODAL -->
<div class="modal fade" id="myModal9t" role="dialog" style="display: none" data-backdrop="static" >
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="buttonclose" class="close" data-dismiss="modal">×</button><h4 class="modal-title" style="color: #999999">Pass To Your Followers? </h4><div class="" >
</div>
</div>
<asp:UpdatePanel ID="UpdatePanel2model" runat="server">
<ContentTemplate>
<asp:FormView ID="SharePost" runat="server" CssClass=" ">
<ItemTemplate>
<div class="modal-body" style="background-color:#e8f5fd;">
<asp:TextBox ID="txtcommentshare" runat="server" placeholder="Add Comment... " TextMode="MultiLine" CssClass="form-control" Rows="1" Font-Bold="False" Font-Names="Comic Sans MS" ></asp:TextBox></div><div class="modal-body" style="">
<!-- Conversations are loaded here --><div class="">
<!-- Message. Default to the left -->
<div class="" style="margin-bottom:1px; margin-left:8px; margin-top:8px; margin-right:8px">
<div class="">
<div class="" style="margin-bottom:1px; margin-top:1px">
<div class="" style="margin-top:2px;margin-bottom:2px; font-variant-caps:titling-caps">
<div class="">
<div class="" style="margin-bottom:1px; margin-top:1px">
<div >
<div class="dropdown">
<ul class="media-list" style="margin-bottom:2px;">
<li class="media" style="margin-bottom:2px;">
<i class="pull-right" style="" >
<i class="" style="color: #999999"></i>
<a href="#" class="dropdown-toggle " data-toggle="dropdown" ><asp:Label ID="Label15" runat="server" CssClass="fa fa-chevron-down"></asp:Label></a><ul class="dropdown-menu" role="menu" style="font-style: normal">
<li><a href="#"><i class="fa fa-warning"></i>Report Post</a></li><li class="divider"></li>
<li><a href="#"><i class="fa fa-bookmark-o"></i>Save Post</a></li><li class="divider"></li>
<li><a href="#"><i class="fa fa-copy"></i>Copy link</a></li><li class="divider"></li>
<li>
<asp:LinkButton ID="btndeletepost" runat="server"> <i class="glyphicon glyphicon-erase"></i>Delete</asp:LinkButton></li></ul></i><a class="pull-left" href='<%#getUserHREF05(Container.DataItem)%>' style="margin-bottom:2px;"><asp:image ID="Image2" runat="server" src='<%#getSRCfuser(Container.DataItem)%>' CssClass="media-object img-rounded animated fadeInDown" Width="45px" Height="45px" data-toggle="tooltip" title="Profile Photo" alt="" />
</a>
<div class="media-body" style="margin-bottom:2px">
<h5 class="" style="margin-bottom:2px;margin-top:2px ">
<a class="pull-left" href='<%#getUserHREF1(Container.DataItem)%>'>
<asp:Label ID="lblfname" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Name") %>' Font-Bold="True " ForeColor="#666666" Font-Size="Larger" />
<asp:Label ID="lblModalId" runat="server" Text='<%#Eval("Id") %>' Font-Bold="True " ForeColor="" Font-Size="" Visible="False" />
<asp:Label ID="lblfUserName" runat="server" Text='<%#Eval("FriendUserName") %>' Font-Bold="True " ForeColor="" Font-Size="" Visible="False" />
<asp:Label ID="lblUserName" runat="server" Text='<%#Eval("UserName") %>' Font-Bold="True " ForeColor="" Font-Size="" Visible="False" />
<asp:Label ID="Label7" runat="server" CssClass="fa fa-check-circle verified-color" data-toggle="tooltip" title="" data-original-title="Verified Account"></asp:Label></a><div class="clearfix" ></div>
<i style="margin-right:2px; margin-left:2px; color:Silver; " class="fa fa-clock-o"></i> <asp:Label ID="Label25" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "SendDate","{0:MMM dd,yyyy}" ) %>' Font-Size="Smaller" ForeColor="Gray" />
<a class="" href='<%#getUserHREF1(Container.DataItem)%>' style="margin-left:2px;">
<div class="clearfix"></div>
<asp:Label ID="Label28" runat="server" CssClass="fa fa-star" ForeColor="gold" Font-Size="Small"></asp:Label><asp:Label ID="Label29" runat="server" CssClass="fa fa-star-half" ForeColor="gold" Font-Size="Small"></asp:Label><asp:Label ID="Label30" runat="server" CssClass="fa fa-star-half" ForeColor="gold" Font-Size="Small"></asp:Label><asp:Label ID="Label31" runat="server" CssClass="fa fa-star-o" ForeColor="gold" Font-Size="Small"></asp:Label><asp:Label ID="Label32" runat="server" CssClass="fa fa-star-o" ForeColor="gold" Font-Size="Small"></asp:Label></a><br /><div class="clearfix" ></div>
</h5>
</div>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
<a class="" href='<%#getUserHREF05(Container.DataItem)%>'>
<h4 style="margin-bottom:4px">
</h4>
<asp:Label ID="lblpost" runat="server" Text='<%# Eval("ContentPost").ToString().Length >180 ? Eval("ContentPost").ToString().Substring(0,180)+"...(Read More)" : Eval("ContentPost").ToString()%>' Font-Names="Comic Sans MS" Font-Bold="False" Font-Strikeout="False" ForeColor="#333333">
</asp:Label></a><div class="clearfix"></div>
<a class="" href='<%#getUserHREF05(Container.DataItem)%>'>
<asp:Image ID="Image1" runat="server" src='<%#getSRCDD(Container.DataItem)%> ' class="" style=" width:30% " alt="" data-aria-label-part="" />
<span class="icon-focus"></span>
</a>
</div></div></div><!--/.direct-chat-messages--><!-- Contacts are loaded here --></div><!-- /.box-body --><div class="col-sm-12">
<div id="" class="">
</div>
</div>
</div>
</ItemTemplate>
</asp:FormView>
</ContentTemplate>
<triggers>
<asp:PostBackTrigger ControlID="GetMergedAll" />
</triggers>
</asp:UpdatePanel>
<div class="clearfix"></div>
<div class="modal-footer">
<asp:LinkButton ID="btnSharenow" runat="server" CssClass=" btn-twitter btn-lg" BorderColor="#003399" OnClick="btnSharenow_Click" >
<asp:Label ID="Label26" runat="server" Text="" CssClass=" fa fa-rotate-right" Font-Size="X-Large"></asp:Label>
<i style="margin-left:1px"></i>
<asp:Label ID="Label27" runat="server" Text="Pass Now" Font-Size="Medium" Font-Bold="True"></asp:Label>
</asp:LinkButton></div></div>
</div>
</div><!-- Trigger the modal with a button --><!-- Modal share category -->