public override bool IsUserInRole(string username, string roleName) { if (roleName == Roles.admin.ToString()) { using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (!dc.DatabaseExists()) { dc.CreateDatabase(); dc.SubmitChanges(); } return dc.User.Any(u => u.Email == username && u.IsAdmin); } } return false; }
protected void btnFilterReported_Click(object sender, EventArgs e) { CurrentSiteStateFilter = SiteState.Reported; btnFilterNone.Font.Bold = false; txtNumSitesTotal.Font.Bold = false; btnFilterReported.Font.Bold = true; txtNumReportedSites.Font.Bold = true; btnFilterBroken.Font.Bold = false; txtNumBrokenSites.Font.Bold = false; using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (dc.DatabaseExists()) { BindGrid(dc); } } }
public override bool ValidateUser(string username, string password) { using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (!dc.DatabaseExists()) { dc.CreateDatabase(); dc.SubmitChanges(); } var result = dc.User.Any(u => u.Email == username && u.Password == password); return result; } }
public override string GetPassword(string username, string answer) { using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (!dc.DatabaseExists()) { dc.CreateDatabase(); dc.SubmitChanges(); } return (from u in dc.User where u.Email == username select u.Password).First(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (dc.DatabaseExists()) { txtNumSitesTotal.Text = dc.Site.Count().ToString(); txtNumReportedSites.Text = dc.Site.Count(s => s.State == SiteState.Reported).ToString(); txtNumBrokenSites.Text = dc.Site.Count(s => s.State == SiteState.Broken).ToString(); BindGrid(dc); } } } }
protected void siteOverview_Sorting(object sender, GridViewSortEventArgs e) { CurrentSortingProperty = e.SortExpression; using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (dc.DatabaseExists()) { BindGrid(dc); } } }
private void BindGrid() { using (OnlineVideosDataContext dc = new OnlineVideosDataContext()) { if (dc.DatabaseExists()) { var site = dc.Site.FirstOrDefault(s => s.Name == this.Request.Params["site"]); if (site != null) { btnDeleteSite.Visible = (User.Identity.Name == site.Owner_FK && site.State == SiteState.Broken && (DateTime.Now - dc.Report.Where(r => r.Site_FK == this.Request.Params["site"] && r.Type == ReportType.ConfirmedBroken).OrderByDescending(r => r.Date).Select(r => r.Date).FirstOrDefault()).TotalDays > 10) || User.IsInRole("admin"); reports.ShowFooter = User.Identity.Name == site.Owner_FK || User.IsInRole("admin"); reports.Columns[reports.Columns.Count - 1].Visible = User.Identity.Name == site.Owner_FK || User.IsInRole("admin"); var reportsQuery = from a in dc.Report where a.Site_FK == this.Request.Params["site"] select new { Message = a.Message, Type = a.Type, Date = a.Date, }; reportsQuery = reportsQuery.OrderByDescending(s => s.Date); var result = (List<Report>)reportsQuery.ToList().ToNonAnonymousList(typeof(Report)); if (result.Count == 0) result.Add(null); // hack to make ASP.NET < 4 show header and footer when empty data reports.DataSource = result; reports.DataBind(); } } } }