protected void DeleteDraftButton_Click(object sender, EventArgs e) { if (CurrentUser.UserType == (byte)MemberTypeType.Admin) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { var posts = (from t in dc.Posts where t.Status == (byte)PostStatusType.Draft && (t.CreatedBy == CurrentUser.ID || CurrentUser.UserType == (byte)MemberTypeType.Admin) select t); foreach (Post p in posts) { if (p != null && p.Status == (byte)PostStatusType.Draft) { try { System.IO.File.Delete(Server.MapPath(string.Format("{1}/articlexml-{0}.txt", p.ID, Utility.CustomPageFolder))); dc.Posts.DeleteOnSubmit(p); dc.SubmitChanges(); } catch (Exception iex) { Trace.Write("Unable to delete article file."); Trace.Write(iex.Message); Trace.Write(iex.StackTrace); Trace.Write(iex.Source); } } } } } }
public static void RecordPulse(Guid vid, long pageid) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext()) { dc.ExecuteCommand("UPDATE dbo.PageVisit Set LastHeartBeat = GETUTCDATE() WHERE ID = " + pageid); } }
protected void Page_Load(object sender, EventArgs e) { if (Mode == "edit") { //redirect if user is not admin or dont own the article using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { Post p = (from t in dc.Posts where t.ID == ID && (t.CreatedBy == CurrentUser.ID || CurrentUser.UserType == (byte)MemberTypeType.Admin) select t).SingleOrDefault(); if (p == null) { Response.Redirect("default.aspx"); } } HeadingLit.Text = "Edit Article"; //PopulateArticle(); } if (!Page.IsCallback && !Page.IsPostBack) { TemplateDropDown.Items.Clear(); TemplateDropDown.Items.Add(new ListItem("-- Select --", "")); using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { foreach (CustomDataSource item in dc.CustomDataSources) { TemplateDropDown.Items.Add(new ListItem(item.Name, item.Name)); } } if (Mode == "edit") { PopulateForm(); } } }
public static bool UpdateMessage(EmailMessage em) { try { using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { EmailMessage item = (from u in db.EmailMessages where u.ID == em.ID select u).SingleOrDefault(); item.CreateDate = em.CreateDate; item.EmailGroup = em.EmailGroup; item.EmailType = em.EmailType; item.FromAddress = em.FromAddress; item.IsRead = em.IsRead; item.IsSent = em.IsSent; item.Message = em.Message; item.SentDate = em.SentDate; item.Subject = em.Subject; item.ToAddress = em.ToAddress; item.ReadDate = em.ReadDate; db.SubmitChanges(); return(true); } } catch (Exception ex) { HttpContext.Current.Trace.Write("Unable to save EmailMessage object to database."); HttpContext.Current.Trace.Write(ex.Message); HttpContext.Current.Trace.Write(ex.StackTrace); return(false); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "TopStory") { try { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { TopStory ts = new TopStory(); ts.CreatedBy = CurrentUser.ID; ts.DateCreated = DateTime.UtcNow; ts.PostId = long.Parse(e.CommandArgument.ToString()); dc.TopStories.InsertOnSubmit(ts); dc.SubmitChanges(); Response.Redirect("topstory.aspx"); } } catch (Exception ex) { message1.Text = string.Format("Unable to set top story. Error - {0}", ex.Message); message1.Visible = true; message1.Indicate = AlertType.Error; Trace.Write("Unable to set top story."); Trace.Write(ex.Message); Trace.Write(ex.StackTrace); } } else if (e.CommandName == "DeleteCommand") { } }
protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { if (Mode == "edit") { Post p = (from t in dc.Posts where t.ID != ID && t.URL == URLTextBox.Text.Trim() select t).SingleOrDefault(); if (p != null) { args.IsValid = false; } else { args.IsValid = true; } } else { Post p = (from t in dc.Posts where t.URL == URLTextBox.Text.Trim() select t).SingleOrDefault(); if (p != null) { args.IsValid = false; } else { args.IsValid = true; } } } }
protected void SubmitButton_Click(object sender, EventArgs e) { Page.Validate("CategoryGrp"); if (!Page.IsValid) { return; } try { using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { WebsiteSetting rs = (from u in db.WebsiteSettings where u.KeyName == "NewsletterDesign" select u).SingleOrDefault(); rs.KeyValue = KeyValueTextBox.Text.Trim(); db.SubmitChanges(); CacheManager.Remove("NewsletterDesign"); message1.Text = "Saved Successfuly"; message1.Visible = true; message1.Indicate = AlertType.Success; } } catch (Exception ex) { message1.Text = "Unable to save NewsletterDesign"; message1.Visible = true; message1.Indicate = AlertType.Error; Trace.Write("Unable to save NewsletterDesign."); Trace.Write(ex.Message); Trace.Write(ex.StackTrace); } }
protected void Page_Load(object sender, EventArgs e) { if (Mode == "edit") { //redirect if user is not admin or dont own the article using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { Post p = (from t in dc.Posts where t.ID == ID && (t.CreatedBy == CurrentUser.ID || CurrentUser.UserType == (byte)MemberTypeType.Admin) select t).SingleOrDefault(); if (p == null) { Response.Redirect("default.aspx"); } } HeadingLit.Text = "Edit"; //PopulateArticle(); } if (!Page.IsCallback && !Page.IsPostBack) { if (Mode == "edit") { PopulateForm(); } } }
protected void DeleteButton_Click(object sender, EventArgs e) { using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { string query = "Delete FROM [EmailMessage] WHERE 1=1 "; if (TypeDropDown.SelectedValue != "") { query = string.Format("{0} AND([EmailType] = {1})", query, TypeDropDown.SelectedValue); } if (GroupDropDown.SelectedValue != "") { query = string.Format("{0} AND(EmailGroup = '{1}')", query, GroupDropDown.SelectedValue); } if (SentDropDown.SelectedValue != "") { query = string.Format("{0} AND([IsSent] = {1})", query, SentDropDown.SelectedValue); } if (ReadDropDown.SelectedValue != "") { query = string.Format("{0} AND([IsRead] = {1})", query, ReadDropDown.SelectedValue); } //query = string.Format("{0} ORDER BY CreateDate desc ", query); db.ExecuteCommand(query, new object[] { }); Bind(0); } }
public CustomDataSource GetByName(string name) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { return((from t in dc.CustomDataSources where t.Name == name select t).SingleOrDefault <CustomDataSource>()); } }
public CustomDataSource GetById(int id) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { return((from t in dc.CustomDataSources where t.ID == id select t).SingleOrDefault <CustomDataSource>()); } }
protected void SubmitButton_Click(object sender, EventArgs e) { Page.Validate("PageGrp"); if (!Page.IsValid) { return; } using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { try { cp.Status = (PostStatusType)Enum.Parse(typeof(PostStatusType), StatusDropDown.SelectedValue); cp.Body = BodyTextBox.Text.Trim(); cp.Name = Utility.Slugify(NameTextBox.Text.Trim()); cp.Title = TitleTextBox.Text.Trim(); cp.Head = HeadTextBox.Text.Trim(); cp.NoTemplate = NoTemplateCheckBox.Checked; cp.PageMeta = PageMetaTextBox.Text.Trim(); if (Mode == "edit") { cp.DateModified = DateTime.Now; cp.ModifiedByName = CurrentUser.MemberName; cp.ModifiedBy = CurrentUser.ID; CustomPage p = (from u in dc.CustomPages where u.ID == ID select u).SingleOrDefault(); p.DateModified = cp.DateModified; p.ModifiedBy = cp.ModifiedBy; p.Name = cp.Name; p.Status = (byte)cp.Status; dc.SubmitChanges(); } else { cp.DateCreated = DateTime.Now; cp.CreatedByName = CurrentUser.MemberName; cp.CreatedBy = CurrentUser.ID; CustomPage p = new CustomPage(); p.DateCreated = cp.DateCreated; p.CreatedBy = cp.CreatedBy; p.Name = cp.Name; p.Status = (byte)cp.Status; dc.CustomPages.InsertOnSubmit(p); dc.SubmitChanges(); cp.ID = p.ID; } string str = Utility.Serialize <CPage>(cp); System.IO.File.WriteAllText(Server.MapPath(string.Format("{1}/cpagexml-{0}.txt", cp.ID, Utility.CustomPageFolder)), str); Response.Redirect("custompagelist.aspx"); } catch (Exception ex) { Trace.Write("Unable to save page details."); Trace.Write(ex.Message); Trace.Write(ex.StackTrace); } } }
private void PopulateArticle() { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { try { Post p = (from t in dc.Posts where t.ID == ID select t).SingleOrDefault(); if (p != null) { a = Utility.Deserialize <Article>(p.Article); //Utility.Deserialize<Article>(System.IO.File.ReadAllText(Server.MapPath(string.Format("{1}/articlexml-{0}.txt", ID, Utility.ArticleFolder)))); if (string.IsNullOrEmpty(a.MetaTitle)) { a.MetaTitle = a.Title; } a.URL = p.URL; } } catch (Exception ex) { a = new Article(); Trace.Write("Unable to read xml file of article."); Trace.Write(ex.Message); Trace.Write(ex.StackTrace); Post p = (from t in dc.Posts where t.ID == ID select t).SingleOrDefault(); if (p != null) { a.Category = p.Category; a.CreatedBy = p.CreatedBy; a.DateCreated = p.DateCreated; a.DateModified = p.DateModified; a.Description = p.Description; a.ID = p.ID; a.ModifiedBy = p.ModifiedBy; a.Status = (PostStatusType)Enum.Parse(typeof(PostStatusType), p.Status.ToString()); a.Tag = p.Tag; a.Title = p.Title; a.WriterEmail = p.WriterEmail; a.WriterName = p.WriterName; a.Viewed = p.Viewed; a.URL = p.URL; try { a.Text = System.IO.File.ReadAllText(Server.MapPath(string.Format("{1}/article-{0}.txt", p.ID, Utility.ArticleFolder))); } catch (Exception ex2) { Trace.Write(ex2.Message); Trace.Write(ex2.StackTrace); } } else { Response.Redirect("default.aspx"); } } } }
public static bool ChangePassword(long id, string password) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { Member m = (from u in dc.Members where u.ID == id select u).SingleOrDefault(); m.Password = password; dc.SubmitChanges(); return(true); } }
public bool Delete(int id) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CustomDataSource item = (from t in dc.CustomDataSources where t.ID == id select t).SingleOrDefault <CustomDataSource>(); dc.CustomDataSources.DeleteOnSubmit(item); dc.SubmitChanges(); return(true); } }
public static int GetArticleCount() { if (CacheManager.Get <int?>("ArticleCount") == null) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CacheManager.Add("ArticleCount", (from t in dc.Posts where t.Status != (byte)PostStatusType.Inactive select t).Count(), DateTime.Now.AddMinutes(5)); } } return(CacheManager.Get <int?>("ArticleCount").Value); }
protected void Page_Load(object sender, EventArgs e) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { var query = from t in dc.Categories where t.Posts.Count() > 0 && t.Status == (byte)GeneralStatusType.Active select t; CategoryList = new List <Category>(); CategoryList.AddRange(query); } }
public static int GetDraftCommentCount() { if (CacheManager.Get <int?>("DraftCommentCount") == null) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CacheManager.Add("DraftCommentCount", (from t in dc.PageComments where t.Status == (byte)PostStatusType.Draft select t).Count(), DateTime.Now.AddMinutes(1)); } } return(CacheManager.Get <int?>("DraftCommentCount").Value); }
public static int GetMemberCount() { if (CacheManager.Get <int?>("MemberCount") == null) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CacheManager.Add("MemberCount", (from t in dc.Members where t.Status == (byte)GeneralStatusType.Active select t).Count(), DateTime.Now.AddMinutes(50)); } } return(CacheManager.Get <int?>("MemberCount").Value); }
public static List <Category> CategoryList() { if (CacheManager.Category.Count == 0) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CacheManager.Category = (from t in dc.Categories select t).ToList <Category>(); } } return(CacheManager.Category); }
protected void SendActivationEmailButton_Click(object sender, EventArgs e) { using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { Member m = (from u in db.Members where u.ID == ID select u).SingleOrDefault(); if (m != null) { EmailManager.SendActivationEmail(m.Email, m.MemberName, m.Password); } } }
private void PopulateParent() { ParentDropDown.Items.Clear(); ParentDropDown.Items.Add(new ListItem("--select--", "")); using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { var items = from u in dc.Categories where u.Status != (byte)GeneralStatusType.Deleted select u; foreach (Category c in items) { ParentDropDown.Items.Add(new ListItem(c.Name, c.ID.ToString())); } } }
public bool Update(int id, string name, string query, string template, long memberid) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CustomDataSource item = (from t in dc.CustomDataSources where t.ID == id select t).SingleOrDefault <CustomDataSource>(); item.Name = name; item.Query = query; item.HtmlTemplate = template; item.ModifiedBy = memberid; item.DateModified = DateTime.Now; dc.SubmitChanges(); return(true); } }
public static List <Member> GetMemberList() { try { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { return((from u in dc.Members where u.Status != (byte)GeneralStatusType.Deleted orderby u.Createdate descending select u).ToList <Member>()); } } catch { throw; } }
public static Member GetUser(int id) { try { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { return((from t in dc.Members where t.ID == id select t).SingleOrDefault()); } } catch { throw; } }
protected void ArticleButton_Click(object sender, EventArgs e) { try { StringBuilder builder = new StringBuilder(); using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { builder.Append("<ul style='list-style:none;'>\r\n"); foreach (ListItem item in ArticleList.Items) { if (item.Selected) { Post p = (from u in db.Posts where u.ID == int.Parse(item.Value) select u).SingleOrDefault(); if (p != null) { builder.Append("<li style='text-align:center;border-bottom:1px solid Gainsboro;margin-bottom:5px;'>"); builder.Append(Environment.NewLine); builder.Append(string.Format("<a href='{0}/a/{1}?ref=newsletter'>", Utility.SiteURL, p.URL)); if (p.OGImage.StartsWith("//")) { p.OGImage = "https:" + p.OGImage; } builder.Append(string.Format("<img src='{0}' style='max-width:600px;max-height:250px;width:auto;border:0px;' alt=''/>", p.OGImage)); builder.Append("</a>"); builder.Append(Environment.NewLine); builder.Append(string.Format("<a href='{1}/a/{2}?ref=newsletter' style='color:#000;'><h3>{0}</h3></a>\r\n", p.Title, Utility.SiteURL, p.URL, p.Title)); builder.Append(Environment.NewLine); builder.Append(string.Format("<p>{0} story written by {1}</p>", p.Category1.Name, p.WriterName)); builder.Append(Environment.NewLine); builder.Append(string.Format("<p>{0}</p>", p.OGDescription)); builder.Append("</li>"); //builder.Append("\t<li><hr/></li>\r\n"); } } } builder.Append("</ul>\r\n"); } KeyValueTextBox.Text = builder.ToString(); } catch (Exception ex) { message1.Text = "Unable to select article"; message1.Visible = true; message1.Indicate = AlertType.Error; Trace.Write("Unable to select article"); Trace.Write(ex.Message); Trace.Write(ex.StackTrace); } }
public static Member GetUser(string username) { try { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { return((from t in dc.Members where (t.Email == username || t.UserName == username) && t.Status != (byte)GeneralStatusType.Deleted select t).SingleOrDefault()); } } catch { throw; } }
public bool Add(string name, string query, string template, long memberid) { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext(Utility.ConnectionString)) { CustomDataSource item = new CustomDataSource(); item.Name = name; item.Query = query; item.HtmlTemplate = template; item.DateCreated = DateTime.Now; item.CreatedBy = memberid; dc.CustomDataSources.InsertOnSubmit(item); dc.SubmitChanges(); return(true); } }
private void GetRating() { using (RockyingDataClassesDataContext dc = new RockyingDataClassesDataContext()) { Post p = dc.Posts.FirstOrDefault(t => t.ID == PPM.Item.ID); if (p != null) { var ratingcount = dc.StarRatings.Count(t => t.PostID == p.ID); if (ratingcount > 0) { var totalrating = dc.StarRatings.Where(t => t.PostID == p.ID).Sum(t => t.Stars); PostRating = totalrating / ratingcount; } } } }
protected void btnDeleteRecords_Click(object sender, EventArgs e) { foreach (GridViewRow row in MemberGridView.Rows) { if ((row.FindControl("chkSelect") as CheckBox).Checked) { int Emp_ID = Convert.ToInt32(MemberGridView.DataKeys[row.RowIndex].Value); using (RockyingDataClassesDataContext db = new RockyingDataClassesDataContext(Utility.ConnectionString)) { db.ExecuteCommand("DELETE FROM Member WHERE ID = " + Emp_ID, new object[] { }); } } } Bind(0); }