public SimpleMembershipInitializer()
{
Database.SetInitializer<UsersContext>(null);
try
{
using (var context = new UsersContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("UsersContext", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
private void SendEmailIfRegistered(byte[] file, string name)
{
var smtpClient = new SmtpClient();
var myMessage = new MailMessage
{
From = new MailAddress(string.Format("admin@{0}", HttpContext.Request.Url.Host))
};
var db = new UsersContext();
var admins = Roles.GetUsersInRole("admin");
var users = db.UserProfiles.Where(x => x.Email != null && admins.Contains(x.UserName));
if(!users.Any()) return;
foreach (var user in users)
{
myMessage.To.Add(string.Format(@"<{0}>", user.Email));
}
myMessage.Subject = "Ice cream report";
myMessage.Body = string.Format("{0} effectuated report. See attachment.", name);
using (var ms = new MemoryStream(file))
{
myMessage.Attachments.Add(new Attachment(ms, string.Format("Ice Report {0}.xlsx", DateTime.UtcNow.EuropeanTime())));
smtpClient.Send(myMessage);
}
}
public ActionResult Login(string returnUrl)
{
var db = new UsersContext();
ViewBag.ReturnUrl = returnUrl;
return View();
}
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
{
string provider = null;
string providerUserId = null;
if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
{
return RedirectToAction("Manage");
}
if (ModelState.IsValid)
{
// Insert a new user into the database
using (UsersContext db = new UsersContext())
{
UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
// Check if user already exists
if (user == null)
{
// Insert name into the profile table
db.UserProfiles.Add(new UserProfile { UserName = model.UserName });
db.SaveChanges();
OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);
return RedirectToLocal(returnUrl);
}
else
{
ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
}
}
}
ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
ViewBag.ReturnUrl = returnUrl;
return View(model);
}
public ActionResult ChangeEmail(ChangeEmailModel model)
{
if (ModelState.IsValid)
{
var db = new UsersContext();
var user = db.UserProfiles.First(x => x.UserName == User.Identity.Name);
user.Email = model.Email;
db.SaveChanges();
return RedirectToAction("Index", "Admin");
}
return View(model);
}