/** * This function will get the current users ID based on their login. * It will populate a gridview of all the notes the user has created. **/ protected void getNotes() { var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var objE = (from bg in db.blogs join br in db.blog_references on bg.blogID equals br.blogID join bt in db.blog_title on bg.blogID equals bt.blogID join bp in db.blog_post on bg.blogID equals bp.blogID where bg.userID == userID select new { bg.blogID, br.bookName, br.chapterID, br.verseID, bt.title, bp.post }); grdNotes.DataSource = objE.ToList(); grdNotes.DataBind(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } }
public void getBible(int bookNum) { int bN = bookNum; using (DefaultConnectionEF db = new DefaultConnectionEF()) { var objE = (from b in db.BibleBasicEnglishes where b.bookNum == bN select b).ToList(); grdBible.DataSource = objE.ToList(); grdBible.DataBind(); } }
protected void btnNext_Click(object sender, EventArgs e) { Session["bookNum"] = Convert.ToInt32(Session["bookNum"]) + 1; int bookNum = Convert.ToInt32(Session["bookNum"]); if (Convert.ToInt32(Session["bookNum"]) >= 66) { btnNextBook.Visible = false; btnPreviousBook.Visible = true; try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var book = (from b in db.BibleBasicEnglishes where b.bookNum == bookNum select b).FirstOrDefault(); lblCurrentBook.Text = book.Book; getBible(bookNum); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } } else { btnPreviousBook.Visible = true; try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var book = (from b in db.BibleBasicEnglishes where b.bookNum == bookNum select b).FirstOrDefault(); lblCurrentBook.Text = book.Book; getBible(bookNum); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } } }
protected void GetBible() { //connect using our connection string from web.config and EF context class using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //use link to query the Departments model var bible = from b in conn.BibleBasicEnglishes select b; //bind the query result to the gridview string sortString = Session["sortColumn"].ToString() + " " + Session["sortDirection"].ToString(); // grdBible.DataSource = bible.AsQueryable().OrderBy(sortString).ToList(); // grdBible.DataBind(); } }
protected void btnRegister_Click(object sender, EventArgs e) { try { // Default UserStore constructor uses the default connection string named: DefaultConnection var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var user = new IdentityUser() { UserName = txtUsername.Text }; IdentityResult result = manager.Create(user, txtPassword.Text); if (result.Succeeded) { //lblStatus.Text = string.Format("User {0} was created successfully!", user.UserName); //lblStatus.CssClass = "label label-success"; var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = manager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie); authenticationManager.SignIn(new AuthenticationProperties() { }, userIdentity); //add user to users db using (DefaultConnectionEF db = new DefaultConnectionEF()) { blogUser u = new blogUser(); u.userID = user.Id; u.fName = txtFName.Text; u.lName = txtLName.Text; db.blogUsers.Add(u); db.SaveChanges(); } //redirect to main menu Response.Redirect("/admin/bibleMenu.aspx"); } else { //lblStatus.Text = result.Errors.FirstOrDefault(); //lblStatus.CssClass = "label label-danger"; } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } }
/** * This method will delete a note by getting the row index and using the blogID * it will remove all instances from all tables. **/ protected void grdNotes_RowDeleting(object sender, GridViewDeleteEventArgs e) { Int32 selectedRow = e.RowIndex; //get the selected StudentID using the grids Data Key collection Int32 blogID = Convert.ToInt32(grdNotes.DataKeys[selectedRow].Values["blogID"]); using (DefaultConnectionEF db = new DefaultConnectionEF()) { //query for blog result blog b = (from objs in db.blogs where objs.blogID == blogID select objs).FirstOrDefault(); //query for blog post result blog_post bp = (from objs in db.blog_post where objs.blogID == blogID select objs).FirstOrDefault(); //query for blog title result blog_title bt = (from objs in db.blog_title where objs.blogID == blogID select objs).FirstOrDefault(); //query for blog references result blog_references br = (from objs in db.blog_references where objs.blogID == blogID select objs).FirstOrDefault(); //remove blog references db.blog_references.Remove(br); db.SaveChanges(); //remove blog title db.blog_title.Remove(bt); db.SaveChanges(); //remove blog post db.blog_post.Remove(bp); db.SaveChanges(); //remove blog db.blogs.Remove(b); db.SaveChanges(); } //refresh the grid getNotes(); }
protected void Page_Load(object sender, EventArgs e) { //get userID from asp db var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); //using userID to get user information fname and lname using (DefaultConnectionEF db = new DefaultConnectionEF()) { blogUser id = (from objs in db.blogUsers where objs.userID == userID select objs).FirstOrDefault(); lblUserId.Text = "Welcome " + id.fName; } }
public void getBlog() { var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); //try //{ using (DefaultConnectionEF db = new DefaultConnectionEF()) { int chapterid, verseid; if ((Request.QueryString["blogID"]) != null) { var blogID = Convert.ToInt32((Request.QueryString["blogID"])); var objE = (from bg in db.blogs join br in db.blog_references on bg.blogID equals br.blogID join bt in db.blog_title on bg.blogID equals bt.blogID join bp in db.blog_post on bg.blogID equals bp.blogID where bg.userID == Convert.ToString(userID) && bg.blogID == blogID select new { bg.blogID, br.bookName, br.chapterID, br.verseID, br.verseText, bt.title, bp.post }).FirstOrDefault(); // objE.ToList(); if (objE != null) { blogID = objE.blogID; ddlBook.SelectedValue = objE.bookName; chapterid = objE.chapterID; verseid = objE.verseID; TextVerse.Text = objE.verseText; titleTxt.Text = objE.title; txtBlog.Text = objE.post; } } } //} //catch (Exception ex) //{ //Response.Redirect("/errors.aspx"); //} }
public void BindddlBook() { ddlBook.Items.Clear(); try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var objB = (from b in db.BibleBasicEnglishes orderby b.ID group b by b.Book into d select new { Book = d.Key, books = d.ToList() }); ddlBook.DataSource = objB.ToList(); ddlBook.DataBind(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); //do insert or update using (DefaultConnectionEF db = new DefaultConnectionEF()) { blog b = new blog(); blog_references bref = new blog_references(); blog_title btitle = new blog_title(); blog_post bpost = new blog_post(); int chapterid = Convert.ToInt32(ddlChapter.SelectedValue); int verseid = Convert.ToInt32(ddlVerse.SelectedValue); Int32 blogID = 0; if ((Request.QueryString["blogID"]) != null) { blogID = Convert.ToInt32(Request.QueryString["blogID"]); bref.blogID = blogID; bpost.blogID = blogID; btitle.blogID = blogID; } //set blog variable b.blogID = blogID; //set references variables bref.bookName = ddlBook.SelectedValue; bref.chapterID = Convert.ToInt32(ddlChapter.SelectedValue); bref.verseID = Convert.ToInt32(ddlVerse.SelectedValue); //set post variables bpost.post = txtBlog.Text; //set title variables btitle.title = titleTxt.Text; if (blogID == 0) { db.blogs.Add(b); db.SaveChanges(); blogID = (from n in db.blogs where n.userID == userID orderby n.blogID descending select n.blogID).First(); bref.blogID = blogID; bpost.blogID = blogID; btitle.blogID = blogID; db.blog_references.Add(bref); db.blog_post.Add(bpost); db.blog_title.Add(btitle); } db.SaveChanges(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } Response.Redirect("/admin/notes.aspx"); }
//String VerseText; //Int32 Chapter, Verse; protected void Page_Load(object sender, EventArgs e) { var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { blogUser id = (from objs in db.blogUsers where objs.userID == userID select objs).FirstOrDefault(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } getBlog(); if (!IsPostBack) { // Bind Book dropdownlist BindddlBook(); ddlChapter.Enabled = false; ddlVerse.Enabled = false; // Insert one item to dropdownlist top ddlBook.Items.Insert(0, new ListItem("Select Book", "-1")); ddlChapter.Items.Insert(0, new ListItem("Select Chapter", "-1")); ddlVerse.Items.Insert(0, new ListItem("Select Verse", "-1")); } }
protected void ddlChapter_SelectedIndexChanged(object sender, EventArgs e) { // Bind city dropdownlist based on region value //string strChapter = string.Empty; //strChapter = ddlChapter.SelectedValue; try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var Verse = (from v in db.BibleBasicEnglishes where v.Book == ddlBook.SelectedValue && v.Chapter.ToString() == ddlChapter.SelectedValue group v by v.Verse into d select new { Verse = d.Key, verses = d.ToList() }); //ddlVerse.Items.Clear(); ddlVerse.DataSource = Verse.ToList(); ddlVerse.DataBind(); ddlVerse.Items.Insert(0, new ListItem("Select Verse", "-1")); // Initialize Verse dropdownlist selected index hdfDdlVerseSelectIndex.Value = "0"; // Enable Verse dropdownlist when it has items if (ddlVerse.Items.Count > 0) { ddlVerse.Enabled = true; } else { ddlVerse.Enabled = false; } } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } }
protected void ddlBook_SelectedIndexChanged(object sender, EventArgs e) { // Remove Chapter dropdownlist items ddlChapter.Items.Clear(); // Bind Chapter dropdownlist based on Book value if (ddlBook.SelectedValue == "-1") { } else { ddlChapter.Enabled = true; try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var objC = (from c in db.BibleBasicEnglishes where c.Book == ddlBook.SelectedValue group c by c.Chapter into d select new { Chapter = d.Key, chapters = d.ToList() }); ddlChapter.DataSource = objC.ToList(); ddlChapter.DataBind(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } } ddlChapter.Items.Insert(0, new ListItem("Select Chapter", "-1")); // Clear Verse dropdownlist ddlVerse.Enabled = true; ddlVerse.Items.Clear(); ddlVerse.Items.Insert(0, new ListItem("Select Verse", "-1")); }
protected void btnSubmit_Click(object sender, EventArgs e) { // Get the selected index of Chapter dropdownlist int iVerseSelected = Convert.ToInt16(hdfDdlVerseSelectIndex.Value); // The result will be showing string strResult = string.Empty; if (ddlBook.SelectedIndex == 0) { strResult = "Please select a Book."; } else if (ddlChapter.SelectedIndex == 0 && strResult == string.Empty) { strResult = "Please select a Chapter"; } else if (ddlVerse.SelectedIndex == 0 && strResult == string.Empty) { strResult = "Please select a Verse"; } else { strResult = "You selected Book: " + ddlBook.SelectedValue + " ; Chapter: " + ddlChapter.SelectedValue + " ; Verse: " + ddlVerse.SelectedValue; } try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { var Versetxt = (from v in db.BibleBasicEnglishes where v.Book == ddlBook.SelectedValue && v.Chapter.ToString() == ddlChapter.SelectedValue && v.Verse.ToString() == ddlVerse.SelectedValue select v.VerseText); TextVerse.Text = Versetxt.FirstOrDefault().ToString(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } lblResult.Text = strResult; }
protected void ddlChapter_SelectedIndexChanged(object sender, EventArgs e) { try { int BookNum; using (DefaultConnectionEF db = new DefaultConnectionEF()) { var bN = (from b in db.BibleBasicEnglishes where b.Book == ddlBook.SelectedValue select b).FirstOrDefault(); BookNum = Convert.ToInt32(bN.bookNum); } Session["bookNum"] = BookNum; using (DefaultConnectionEF db = new DefaultConnectionEF()) { var book = (from b in db.BibleBasicEnglishes where b.bookNum == BookNum select b).FirstOrDefault(); lblCurrentBook.Text = book.Book; } if (BookNum == 1) { btnPreviousBook.Visible = false; } else if (BookNum == 66) { btnPreviousBook.Visible = true; btnNextBook.Visible = false; } else { btnNextBook.Visible = true; btnPreviousBook.Visible = true; } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { var userStore = new UserStore<IdentityUser>(); var manager = new UserManager<IdentityUser>(userStore); var userID = User.Identity.GetUserId(); try { using (DefaultConnectionEF db = new DefaultConnectionEF()) { blogUser id = (from objs in db.blogUsers where objs.userID == userID select objs).FirstOrDefault(); } } catch (Exception ex) { Response.Redirect("/errors.aspx"); } if (!IsPostBack) { getNotes(); } }