public Int64 UpdateWebsite(DtoWebsite dtowebsite) { Int64 userid; try { sqlparameter = new SqlParameter[11]; sqlparameter[0] = new SqlParameter("@WebSiteName", dtowebsite.WebSiteName); sqlparameter[1] = new SqlParameter("@WebsiteURL", dtowebsite.WebsiteUrl); sqlparameter[2] = new SqlParameter("@WebsiteID", dtowebsite.WebsiteId); sqlparameter[3] = new SqlParameter("@UserID", dtowebsite.UserId); sqlparameter[4] = new SqlParameter("@AddTag", dtowebsite.AddTag); sqlparameter[5] = new SqlParameter("@RateTag", dtowebsite.RateTag); sqlparameter[6] = new SqlParameter("@AddEmotion", dtowebsite.AddEmotion); sqlparameter[7] = new SqlParameter("@Tag", dtowebsite.Tag); sqlparameter[8] = new SqlParameter("@Emotion", dtowebsite.Emotion); sqlparameter[9] = new SqlParameter("@WebsiteType", dtowebsite.WebsiteType); sqlparameter[10] = new SqlParameter("@Image", dtowebsite.WebsiteLogo); OpenConnection(); userid = Convert.ToInt64(ExecuteScalar(StoredProcedure.Names.spUpdateWebsite.ToString())); } catch (Exception error) { throw error; } finally { CloseConnection(); } return(userid); }
public List <DtoWebsite> GetIntellisense(string searchtext) { var lstDtoWebsites = new List <DtoWebsite>(); try { sqlparameter = new SqlParameter[1]; sqlparameter[0] = new SqlParameter("@searchtext", searchtext); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetIntellisense.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { DtoWebsite dtoWebsite = new DtoWebsite(); dtoWebsite.WebsiteId = Convert.ToInt64(datareader["Id"]); dtoWebsite.WebSiteName = datareader["Name"].ToString(); dtoWebsite.WebsiteType = datareader["Category"].ToString(); lstDtoWebsites.Add(dtoWebsite); } } catch (Exception error) { throw; } finally { CloseConnection(); } return(lstDtoWebsites); }
public DtoWebsite GetWebsiteByName(string name) { try { sqlparameter = new SqlParameter[1]; sqlparameter[0] = new SqlParameter("@WebsiteName", name); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetWebsiteByName.ToString()); _website = new DtoWebsite(); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website.WebsiteId = Convert.ToInt64(datareader["Id"].ToString()); _website.AddTag = Convert.ToBoolean(datareader["AddTag"].ToString()); _website.AddEmotion = Convert.ToBoolean(datareader["AddEmotion"].ToString()); _website.RateTag = Convert.ToBoolean(datareader["RateTag"].ToString()); _website.Emotion = Convert.ToBoolean(datareader["Emotion"].ToString()); _website.Tag = Convert.ToBoolean(datareader["Tag"].ToString()); } } catch (Exception error) { throw error; } finally { CloseConnection(); } return(_website); }
public List <DtoWebsite> GetWebsiteType() { try { _lstwebsite = new List <DtoWebsite>(); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetWebsiteType.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website = new DtoWebsite { WebsiteId = Convert.ToInt64(datareader["Id"].ToString()), WebSiteName = datareader["Type"].ToString() }; _lstwebsite.Add(_website); } } catch (Exception error) { throw; } finally { CloseConnection(); } return(_lstwebsite); }
public long RegisterWebsiteAndUser(DtoWebsite dtowebsite) { long userid = 0; try { sqlparameter = new SqlParameter[10]; sqlparameter[0] = new SqlParameter("@WebSiteName", dtowebsite.WebSiteName); sqlparameter[1] = new SqlParameter("@WebsiteURL", dtowebsite.WebsiteUrl); sqlparameter[2] = new SqlParameter("@Email", dtowebsite.WebsiteLogo); sqlparameter[3] = new SqlParameter("@Password", dtowebsite.Image); sqlparameter[4] = new SqlParameter("@VerificationCode", dtowebsite.WebsiteType); sqlparameter[5] = new SqlParameter("@isUser", dtowebsite.RateTag); OpenConnection(); userid = Convert.ToInt64(ExecuteScalar(StoredProcedure.Names.spRegisterWebsiteAndUser.ToString())); } catch (Exception error) { throw error; } finally { CloseConnection(); } return(userid); }
public string GetEmotion(string websitename, string premalink) { try { _websiteurl = new Uri(premalink); GetCookie(); _bltag = new BllTag(); _bllemo = new BllEmotions(); _bllwebsite = new BllWebsite(); _lsttag = new List <DtoTag>(); _lstemo = new List <DtoEmotions>(); _dtowebsite = new DtoWebsite(); _lstemo = _bllemo.GetAllEmotion(websitename, premalink, _userId); _dtowebsite = _bllwebsite.GetWebsiteByName(websitename); if (_dtowebsite != null) { ViewState["websiteid"] = _dtowebsite.WebsiteId; ViewState["addEmotion"] = _dtowebsite.AddEmotion; Emotionflag = _dtowebsite.Emotion; if (Emotionflag) { if (Convert.ToBoolean(ViewState["addEmotion"])) { deleteemoanchor.Style.Add("display", "inline"); addemoanchor.Style.Add("display", "inline"); } else { deleteemoanchor.Style.Add("display", "none"); addemoanchor.Style.Add("display", "none"); } } } var emotion = ""; if (_lstemo != null) { foreach (var emo in _lstemo) { emotion += "|" + emo.EmotionName + "," + emo.Emotionid + "," + emo.TotalCount + "," + emo.IsActive; } } return(emotion); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(null); }
protected void Page_Load(object sender, EventArgs e) { try { GetCookie(); if (!IsPostBack) { ViewState["websiteId"] = 0; ViewState["UserID"] = 0; _bllwebsite = new BllWebsite(); _blltag = new BllTag(); _bllemotions = new BllEmotions(); if (Request.QueryString["WebsiteId"] != null) { ViewState["websiteId"] = Convert.ToInt64(Request.QueryString["WebsiteId"]); Dtowebsite = _bllwebsite.GetWebsiteById(Convert.ToInt64(ViewState["websiteId"])); Lsttag = _blltag.GetTagByWebsite(Convert.ToInt64(ViewState["websiteId"])); Lstemotions = _bllemotions.GetEmotionByWebsite(Convert.ToInt64(ViewState["websiteId"])); if (Lsttag != null && Lsttag.Count > 0) { foreach (DtoTag t in Lsttag) { Tagstring += t.TagId + ","; } hdntagstring.Value = Tagstring; } if (Lstemotions != null && Lstemotions.Count > 0) { foreach (DtoEmotions E in Lstemotions) { Emostring += E.Emotionid + ","; } hdnemostring.Value = Emostring; } } } else { Response.Redirect("../Default.aspx"); } } catch (Exception ex) { ex.ToExceptionless().Submit(); } }
public long RegisterWebsite(DtoWebsite dtowebsite) { try { _dalwebsite = new DalWebsite(); return(_dalwebsite.RegisterWebsite(dtowebsite)); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(0); }
public Int64 UpdateWebsite(DtoWebsite dtowebsite) { try { _dalwebsite = new DalWebsite(); return(_dalwebsite.UpdateWebsite(dtowebsite)); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(0); }
public string GetTag(string websitename, string premalink) { try { _websiteurl = new Uri(premalink); _bltag = new BllTag(); _bllwebsite = new BllWebsite(); _lsttag = new List <DtoTag>(); _dtowebsite = new DtoWebsite(); _lsttag = _bltag.GetAllTag(websitename, premalink, _userId); _dtowebsite = _bllwebsite.GetWebsiteByName(websitename); if (_dtowebsite != null) { ViewState["websiteid"] = _dtowebsite.WebsiteId; ViewState["addTag"] = _dtowebsite.AddTag; ViewState["rateTag"] = _dtowebsite.RateTag; ViewState["addEmotion"] = _dtowebsite.AddEmotion; if (Convert.ToBoolean(ViewState["addTag"])) { Minusanchor.Style.Add("display", "inline"); addanchor.Style.Add("display", "inline"); } else { Minusanchor.Style.Add("display", "none"); addanchor.Style.Add("display", "none"); } } var tags = ""; if (_lsttag != null) { foreach (var tag in _lsttag) { tags += "|" + tag.TagName + "," + tag.TagId + "," + tag.TagCount + "," + tag.IsActive; } } _metaTagCheck = _lsttag != null && _lsttag[0].MetaTagCheck; return(tags); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(null); }
protected void btnwebregister_Click(object sender, EventArgs e) { var emailRegex = new Regex(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); var passwordRegex = new Regex("^([a-zA-Z0-9@*#]{8,15})$"); if (emailRegex.IsMatch(txtwebemail.Text) && passwordRegex.IsMatch(txtwebpassword.Text)) { var dtowebsite = new DtoWebsite { WebsiteLogo = txtwebemail.Text, Image = txtwebpassword.Text, RateTag = false, WebSiteName = txtwebsitename.Text, WebsiteUrl = txtwebsiteurl.Text, WebsiteType = Guid.NewGuid().ToString() }; var bllWebsite = new BllWebsite(); var flag = bllWebsite.RegisterWebsiteAndUser(dtowebsite); if (flag == -1) { lblwebauthentication.Text = "Email Already Exists"; lblwebauthentication.Visible = true; } else { var st = SendVerificationEmail(TxtLEmail.Text, _dtouser.Guid); if (st == false) { lblwebauthentication.Text = "Email Cannot be Sent at this Time."; lblwebauthentication.Visible = true; } else { lblwebauthentication.Text = "Please Verify Your Email"; lblwebauthentication.Visible = true; } } } else { lblwebauthentication.Text = "Incorrect Username Or Password"; lblwebauthentication.Visible = true; } }
public List <DtoWebsite> GetUserWebsite(Int64 userId) { _lstwebsite = new List <DtoWebsite>(); try { sqlparameter = new SqlParameter[1]; sqlparameter[0] = new SqlParameter("@UserID", userId); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetUserWebsite.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website = new DtoWebsite { WebsiteId = Convert.ToInt64(datareader["WebsiteID"].ToString()), WebSiteName = datareader["WebSiteName"].ToString(), WebsiteUrl = datareader["WebsiteURL"].ToString(), UserId = Convert.ToInt64(datareader["UserID"].ToString()), AddTag = Convert.ToBoolean(datareader["AddTag"].ToString()), AddEmotion = Convert.ToBoolean(datareader["AddEmotion"].ToString()), RateTag = Convert.ToBoolean(datareader["RateTag"].ToString()), Tag = Convert.ToBoolean(datareader["Tag"].ToString()), Emotion = Convert.ToBoolean(datareader["Emotion"].ToString()), WebsiteLogo = datareader["Image"].ToString() }; _lstwebsite.Add(_website); } } catch (Exception error) { throw error; } finally { CloseConnection(); } return(_lstwebsite); }
public DtoWebsite GetWebsiteById(Int64 websiteId) { try { sqlparameter = new SqlParameter[1]; sqlparameter[0] = new SqlParameter("@WebsiteID", websiteId); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetWebsiteById.ToString()); _website = new DtoWebsite(); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website.WebsiteId = Convert.ToInt64(datareader["WebsiteID"].ToString()); _website.WebSiteName = datareader["WebSiteName"].ToString(); _website.WebsiteUrl = datareader["WebsiteURL"].ToString(); _website.UserId = Convert.ToInt64(datareader["UserID"].ToString()); _website.AddTag = Convert.ToBoolean(datareader["AddTag"].ToString()); _website.AddEmotion = Convert.ToBoolean(datareader["AddEmotion"].ToString()); _website.RateTag = Convert.ToBoolean(datareader["RateTag"].ToString()); _website.Emotion = Convert.ToBoolean(datareader["Emotion"].ToString()); _website.Tag = Convert.ToBoolean(datareader["Tag"].ToString()); _website.WebsiteType = datareader["Type"].ToString(); _website.WebsiteLogo = datareader["Image"].ToString(); } } catch (Exception error) { throw error; } finally { CloseConnection(); } return(_website); }
public List <DtoWebsite> GetAllWebsite(long pageNumber, long rowsPerPage, string searchText) { try { sqlparameter = new SqlParameter[3]; sqlparameter[0] = new SqlParameter("@PageNumber", pageNumber); sqlparameter[1] = new SqlParameter("@RowsPerPage", rowsPerPage); sqlparameter[2] = new SqlParameter("@SearchText", searchText); _lstwebsite = new List <DtoWebsite>(); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetAllWebSite.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website = new DtoWebsite { WebsiteId = Convert.ToInt64(datareader["Id"].ToString()), WebSiteName = datareader["Name"].ToString(), Image = datareader["Image"].ToString() }; _lstwebsite.Add(_website); } } catch (Exception error) { throw; } finally { CloseConnection(); } return(_lstwebsite); }
public List <DtoWebsite> SearchWebsite(string prefixText) { try { sqlparameter = new SqlParameter[1]; sqlparameter[0] = new SqlParameter("@PrefixText", prefixText); _lstwebsite = new List <DtoWebsite>(); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spSearchWebsite.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _website = new DtoWebsite { WebsiteId = Convert.ToInt64(datareader["Id"]), WebSiteName = datareader["Name"].ToString() }; _lstwebsite.Add(_website); } } catch (Exception error) { throw error; } finally { CloseConnection(); } return(_lstwebsite); }
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(); } }
protected void Button1_Click1(object sender, EventArgs e) { try { _dtowebsite = new DtoWebsite(); _bllwebsite = new BllWebsite(); _dtowebsite.UserId = GetUserId(); _dtowebsite.WebSiteName = TextBox1.Text; _dtowebsite.WebsiteUrl = TextBox2.Text; _dtowebsite.WebsiteId = Convert.ToInt64(ViewState["websiteid"]); _dtowebsite.WebsiteType = dplstwebsitetype.SelectedValue; _dtowebsite.Tag = chktag.Checked; _dtowebsite.Emotion = chkemotion.Checked; if (chktag.Checked) { _dtowebsite.AddTag = chkaddable.Checked; _dtowebsite.RateTag = chkrateable.Checked; } else { chkaddable.Style.Add("display", "none"); chkrateable.Style.Add("display", "none"); } if (chkemotion.Checked) { _dtowebsite.AddEmotion = chkemoaddable.Checked; } else { chkemoaddable.Style.Add("display", "none"); } var isValidFile = false; if (ImgUpload.FileName != "") { string[] validFileTypes = { "bmp" }; var ext = Path.GetExtension(ImgUpload.PostedFile.FileName); for (var i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; _dtowebsite.WebsiteLogo = Guid.NewGuid() + "." + ext; ImgUpload.SaveAs(Server.MapPath("~/Images/WebsiteLogo/") + _dtowebsite.WebsiteLogo); break; } } if (!isValidFile) { lbluplderrmsg.Text = "Invalid File. Please upload a File with extension " + string.Join(",", validFileTypes); } } else { if (imgweblogo.ImageUrl == "") { _dtowebsite.WebsiteLogo = ConvertTextToImage(TextBox1.Text.Substring(0, 1).ToUpper(), "Arial", 30, Color.White, Color.Black, 50, 50); } isValidFile = true; } if (isValidFile) { int flag = Convert.ToInt16(_bllwebsite.UpdateWebsite(_dtowebsite)); switch (flag) { case -1: LblRegisterWebsite.Text = "Website URL Already Exists"; LblRegisterWebsite.Visible = true; break; case -2: LblRegisterWebsite.Text = "WebsiteName Already Exists"; LblRegisterWebsite.Visible = true; break; default: LblRegisterWebsite.Visible = false; Response.Redirect("../User/Setting.aspx"); break; } Response.Redirect("../User/Setting.aspx"); } } 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(); } }