public SimpleMembershipInitializer()
{
//Database.SetInitializer<UsersContext>(null);
Database.SetInitializer<IDSMContext>(null);
try
{
// using (var context = new UsersContext())
using (var context = new IDSMContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
// WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
WebSecurity.InitializeDatabaseConnection("IDSMContext", "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);
}
}
public static OperationStatus ProcessCsvHelper(string filePath, IDSMContext DataContext)
{
string Feedback = string.Empty;
StreamReader srCSV = new StreamReader(filePath);
CsvReader csvReader = new CsvReader(srCSV);
// NOTE:
// 'ID' error on CSV import is either is coming from this line, or the for each loop below.
// Temporarily fixed by adding an ID column to CSV
List<Player> FootballPlayerList = new List<Player>();
try
{
FootballPlayerList = new List<Player>(csvReader.GetRecords<Player>());
}
catch (Exception ex)
{
return OperationStatus.CreateFromException("Error reading from CSV.", ex);
}
try
{
foreach (Player m in FootballPlayerList)
{
DataContext.Players.Add(m);
}
DataContext.SaveChanges();
}
catch (Exception ex)
{
return OperationStatus.CreateFromException("Error saving players to DB from CSV.", ex);
}
srCSV.Dispose();
csvReader.Dispose();
return new OperationStatus { Status = true };
}
public UnitOfWork()
{
_context = new IDSMContext();
}
public UserTeamRepository(IDSMContext context) : base(context)
{
}
public GameRepository(IDSMContext context) : base(context)
{
}
public PlayerRepository(IDSMContext context) : base(context)
{
}
public RepositoryBase(IDSMContext context)
{
DataContext = context;
}
public BanterRepository(IDSMContext context) : base(context)
{
}
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())
using (IDSMContext db = new IDSMContext())
{
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);
}