public SimpleMembershipInitializer() { Database.SetInitializer<PIMContext>(null); try { using (var context = new PIMContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } if (!WebSecurity.Initialized) WebSecurity.InitializeDatabaseConnection("PIMdb", "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 ActionResult Index(PIMModel model, HttpPostedFileBase file) { model.Brands = GetBrands(); if (ModelState.IsValid) { int added = 0; int updated = 0; if (file != null && file.ContentLength > 0 && file.FileName.Contains("xls")) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Files/upload"), fileName); file.SaveAs(path); var dt = ReadSpreadsheetIntoDataTable(path, "ProductInfo"); System.IO.File.Delete(path); using (var db = new PIMContext()) { foreach (DataRow row in dt.Rows) { if (string.IsNullOrEmpty(row["Style Number"].ToString().Trim())) { ModelState.AddModelError("StyleError", "A style number is missing. Please correct and re-upload."); return View(model); } string patternName = row["Pattern Name"].ToString().Trim(); var pattern = db.Patterns.SingleOrDefault(p => p.PatternName == patternName); if (pattern == null) pattern = new Pattern(); pattern.BrandId = model.BrandId; pattern.PatternName = patternName; pattern.LastUpdated = DateTime.Now; // Add if it doesn't exist otherwise just updates the existing pattern that was loaded db.Entry(pattern).State = pattern.PatternId == 0 ? EntityState.Added : EntityState.Modified; db.SaveChanges(); // Need to save the pattern first to get an id string styleNumber = row["Style Number"].ToString().Trim(); var style = db.Styles.SingleOrDefault(s => s.StockNumber == styleNumber); if (style == null) style = new Style(); style.PatternId = pattern.PatternId; style.StockNumber = styleNumber; style.MarketingDescription = row["Marketing Description"].ToString(); style.TechBullets = !string.IsNullOrEmpty(row["Tech Bullets"].ToString()) ? row["Tech Bullets"].ToString() : null; style.LastUpdated = DateTime.Now; style.LastUpdatedBy = User.Identity.Name; db.Entry(style).State = style.StyleId == 0 ? EntityState.Added : EntityState.Modified; if (style.StyleId == 0) added++; else updated++; db.SaveChanges(); } } } else { ModelState.AddModelError("XlsError", "Please upload a valid Excel file."); return View(model); } return RedirectToAction("ViewProducts", new { b = model.BrandId, a = added, u = updated }); } return View(model); }
private SelectList GetBrands() { using (var db = new PIMContext()) { var query = from b in db.Brands select b; return new SelectList(query.ToList(), "BrandId", "BrandName"); } }
public ActionResult Purge() { using (var db = new PIMContext()) { var ctx = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext; ctx.ExecuteStoreCommand("TRUNCATE TABLE [Style]"); ctx.ExecuteStoreCommand("DELETE FROM [Pattern]"); } ViewBag.Purged = "The [Style] and [Pattern] tables have been purged."; return View("Admin"); }
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 (var db = new PIMContext()) { 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); }