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(); } }