public ActionResult Create(BlogPost blog)
{
BlogUser loggedUser = (BlogUser)Session["user"];
if (loggedUser == null)
{
return(View("~/Views/Account/NotLogged.cshtml"));
}
if (ModelState.IsValid)
{
var authenticator = new Authenticator();
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>()) // authenticated by user1 as default
{
// Table in DB have to be already created at this point. It's better to do it by hand, then to use strategies,
// because they drop the whole DB which we don't want since users already have access rights set to the given DB
// context.BlogUsers.Attach(loggedUser); // we need to attach user1 because otherwise it is detached entity (EF) doesn't know about it and new one would be created
context.BlogUsers.Attach(loggedUser);
context.BlogPosts.Add(new BlogPost()
{
Title = blog.Title,
Text = blog.Text,
CreatedBy = loggedUser,
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now
});
context.SaveChanges();
}
return(RedirectToAction("IndexBlogsOfUser"));
}
return(View("Error"));
}
public ActionResult Edit(BlogPost blogPost)
{
BlogUser loggedUser = (BlogUser)Session["user"];
if (loggedUser == null)
{
return(View("~/Views/Account/NotLogged.cshtml"));
}
if (ModelState.IsValid)
{
var authenticator = new Authenticator();
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>()) // authenticated by user1 as default
{
// Table in DB have to be already created at this point. It's better to do it by hand, then to use strategies,
context.BlogUsers.Attach(loggedUser);
BlogPost updateBlog = context.BlogPosts.Find(blogPost.Id);
updateBlog.Title = blogPost.Title;
updateBlog.Text = blogPost.Text;
updateBlog.ModifiedOn = DateTime.Now;
context.BlogPosts.AddOrUpdate(updateBlog);
context.SaveChanges();
}
return(RedirectToAction("IndexBlogsOfUser"));
}
return(View("Error"));
}
// GET: Blog
public ActionResult Index()
{
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>())
{
var blogs = context.BlogPosts.ToList();
return(View(blogs));
}
return(View("~/Views/Shared/Error.cshtml"));
}
// GET: Blog/Details/5
public ActionResult Details(int id)
{
var authenticator = new Authenticator();
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>()) // authenticated by user1 as default
{
// Table in DB have to be already created at this point. It's better to do it by hand, then to use strategies,
BlogPost blog = context.BlogPosts.Find(id);
return(View(blog));
}
return(View());
}
// GET: Blog
public ActionResult IndexBlogsOfUser()
{
BlogUser currentUser = (BlogUser)Session["user"];
if (currentUser == null)
{
return(View("~/Views/Account/NotLogged.cshtml"));
}
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>()) // explicitly authenticated by user2
{
var blogs = context.BlogPosts.Where(x => x.CreatedBy.Id.Equals(currentUser.Id)).ToList();
return(View(blogs));
}
return(View("~/Views/Shared/Error.cshtml"));
}
// GET: Blog/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BlogUser currentUser = (BlogUser)Session["user"];
if (currentUser == null)
{
return(View("~/Views/Account/NotLogged.cshtml"));
}
var contextProvider = new MysqlContextProvider();
using (var context = contextProvider.CreateContext <BlogContext>()) // explicitly authenticated by user2
{
var blog = context.BlogPosts.Find(id);
return(View(blog));
}
return(View());
}
public ActionResult Register(BlogUser model)
{
var authenticator = new Authenticator();
if (ModelState.IsValid & !authenticator.UserExists(model))
{
var user = new BlogUser()
{
Username = model.Username,
Password = model.Password,
FullName = model.FullName
};
authenticator.Register(user);
var contextProvider = new MysqlContextProvider();
// we have to add blog user after authenticator.Register() because we need that user to authenticate the transaction
using (var context = contextProvider.CreateContext <BlogContext>(user)) // authenticated by user1
{
context.BlogUsers.Add(user);
context.SaveChanges();
}
// this will set user1 as the default for all following transaction authentications
if (!authenticator.Authenticate(user))
{
throw new InvalidOperationException("This should never happen because user was registered");
}
Session["user"] = user;
return(RedirectToAction("Index", "Account"));
}
else
{
ModelState.AddModelError("Username", "Username already in use!");
return(RedirectToAction("Register", "Account"));
}
// If we got this far, something failed, redisplay form
return(View(model));
}
static void WithCaching()
{
var server = "localhost";
var database = "test";
var adminUsername = "******";
var adminPassword = "";
Configurator.ConfigureAdminAccount(server, database, adminUsername, adminPassword);
var authUser = new AuthFramework.User()
{
Username = "******",
Password = "******"
};
var contextProvider = new MysqlContextProvider();
// returns posts with id less than 100
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Posts.FromCache().Where(x => x.Id < 100).ToList();
}
// returns posts, which title starts with A
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Posts.FromCache().Where(x => x.Title.StartsWith("A")).ToList();
}
// returns posts, which body text starts with E
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Posts.FromCache().Where(x => x.Body.StartsWith("E")).ToList();
}
// returns posts, which has not been deleted
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Posts.FromCache().Where(x => x.Deleted == false).ToList();
}
// returns users with id less than 10
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Users.FromCache().Where(x => x.Id < 10).ToList();
}
// returns users, whose email contains substring: example
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Users.FromCache().Where(x => x.Email.Contains("example")).ToList();
}
// returns users, whose username starts with U
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Users.FromCache().Where(x => x.UserName.StartsWith("U")).ToList();
}
//returns active user, who has the longest lasting profile
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = ctx.Users.FromCache().Where(x => x.Active == true).OrderBy(x => x.Id).First();
}
// returns percentage of active users
using (var ctx = contextProvider.CreateContext <BlogContext>(authUser))
{
double query = (double)ctx.Users.FromCache().Where(user => user.Active == true).Count() / ctx.Users.FromCache().Count();
}
}
static void NonGenericAccount()
{
var server = "localhost";
var database = "test";
var adminUsername = "******";
var adminPassword = "";
Configurator.ConfigureAdminAccount(server, database, adminUsername, adminPassword);
var authUser = new AuthFramework.User()
{
Username = "******",
Password = "******"
};
var user1234 = new User()
{
UserName = "******",
Email = "*****@*****.**",
Password = "******",
Created = DateTime.Now
};
var post1 = new Post()
{
Title =
"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit...",
Body =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras rutrum elit posuere finibus ornare. Quisque non arcu turpis. Curabitur a volutpat ante. Etiam quis ipsum nec sem efficitur vestibulum. Vivamus a velit vehicula, eleifend turpis et, mollis felis. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus ligula dui, elementum id volutpat eget, convallis eu mauris. Pellentesque risus felis, egestas eget porta non, scelerisque vel leo. Vestibulum hendrerit sapien sed tellus placerat aliquam. Mauris eu eros a tortor finibus viverra bibendum ut nulla. Phasellus pellentesque, leo ac consectetur pulvinar, dui enim auctor libero, vitae fringilla ex turpis in ligula. Nam et venenatis leo, sed condimentum nulla. Vestibulum luctus sapien nec erat tempor viverra. Donec id magna vitae nibh placerat pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer euismod fringilla vestibulum.",
User = user1234,
Published = DateTime.Now
};
var post2 = new Post()
{
Title =
"Aliquam dignissim eget",
Body =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent volutpat pretium turpis sit amet ornare. Donec a hendrerit purus, id sagittis felis. Phasellus at dui turpis. Nam quis lectus ipsum. Etiam laoreet tortor eget imperdiet suscipit. Donec vestibulum enim vitae nibh sollicitudin, ut lacinia justo commodo. Donec vulputate sapien at sem bibendum, vel auctor dui vehicula. Maecenas consequat massa ac turpis accumsan finibus. Sed blandit accumsan turpis, in ornare mauris. Quisque eu lacinia orci. Suspendisse vitae risus iaculis, porta urna non, cursus lorem. Morbi nec ipsum ut sapien pretium commodo.Aliquam dignissim eget risus sed bibendum.Ut ligula quam,facilisis quis sagittis sed,euismod a ligula.Praesent ac nibh at mauris vehicula aliquet.Duis pretium leo est,vel venenatis eros finibus sit amet.Mauris massa enim,dignissim eget neque eget,ornare accumsan enim.Sed id lacus ut libero luctus consequat suscipit nec diam.Maecenas mollis vehicula faucibus.Aenean euismod,elit non vehicula porttitor,metus lacus fermentum sapien,elementum gravida ligula lorem facilisis quam.Integer luctus,mi quis tempor tempus,ex purus volutpat dolor,sed dapibus eros turpis sed nunc.Aenean ut interdum velit.Mauris ullamcorper justo ac maximus aliquam.Nullam euismod leo id vulputate varius.Curabitur id faucibus sapien.Pellentesque tincidunt ligula quam,posuere pulvinar ligula rhoncus eget.Pellentesque magna neque,hendrerit eu suscipit et,malesuada aliquam tortor.Vestibulum id maximus odio.",
User = user1234,
Published = DateTime.Now
};
var post3 = new Post()
{
Title =
"Praesent volutpat pretium turpis",
Body =
"Vivamus auctor, felis ultrices luctus bibendum, nisi ligula laoreet nisi, vitae pretium sapien libero sit amet leo. In feugiat magna in dolor elementum faucibus. Aenean non velit nec dolor tincidunt commodo a a urna. Duis venenatis nulla vel consequat dictum. Duis eu massa vulputate, dictum nisl non, tempor purus. Aliquam sed ligula nec nisi dapibus elementum. Morbi et efficitur nulla. Cras elit quam, porttitor vitae leo eu, lacinia euismod lorem. Vestibulum pellentesque ante et dapibus tempor. Sed ac lectus nunc. Suspendisse aliquam turpis ut velit gravida tristique.Nullam eget lacus vel sem dapibus ornare quis eget tortor.Ut suscipit tincidunt enim,ut placerat odio pharetra at.Quisque rutrum est eget massa tincidunt tempus.Ut a odio faucibus,placerat velit in,finibus magna.Nam malesuada lacus libero,quis molestie nunc rutrum vel.Vivamus a ipsum vitae leo accumsan fringilla.In tristique nunc nec augue mollis eleifend.Aliquam enim urna,accumsan sit amet fermentum nec,bibendum a libero.Nam at tempus sapien.Pellentesque pharetra ullamcorper dapibus.Vivamus libero massa,tincidunt eget consequat sit amet,semper porta quam.Praesent vehicula interdum velit eu volutpat.Nam lacus justo,tempus in tortor vel,euismod luctus sapien.Phasellus tempus nunc purus,nec faucibus erat tincidunt id.Suspendisse augue metus,dictum id ligula nec,maximus varius sapien.",
User = user1234,
Published = DateTime.Now
};
var contextProvider = new MysqlContextProvider();
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
blContext.Users.Add(user1234);
blContext.SaveChanges();
}
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
blContext.Posts.Add(post1);
blContext.SaveChanges();
}
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
blContext.Posts.Add(post2);
blContext.SaveChanges();
}
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
blContext.Posts.Add(post3);
blContext.SaveChanges();
}
// returns titles and comments count of 5 most commented posts
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
var query = blContext.Posts.GroupJoin(blContext.Comments,
post => post,
cmnt => cmnt.Post,
(post, cmnt) => new { post.Title, cmnt })
.OrderByDescending(x => x.cmnt.Count())
.Take(5)
.Select((x) => new { x.Title, Count = x.cmnt.Count() })
.ToList();
}
// returns percentage of active users
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
double percentage = (double)blContext.Users.Where(user => user.Active == true).Count() / blContext.Users.Count();
}
// changes email of user
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
var usr = blContext.Users.Where(x => x.Email == user1234.Email).First();
usr.Email = "*****@*****.**";
blContext.SaveChanges();
}
//changes content of posts posted by user1234
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
var postList = blContext.Posts.Where(x => x.User.UserName == user1234.UserName)
.ToList();
foreach (var p in postList)
{
p.Body = p.Body + " written by user1234";
blContext.SaveChanges();
}
}
//add comment to last post
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
var lastPost = blContext.Posts.OrderByDescending(x => x.Published).First();
var comment = new Comment()
{
CommentDate = DateTime.Now,
CommentText = "This is my comment",
Post = lastPost,
User = user1234
};
blContext.Comments.Add(comment);
blContext.SaveChanges();
}
//returns active user, who has the longest lasting profile
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
var longestLastingProfileUser =
blContext.Users.Where(x => x.Active == true).OrderBy(x => x.Created).First();
}
//returns, how much posts in average was posted by users, who are no longer active
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
double postsCountByInactiveUsers =
blContext.Users.Where(x => x.Active == false).GroupJoin(
blContext.Posts,
usr => usr.Id,
post => post.Id,
(usr, post) => post)
.Average(yz => yz.Count());
}
// returns list of tuples contains username and post titles
using (var blContext = contextProvider.CreateContext <BlogContext>(authUser))
{
blContext.Database.CommandTimeout = 180;
var usersAndTheriPostsTitles =
blContext.Users.GroupJoin(
blContext.Posts,
usr => usr.Id,
post => post.User.Id,
(usr, post) => new { usr.UserName, post })
.AsEnumerable()
.Select(x => new Tuple <string, List <string> >(x.UserName, x.post.Select(s => s.Title).ToList())).ToList();
}
}
static void Main(string[] args)
{
// configures admin account which will be used for registrations
// all values can stay the same for you except database. If you create DB with different name you need to change it
var server = "localhost";
var database = "authdb";
var adminUsername = "******";
var adminPassword = "";
Configurator.ConfigureAdminAccount(server, database, adminUsername, adminPassword);
// ------------ some generic example -------------
var user = new User()
{
Username = "******",
Password = "******"
};
var authenticator = new Authenticator();
authenticator.Register(user);
// should be true
Console.Out.WriteLine(authenticator.CanAuthenticate(user));
authenticator.Delete(user.Username);
// should be false
Console.Out.WriteLine(authenticator.CanAuthenticate(user));
// ---------------- simple blog example ------------
var user1 = new BlogUser()
{
Username = "******",
Password = "******",
FullName = "Johcqvn Doek"
};
var user2 = new BlogUser()
{
Username = "******",
Password = "******",
FullName = "Janqecv Doek"
};
authenticator.Register(user1); // don't run this twice, it will throw exception that same user already exists
authenticator.Register(user2);
var contextProvider = new MysqlContextProvider();
// we have to add blog user after authenticator.Register() because we need that user to authenticate the transaction
using (var context = contextProvider.CreateContext <BlogContext>(user1)) // authenticated by user1
{
context.BlogUsers.Add(user1);
context.SaveChanges();
}
using (var context = contextProvider.CreateContext <BlogContext>(user2)) // authenticated by user2
{
context.BlogUsers.Add(user2);
context.SaveChanges();
}
// this will set user1 as the default for all following transaction authentications
if (!authenticator.Authenticate(user1))
{
throw new InvalidOperationException("This should never happen because user was registered");
}
using (var context = contextProvider.CreateContext <BlogContext>()) // authenticated by user1 as default
{
// Table in DB have to be already created at this point. It's better to do it by hand, then to use strategies,
// because they drop the whole DB which we don't want since users already have access rights set to the given DB
context.BlogUsers.Attach(user1); // we need to attach user1 because otherwise it is detached entity (EF) doesn't know about it and new one would be created
context.BlogPosts.Add(new BlogPost()
{
Title = "Some title",
BlogUser = user1
});
context.SaveChanges();
}
using (var context = contextProvider.CreateContext <BlogContext>(user2)) // explicitly authenticated by user2
{
foreach (var post in context.BlogPosts.Include("bloguser"))
{
Console.Out.WriteLine($"{post.BlogUser.FullName} : {post.Title}");
}
}
// from now on, user2 will be used as default for authentication
authenticator.SetUser(user2);
}
