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