public List <DtoPremalink> SearchPremalink(string premalink, long id)
{
_command = new SqlCommand(StoredProcedure.Names.spSearchPremalink.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@WebSiteID", SqlDbType.BigInt);
_command.Parameters.Add("@Link", SqlDbType.VarChar);
_command.Parameters[0].Value = id;
_command.Parameters[1].Value = premalink;
_lstpremalink = new List <DtoPremalink>();
_connection.Open();
_datareader = _command.ExecuteReader();
if (!_datareader.HasRows)
{
return(null);
}
while (_datareader.Read())
{
_premalink = new DtoPremalink
{
PremalinkId = Convert.ToInt64(_datareader["PremalinkID"]),
TagCount = Convert.ToInt64(_datareader["TagCount"]),
Link = _datareader["Link"].ToString()
};
_lstpremalink.Add(_premalink);
}
_connection.Close();
return(_lstpremalink);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
_premaLinkId = Convert.ToInt32(Request.QueryString["PremaLinkID"]);
_tagId = Convert.ToInt32(Request.QueryString["TagID"]);
_dtopremalink = new DtoPremalink
{
PremalinkId = _premaLinkId,
TagId = _tagId
};
_bllpremalink = new BllPremalink();
_bllpremalink.DeactivateTagToWebsite(_dtopremalink);
Response.Redirect("PremaLink.aspx?PremalinkID=" + _premaLinkId);
}
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
public long AddPremalink(DtoPremalink premalink)
{
_command = new SqlCommand(StoredProcedure.Names.spAddPremalink.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@Description", SqlDbType.VarChar);
_command.Parameters.Add("@Link", SqlDbType.VarChar);
_command.Parameters.Add("@Image", SqlDbType.VarChar);
_command.Parameters.Add("@Title", SqlDbType.VarChar);
_command.Parameters.Add("@Keywords", SqlDbType.VarChar);
_command.Parameters.Add("@Site_name", SqlDbType.VarChar);
_command.Parameters.Add("@Published_time", SqlDbType.DateTime);
_command.Parameters.Add("@WebSiteName", SqlDbType.VarChar);
_command.Parameters.Add("@WebSiteURL", SqlDbType.VarChar);
_command.Parameters[0].Value = premalink.Description;
_command.Parameters[1].Value = premalink.Link;
_command.Parameters[2].Value = premalink.Image;
_command.Parameters[3].Value = premalink.Title;
_command.Parameters[4].Value = premalink.Keywords;
_command.Parameters[5].Value = premalink.SiteName;
_command.Parameters[6].Value = premalink.PublishedTime;
_command.Parameters[7].Value = premalink.WebsiteName;
_command.Parameters[8].Value = premalink.WebSiteUrl;
_connection.Open();
long premalinkId = Convert.ToInt64(_command.ExecuteScalar().ToString());
_connection.Close();
return(premalinkId);
}
public List <DtoPremalink> GetTaggedpremaLink(int tagId, int pageNumber, int rowsPerPage)
{
try
{
_command = new SqlCommand(StoredProcedure.Names.spGetTaggedpremaLink.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@TagID", SqlDbType.Int);
_command.Parameters.Add("@PageNumber", SqlDbType.Int);
_command.Parameters.Add("@RowsPerPage", SqlDbType.Int);
_command.Parameters[0].Value = tagId;
_command.Parameters[1].Value = pageNumber;
_command.Parameters[2].Value = rowsPerPage;
_lstpremalink = new List <DtoPremalink>();
_connection.Open();
_datareader = _command.ExecuteReader();
if (!_datareader.HasRows)
{
return(null);
}
while (_datareader.Read())
{
_premalink = new DtoPremalink
{
PremalinkId = Convert.ToInt64(_datareader["PremalinkID"]),
TagName = _datareader["TagName"].ToString(),
TagId = Convert.ToInt64(_datareader["TagID"]),
Link = _datareader["Link"].ToString(),
Image = _datareader["Image"].ToString(),
Title = _datareader["Title"].ToString(),
SiteName = _datareader["Site_name"].ToString(),
Description = _datareader["Description"].ToString()
};
// if (datareader["Published_time"] != null && datareader["Published_time"].ToString() != "")
// premalink.PublishedTime = Convert.ToDateTime(datareader["Published_time"].ToString());
_lstpremalink.Add(_premalink);
}
}
catch (Exception error)
{
throw error;
}
finally
{
_connection.Close();
}
return(_lstpremalink);
}
public Int64 AddPremalink(DtoPremalink premalink)
{
try
{
_dalpremalink = new DalPremalink();
return(_dalpremalink.AddPremalink(premalink));
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
return(0);
}
public List <DtoPremalink> GetWebsitePremalink(DtoPremalink Premalink)
{
try
{
_dalpremalink = new DalPremalink();
return(_dalpremalink.GetWebsitePremalink(Premalink));
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
return(null);
}
public long DeactivateTagToWebsite(DtoPremalink Premalink)
{
try
{
_dalpremalink = new DalPremalink();
return(_dalpremalink.DeactivateTagToWebsite(Premalink));
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
return(0);
}
public List <DtoPremalink> GetUserNewsFeed(int userId, int currentPage, int totalRec)
{
_command = new SqlCommand(StoredProcedure.Names.GetUserNewsFeed.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@UserID", SqlDbType.BigInt);
_command.Parameters.Add("@pageno", SqlDbType.Int);
_command.Parameters.Add("@pagesize", SqlDbType.Int);
_command.Parameters[0].Value = userId;
_command.Parameters[1].Value = currentPage;
_command.Parameters[2].Value = totalRec;
_lstpremalink = new List <DtoPremalink>();
_connection.Open();
_datareader = _command.ExecuteReader();
if (!_datareader.HasRows)
{
return(null);
}
while (_datareader.Read())
{
_premalink = new DtoPremalink
{
PremalinkId = Convert.ToInt64(_datareader["PremalinkID"]),
TagName = _datareader["TagName"].ToString(),
WebsiteId = Convert.ToInt64(_datareader["WebsiteID"]),
Link = _datareader["Link"].ToString(),
Image = _datareader["Image"].ToString(),
Keywords = _datareader["Keywords"].ToString(),
Title = _datareader["Title"].ToString(),
Type = _datareader["Type"].ToString(),
Description = _datareader["Description"].ToString(),
TotalRec = Convert.ToInt32(_datareader["TotalRec"]),
TotalPage = Convert.ToInt32(_datareader["TotalPage"])
};
//premalink.TagID = Convert.ToInt64(datareader["TagID"]);
_lstpremalink.Add(_premalink);
}
_connection.Close();
return(_lstpremalink);
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
try
{
_dtopremalink = new DtoPremalink();
_bllpremalink = new BllPremalink();
_dtopremalink.WebsiteId = Convert.ToInt64(ViewState["websiteid"]);
_dtopremalink.Link = TxtSearch.Text;
GridPremalink.DataSource = _bllpremalink.GetWebsitePremalink(_dtopremalink);
GridPremalink.DataBind();
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
public static void done(object values)
{
try
{
String[] a = values.ToString().Replace('[', ' ').Replace(']', ' ').Split('|')[1].Split(',');
var pre = new DtoPremalink();
var bllp = new BllPremalink();
pre.Link = a[0];
pre.Image = a[1];
bllp.AddPremalinkimages(pre);
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
IsUser();
if (!IsPostBack)
{
ViewState["_premalinkId"] = 0;
ViewState["_websiteName"] = "";
ViewState["_link"] = "";
}
txttag.Attributes.Add("onblur", "blurfunction('tagsdfsspan','" + txttag.ClientID + "')");
if (Request.QueryString["PremaLinkID"] != null)
{
if (Convert.ToInt64(Request.QueryString["PremaLinkID"]) != 0)
{
ViewState["_premalinkId"] = Convert.ToInt64(Request.QueryString["PremaLinkID"]);
}
}
_bllpremalink = new BllPremalink();
GridPremalinkTags.DataSource =
_bllpremalink.GetPremalinkTagsById(Convert.ToInt64(ViewState["_premalinkId"]));
GridPremalinkTags.DataBind();
_dtopremalink = new DtoPremalink();
_dtopremalink = _bllpremalink.GetPremalinkById(Convert.ToInt64(ViewState["_premalinkId"]));
hperlnk.Text = _dtopremalink.Title;
hperlnk.NavigateUrl = "javascript:window.open('" + _dtopremalink.Link + "','_blank')";
lbldescription.Text = _dtopremalink.Description;
lbldate.Text = _dtopremalink.PublishedTime.ToShortDateString();
imglnk.ImageUrl = _dtopremalink.Image;
ViewState["_websiteName"] = _dtopremalink.SiteName;
ViewState["_link"] = _dtopremalink.Link;
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
public long AddPremalinkimages(DtoPremalink premalink)
{
_command = new SqlCommand(StoredProcedure.Names.spAddPremalinkimages.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@premalink", SqlDbType.VarChar);
_command.Parameters.Add("@imageurl", SqlDbType.VarChar);
_command.Parameters[0].Value = premalink.Link;
_command.Parameters[1].Value = premalink.Image;
_connection.Open();
long premalinkId = Convert.ToInt64(_command.ExecuteScalar().ToString());
_connection.Close();
return(premalinkId);
}
public List <DtoPremalink> GetUnParsedPremalik()
{
try
{
_command = new SqlCommand(StoredProcedure.Names.spGetUnParsedPremalik.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_lstpremalink = new List <DtoPremalink>();
_connection.Open();
_datareader = _command.ExecuteReader();
if (!_datareader.HasRows)
{
return(null);
}
while (_datareader.Read())
{
_premalink = new DtoPremalink
{
PremalinkId = Convert.ToInt64(_datareader["PremalinkID"]),
Link = _datareader["Link"].ToString(),
SiteName = _datareader["Site_name"].ToString(),
WebsiteId = Convert.ToInt64(_datareader["Website_Id"])
};
_lstpremalink.Add(_premalink);
}
}
catch (Exception error)
{
throw error;
}
finally
{
_connection.Close();
}
return(_lstpremalink);
}
public long DeactivateTagToWebsite(DtoPremalink premalink)
{
_command = new SqlCommand(StoredProcedure.Names.DeactivateTagToWebsite.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@PremaLinkID", SqlDbType.BigInt);
_command.Parameters.Add("@Link", SqlDbType.VarChar);
_command.Parameters.Add("@TagID", SqlDbType.BigInt);
_command.Parameters[0].Value = premalink.PremalinkId;
_command.Parameters[1].Value = premalink.Link;
_command.Parameters[2].Value = premalink.TagId;
_connection.Open();
long tagId = Convert.ToInt64(_command.ExecuteScalar().ToString());
_connection.Close();
return(tagId);
}
public DtoPremalink GetPremalinkById(long premalinkId)
{
_command = new SqlCommand(StoredProcedure.Names.spGetPremalinkById.ToString(), _connection)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add("@PremalinkId", SqlDbType.BigInt);
_command.Parameters[0].Value = premalinkId;
_lstpremalink = new List <DtoPremalink>();
_connection.Open();
_datareader = _command.ExecuteReader();
if (!_datareader.HasRows)
{
return(null);
}
while (_datareader.Read())
{
_premalink = new DtoPremalink
{
PremalinkId = Convert.ToInt64(_datareader["PremalinkID"]),
WebsiteId = Convert.ToInt64(_datareader["Website_Id"]),
Link = _datareader["Link"].ToString(),
WebsiteName = _datareader["Site_Name"].ToString(),
Image = _datareader["Image"].ToString(),
Title = _datareader["Title"].ToString(),
Type = _datareader["Type"].ToString(),
Description = _datareader["Description"].ToString(),
PublishedTime = Convert.ToDateTime(_datareader["CreatedOn"].ToString())
};
}
_connection.Close();
return(_premalink);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
IsWebSite();
ViewState["_premalinkId"] = 0;
if (!IsPostBack)
{
if (Request.QueryString["ID"] != null)
{
_premalinkId = Convert.ToInt64(Request.QueryString["ID"]);
}
ViewState["_premalinkId"] = _premalinkId;
_bllPremalink = new BllPremalink();
_dtoPremalink = _bllPremalink.GetPremalinkById(_premalinkId);
imgPremalink.ImageUrl = _dtoPremalink.Image;
lblPremalink.Text = _dtoPremalink.Title;
lblDescription.Text = _dtoPremalink.Description;
linkPremalink.Text = _dtoPremalink.Link;
ViewState["_link"] = _dtoPremalink.Link;
grdtags.DataSource = _bllPremalink.GetPremalinkTagsById(_premalinkId);
grdtags.DataBind();
// grdemotion.DataSource = _bllEmotions.GetPremalinkEmotionsById(_premalinkId);
// grdemotion.DataBind();
}
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
IsWebSite();
if (!IsPostBack)
{
_bllwebsite = new BllWebsite();
_dtowebsite = new DtoWebsite();
_dtopremalink = new DtoPremalink();
if (UserId > 0)
{
var isWebsite = _bllwebsite.GetUserWebsite(UserId);
if (isWebsite != null)
{
_dtowebsite = isWebsite[0];
ViewState["websiteid"] = _dtowebsite.WebsiteId;
TextBox1.Text = _dtowebsite.WebSiteName;
TextBox2.Text = _dtowebsite.WebsiteUrl;
chktag.Checked = _dtowebsite.Tag;
chkemotion.Checked = _dtowebsite.Emotion;
chkaddable.Checked = _dtowebsite.AddTag;
chkrateable.Checked = _dtowebsite.RateTag;
chkemoaddable.Checked = _dtowebsite.AddEmotion;
if (!string.IsNullOrEmpty(_dtowebsite.WebsiteLogo))
{
imgweblogo.ImageUrl = "../Images/WebsiteLogo/" + _dtowebsite.WebsiteLogo;
}
if (_dtowebsite.WebSiteName != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "shortnamespand",
"<script type='text/javascript'>document.getElementById('shortnamespan').style.opacity = 0;</script>");
}
if (_dtowebsite.WebsiteUrl != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "websitespand",
"<script type='text/javascript'>document.getElementById('websitespan').style.opacity = 0;</script>");
}
txtcode.InnerText = "<div id='taghead'></div><script type ='text/javascript' language='javascript'>"
+ "var Websitename_shortname = '" + _dtowebsite.WebSiteName +
"';</script>"
+
"<script src='http://www.glozzary.com/Script/NewJScript.js' type='text/javascript'></script>";
BtnDone.Visible = true;
BtnRegister.Visible = false;
dplstwebsitetype.DataSource = _bllwebsite.GetWebsiteType();
dplstwebsitetype.DataBind();
dplstwebsitetype.SelectedValue = _dtowebsite.WebsiteType;
_dtopremalink.WebsiteId = Convert.ToInt64(_dtowebsite.WebsiteId);
}
else
{
Response.Redirect("~/Default.aspx");
}
}
else
{
BtnRegister.Visible = true;
BtnDone.Visible = false;
dplstwebsitetype.DataSource = _bllwebsite.GetWebsiteType();
dplstwebsitetype.DataBind();
}
}
else
{
if (TextBox1.Text != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "shortnamespan",
"<script type='text/javascript'>document.getElementById('shortnamespan').style.opacity = 0;</script>");
}
if (TextBox2.Text != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "websitespans",
"<script type='text/javascript'>document.getElementById('websitespan').style.opacity = 0;</script>");
}
// if (TxtSearch.Text != "")
// Page.ClientScript.RegisterStartupScript(GetType(), "searchsspans",
// "<script type='text/javascript'>document.getElementById('searchsspan').style.opacity = 0;</script>");
}
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}
public List <DtoPremalink> GetWebSiteTaggedpremaLink(int Tag, int PageNumber, int RowsPerPage)
{
try
{
_dalpremalink = new DalPremalink();
_lstpremalink = new List <DtoPremalink>();
var templstpremalink = new List <DtoPremalink>();
DtoPremalink tempdtopremalink;
_lstpremalink = _dalpremalink.GetTaggedpremaLink(Tag, PageNumber, RowsPerPage);
if (_lstpremalink != null)
{
if (_lstpremalink.Count > 0)
{
IEnumerable <long> premalinkid = (from dto in _lstpremalink
select dto.PremalinkId).Distinct();
foreach (Int64 id in premalinkid)
{
tempdtopremalink = new DtoPremalink();
DtoPremalink lst = (from dto in _lstpremalink
where dto.PremalinkId == id
select dto).FirstOrDefault();
List <string> tags = (from dto in _lstpremalink
where dto.PremalinkId == id
select dto.TagName).ToList();
string tagnames = "";
foreach (string tagname in tags)
{
tagnames += tagname + ",";
}
tempdtopremalink.TagName = tagnames;
tempdtopremalink.Link = lst.Link;
tempdtopremalink.TagId = lst.TagId;
tempdtopremalink.PremalinkId = lst.PremalinkId;
tempdtopremalink.WebsiteId = lst.WebsiteId;
tempdtopremalink.Image = lst.Image;
tempdtopremalink.Description = lst.Description;
tempdtopremalink.Type = lst.Type;
tempdtopremalink.Title = lst.Title;
templstpremalink.Add(tempdtopremalink);
}
}
}
return(templstpremalink);
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
IsUser();
if (!IsPostBack)
{
ViewState["websiteid"] = 0;
_bllwebsite = new BllWebsite();
_dtowebsite = new DtoWebsite();
_dtopremalink = new DtoPremalink();
_bllpremalink = new BllPremalink();
TextBox1.Attributes.Add("onblur", "blurfunction('shortnamespan','" + TextBox1.ClientID + "')");
TextBox2.Attributes.Add("onblur", "blurfunction('websitespan','" + TextBox2.ClientID + "')");
TxtSearch.Attributes.Add("onblur", "blurfunction('searchsspan','" + TxtSearch.ClientID + "')");
if (Request.QueryString["WebsiteID"] != null &
Convert.ToInt64(Request.QueryString["WebsiteID"]) != 0)
{
ViewState["websiteid"] = Convert.ToInt64(Request.QueryString["WebsiteID"]);
_dtowebsite = _bllwebsite.GetWebsiteById(Convert.ToInt64(ViewState["websiteid"]));
TextBox1.Text = _dtowebsite.WebSiteName;
TextBox2.Text = _dtowebsite.WebsiteUrl;
chktag.Checked = _dtowebsite.Tag;
chkemotion.Checked = _dtowebsite.Emotion;
chkaddable.Checked = _dtowebsite.AddTag;
chkrateable.Checked = _dtowebsite.RateTag;
chkemoaddable.Checked = _dtowebsite.AddEmotion;
if (!string.IsNullOrEmpty(_dtowebsite.WebsiteLogo))
{
imgweblogo.ImageUrl = Server.MapPath("~/Images/WebsiteLogo/") + _dtowebsite.WebsiteLogo;
}
if (_dtowebsite.WebSiteName != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "shortnamespand",
"<script type='text/javascript'>document.getElementById('shortnamespan').style.opacity = 0;</script>");
}
if (_dtowebsite.WebsiteUrl != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "websitespand",
"<script type='text/javascript'>document.getElementById('websitespan').style.opacity = 0;</script>");
}
txtcode.InnerText = "<div id='taghead'></div><script type ='text/javascript' language='javascript'>"
+ "var Websitename_shortname = '" + _dtowebsite.WebSiteName + "';</script>"
+
"<script src='http://www.glozzary.com/Script/NewJScript.js' type='text/javascript'></script>";
BtnDone.Visible = true;
BtnRegister.Visible = false;
dplstwebsitetype.DataSource = _bllwebsite.GetWebsiteType();
dplstwebsitetype.DataBind();
dplstwebsitetype.SelectedValue = _dtowebsite.WebsiteType;
_dtopremalink.WebsiteId = Convert.ToInt64(ViewState["websiteid"]);
_dtopremalink.Link = TxtSearch.Text;
GridPremalink.DataSource = _bllpremalink.GetWebsitePremalink(_dtopremalink);
GridPremalink.DataBind();
}
else
{
BtnRegister.Visible = true;
BtnDone.Visible = false;
dplstwebsitetype.DataSource = _bllwebsite.GetWebsiteType();
dplstwebsitetype.DataBind();
}
}
else
{
if (TextBox1.Text != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "shortnamespan",
"<script type='text/javascript'>document.getElementById('shortnamespan').style.opacity = 0;</script>");
}
if (TextBox2.Text != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "websitespans",
"<script type='text/javascript'>document.getElementById('websitespan').style.opacity = 0;</script>");
}
if (TxtSearch.Text != "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "searchsspans",
"<script type='text/javascript'>document.getElementById('searchsspan').style.opacity = 0;</script>");
}
}
}
catch (Exception ex)
{
ex.ToExceptionless().Submit();
}
}