public ActionResult DeleteConfirmed(int id) { BannedWord bannedWord = db.BannedWords.Find(id); db.BannedWords.Remove(bannedWord); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "BannedWordID,Name")] BannedWord bannedWord) { if (ModelState.IsValid) { db.Entry(bannedWord).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bannedWord)); }
public ActionResult Create([Bind(Include = "BannedWordID,Name")] BannedWord bannedWord) { if (ModelState.IsValid) { db.BannedWords.Add(bannedWord); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bannedWord)); }
public void AddWord(string word) { if (IsBanned(word)) { throw new WordAlreadyBannedException(); } BannedWord bw = new BannedWord(word); _bannedWords.Add(bw); }
// GET: BannedWords/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BannedWord bannedWord = db.BannedWords.Find(id); if (bannedWord == null) { return(HttpNotFound()); } return(View(bannedWord)); }
public ActionResult DeleteConfirmed(int id) { BannedWord bannedWord = db.BannedWords.Find(id); db.BannedWords.Remove(bannedWord); db.SaveChanges(); if (bannedWord.Word[0] != '<') { return(RedirectToAction("Index")); } else { return(RedirectToAction("IndexA")); } }
public ActionResult Add(AddBannedWordViewModel addBannedEmailViewModel) { using (var unitOfWork = UnitOfWorkManager.NewUnitOfWork()) { try { if (!string.IsNullOrEmpty(addBannedEmailViewModel.Word)) { var bannedWord = new BannedWord { Word = addBannedEmailViewModel.Word, DateAdded = DateTime.UtcNow, IsStopWord = addBannedEmailViewModel.IsStopWord }; _bannedWordService.Add(bannedWord); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Word added", MessageType = GenericMessages.success }; unitOfWork.Commit(); } else { TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Please add a word", MessageType = GenericMessages.danger }; } } catch (Exception ex) { unitOfWork.Rollback(); LoggingService.Error(ex); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = LocalizationService.GetResourceString("Errors.GenericMessage"), MessageType = GenericMessages.danger }; } } return(RedirectToAction("Index")); }
public ActionResult Add(AddBannedWordViewModel addBannedEmailViewModel) { try { if (!string.IsNullOrWhiteSpace(addBannedEmailViewModel.Word)) { var bannedWord = new BannedWord { Word = addBannedEmailViewModel.Word, DateAdded = DateTime.UtcNow, IsStopWord = addBannedEmailViewModel.IsStopWord }; _bannedWordService.Add(bannedWord); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Word added", MessageType = GenericMessages.success }; Context.SaveChanges(); } else { TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Please add a word", MessageType = GenericMessages.danger }; } } catch (Exception ex) { Context.RollBack(); LoggingService.Error(ex); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = LocalizationService.GetResourceString("Errors.GenericMessage"), MessageType = GenericMessages.danger }; } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "BannedWordId,Word")] BannedWord bannedWord) { if (ModelState.IsValid) { db.Entry(bannedWord).State = EntityState.Modified; db.SaveChanges(); if (bannedWord.Word[0] != '<') { return(RedirectToAction("Index")); } else { return(RedirectToAction("IndexA")); } } return(View(bannedWord)); }
public ActionResult Create([Bind(Include = "BannedWordId,Word")] BannedWord bannedWord) { if (ModelState.IsValid) { db.BannedWords.Add(bannedWord); db.SaveChanges(); if (bannedWord.Word[0] != '<') { return(RedirectToAction("Index")); } else { return(RedirectToAction("IndexA")); } } return(View(bannedWord)); }
public BannedWord Add(BannedWord bannedWord) { return(_context.BannedWord.Add(bannedWord)); }
public void Delete(BannedWord bannedWord) { _bannedWordRepository.Delete(bannedWord); }
public BannedWord Add(BannedWord bannedWord) { return(_bannedWordRepository.Add(bannedWord)); }
public void Delete(BannedWord bannedWord) { _context.BannedWord.Remove(bannedWord); }
public BannedWord Add(BannedWord bannedWord) { return _context.BannedWord.Add(bannedWord); }
public void Delete(BannedWord bannedWord) { _context.BannedWord.Remove(bannedWord); }
protected override void Seed(ApplicationDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // Models.IdentityManager im = new Models.IdentityManager(); if (!im.RoleExists("Admin")) { im.CreateRole("Admin"); } if (!im.RoleExists("User")) { im.CreateRole("User"); } var passwordHash = new PasswordHasher(); User u = new User(); u.Email = "*****@*****.**"; u.UserName = "******"; //u.Nick = "slightom"; u.PasswordHash = passwordHash.HashPassword("Slightomp+"); u.SecurityStamp = Guid.NewGuid().ToString(); context.Users.AddOrUpdate(p => p.UserName, u); context.SaveChanges(); im.AddUserToRoleByUsername("slightom", "User"); u = new User(); u.Email = "*****@*****.**"; u.UserName = "******"; //u.Nick = "witek15"; u.PasswordHash = passwordHash.HashPassword("Witek15p+"); u.SecurityStamp = Guid.NewGuid().ToString(); context.Users.AddOrUpdate(p => p.UserName, u); context.SaveChanges(); im.AddUserToRoleByUsername("witek15", "User"); u = new User(); u.Email = "*****@*****.**"; u.UserName = "******"; //u.Nick = "wiktor500"; u.PasswordHash = passwordHash.HashPassword("Wiktor500p+"); u.SecurityStamp = Guid.NewGuid().ToString(); context.Users.AddOrUpdate(p => p.UserName, u); context.SaveChanges(); im.AddUserToRoleByUsername("wiktor500", "User"); u = new User(); u.Email = "*****@*****.**"; u.UserName = "******"; //u.Nick = "jola17"; u.PasswordHash = passwordHash.HashPassword("Jola17p+"); u.SecurityStamp = Guid.NewGuid().ToString(); context.Users.AddOrUpdate(p => p.UserName, u); context.SaveChanges(); im.AddUserToRoleByUsername("jola17", "User"); u = new User(); u.Email = "*****@*****.**"; u.UserName = "******"; //u.Nick = "admin1"; u.PasswordHash = passwordHash.HashPassword("Admin1p+"); u.SecurityStamp = Guid.NewGuid().ToString(); context.Users.AddOrUpdate(p => p.UserName, u); context.SaveChanges(); im.AddUserToRoleByUsername("admin1", "Admin"); BannedWord b = new BannedWord(); b.Name = "krucafuks"; context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); b = new BannedWord(); b.Name = "psia kość".ToString(); context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); b = new BannedWord(); b.Name = "kurka wodna".ToString(); context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); b = new BannedWord(); b.Name = "patałach".ToString(); context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); b = new BannedWord(); b.Name = "motyla noga".ToString(); context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); b = new BannedWord(); b.Name = "cholercia".ToString(); context.BannedWords.AddOrUpdate(p => p.Name, b); context.SaveChanges(); AdminMessage am = new AdminMessage(); am.Title = "Wesołych Świąt!"; am.Text = "Administratorzy witryny MyOLX Życzą wszystkim użytkownikom Wesołych Świąt!"; am.Date = new DateTime(2016, 12, 20, 10, 10, 10); context.AdminMessages.AddOrUpdate(p => p.Title, am); string ids, idr; ids = context.Users.Where(n => n.UserName == "witek15").Select(n => n.Id).FirstOrDefault(); idr = context.Users.Where(n => n.UserName == "jola17").Select(n => n.Id).FirstOrDefault(); Message m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "cześć"; m.Date = new DateTime(2016, 11, 20, 10, 10, 10); m.Read = true; context.Messages.AddOrUpdate(p => p.Date, m); context.SaveChanges(); ids = context.Users.Where(n => n.UserName == "jola17").Select(n => n.Id).FirstOrDefault(); idr = context.Users.Where(n => n.UserName == "witek15").Select(n => n.Id).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "no cześć"; m.Date = new DateTime(2016, 11, 20, 10, 10, 15); m.Read = true; context.Messages.AddOrUpdate(p => p.Date, m); context.SaveChanges(); ids = context.Users.Where(n => n.UserName == "witek15").Select(n => n.Id).FirstOrDefault(); idr = context.Users.Where(n => n.UserName == "jola17").Select(n => n.Id).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "idziemy na piwo?"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 5); context.Messages.AddOrUpdate(p => p.Date, m); context.SaveChanges(); ids = context.Users.Where(n => n.UserName == "jola17").Select(n => n.Id).FirstOrDefault(); idr = context.Users.Where(n => n.UserName == "witek15").Select(n => n.Id).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "za 15 minut na murkach"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 17); context.Messages.AddOrUpdate(p => p.Date, m); context.SaveChanges(); ids = context.Users.Where(n => n.UserName == "witek15").Select(n => n.Id).FirstOrDefault(); idr = context.Users.Where(n => n.UserName == "jola17").Select(n => n.Id).FirstOrDefault(); m = new Message(); m.SenderID = ids; m.ReceiverID = idr; m.Text = "elo"; m.Read = true; m.Date = new DateTime(2016, 11, 20, 10, 11, 29); context.Messages.AddOrUpdate(p => p.Date, m); context.SaveChanges(); Category c = new Category(); c.Name = "Motoring"; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); int fatherid = context.Categories.Where(p => p.Name == "Motoring").Select(p => p.CategoryID).First(); c = new Category(); c.Name = "Cars"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Auto parts"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Car auto equipmnet"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); fatherid = context.Categories.Where(p => p.Name == "Cars").Select(p => p.CategoryID).First(); c = new Category(); c.Name = "Audi"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Fiat"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Mercedes"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); fatherid = context.Categories.Where(p => p.Name == "Auto parts").Select(p => p.CategoryID).First(); c = new Category(); c.Name = "Personal"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Vans and Trucks"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Music and Education"; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); fatherid = context.Categories.Where(p => p.Name == "Music and Education").Select(p => p.CategoryID).First(); c = new Category(); c.Name = "Books"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "Music"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); fatherid = context.Categories.Where(p => p.Name == "Books").Select(p => p.CategoryID).First(); c = new Category(); c.Name = "Literature"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); c = new Category(); c.Name = "For children"; c.CategoryFatherID = fatherid; context.Categories.AddOrUpdate(p => p.Name, c); context.SaveChanges(); Models.Attribute a = new Models.Attribute(); a.Name = "fuel"; a.Type = "string"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Engine power"; a.Type = "double"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Engine capacity"; a.Type = "double"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Body type"; a.Type = "string"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Transmission"; a.Type = "string"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Country of origin"; a.Type = "string"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Mileage"; a.Type = "double"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Year"; a.Type = "int"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Color"; a.Type = "string"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Number of pages"; a.Type = "int"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); a = new Models.Attribute(); a.Name = "Publication Year"; a.Type = "int"; context.Attributes.AddOrUpdate(p => p.Name, a); context.SaveChanges(); int aid = context.Attributes.Where(p => p.Name == "fuel").Select(p => p.AttributeID).First(); AttributeValue av = new AttributeValue(); av.AttributeID = aid; av.Value = "gasoline"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "diesel"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "LPG"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "CNG and hybrid"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Body type").Select(p => p.AttributeID).First(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Cabriolet"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Sedan"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Coupe"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Pickup"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Hatchback"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Kombi"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "All-terrain"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Minibus"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Minivan"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "SUV"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Transmission").Select(p => p.AttributeID).First(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Manual"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Automatic"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Color").Select(p => p.AttributeID).First(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "White"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Black"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Gray"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Silver"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Blue"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Brown-Beige"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Red"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Green"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Yellow-Gold"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Different"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Country of origin").Select(p => p.AttributeID).First(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Poland"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Germany"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Belarus"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Netherlands"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Sweden"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "USA"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "United Kingdom"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); av = new AttributeValue(); av.AttributeID = aid; av.Value = "Different"; context.AttributeValues.AddOrUpdate(p => p.Value, av); context.SaveChanges(); int cid = context.Categories.Where(p => p.Name == "Cars").Select(p => p.CategoryID).First(); aid = context.Attributes.Where(p => p.Name == "fuel").Select(p => p.AttributeID).First(); CategoryAttribute ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Engine power").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Engine capacity").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Body type").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Transmission").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Country of origin").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Mileage").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Year").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Color").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); cid = context.Categories.Where(p => p.Name == "Books").Select(p => p.CategoryID).First(); aid = context.Attributes.Where(p => p.Name == "Number of pages").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); cid = context.Categories.Where(p => p.Name == "Literature").Select(p => p.CategoryID).First(); aid = context.Attributes.Where(p => p.Name == "Publication Year").Select(p => p.AttributeID).First(); ca = new CategoryAttribute(); ca.CategoryID = cid; ca.AttributeID = aid; context.CategoryAttributes.AddOrUpdate(p => new { p.AttributeID, p.CategoryID }, ca); context.SaveChanges(); Location l = new Location(); l.LocationName = "Białystok"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Białystok, Dziesięciny"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Białystok, Centrum"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Białystok, Piasta"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Białystok, Bema"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa, Mokotów"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa, Kabaty"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa, Młociny"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa, Stare Miasto"; context.Locations.AddOrUpdate(p => p.LocationName, l); l = new Location(); l.LocationName = "Warszawa, Śródmieście"; context.Locations.AddOrUpdate(p => p.LocationName, l); string uid = context.Users.Where(p => p.UserName == "slightom").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "Audi").Select(p => p.CategoryID).First(); Classified cl = new Classified(); cl.UserID = uid; cl.Name = "Audi 80 2.0 benzyna"; cl.Description = "Mam do sprzedania elegancki samochód Audi 80 rocznik 95, silnik 2.0 w benzynie."; cl.CategoryID = cid; cl.DateAdded = new DateTime(2016, 12, 12, 13, 45, 00); cl.Counter = 12; cl.Reported = ""; cl.Price = 6500; cl.State = "Used"; cl.CategoryPath = "Motoring >> Cars >> Audi"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); int clid = context.Classifieds.Where(p => p.Name == "Audi 80 2.0 benzyna").Select(p => p.ClassifiedID).First(); aid = context.Attributes.Where(p => p.Name == "fuel").Select(p => p.AttributeID).First(); ClassifiedAttribute cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "gasoline"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Engine power").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "90"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Engine capacity").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "2000"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Body type").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "Kombi"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Transmission").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "Manual"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Country of origin").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "Poland"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Mileage").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "275000"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Year").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "1995"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Color").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "Different"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); int lid = context.Locations.Where(p => p.LocationName == "Białystok, Dziesięciny").Select(p => p.LocationID).First(); ClassifiedLocation cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); PersonalizedCategory pc = new PersonalizedCategory(); cid = context.Categories.Where(p => p.Name == "Cars").Select(p => p.CategoryID).First(); pc.UserID = uid; pc.PriceMin = 5000; pc.PriceMax = 10000; pc.CategoryID = cid; pc.State = "----"; pc.Path = "Motoring >> Cars"; context.PersonalizedCategories.AddOrUpdate(p => new { p.UserID, p.CategoryID }, pc); context.SaveChanges(); int pcid = context.PersonalizedCategories.Where(p => p.Category.Name == "Cars").Select(p => p.PersonalizedCategoryID).First(); lid = context.Locations.Where(p => p.LocationName == "Białystok").Select(p => p.LocationID).First(); PCL pcl = new PCL(); pcl.PersonalizedCategoryID = pcid; pcl.LocationID = lid; context.PCLs.AddOrUpdate(p => new { p.PersonalizedCategoryID, p.LocationID }, pcl); context.SaveChanges(); Photo ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/audi80_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = false; ph.Path = "/Content/photos/audi80_1.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = false; ph.Path = "/Content/photos/audi80_2.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = false; ph.Path = "/Content/photos/audi80_3.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); /////////////////////////////////////////////// uid = context.Users.Where(p => p.UserName == "witek15").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "For Children").Select(p => p.CategoryID).First(); cl = new Classified(); cl.UserID = uid; cl.Name = "Król Lew (idealny stan)"; cl.Description = "Mam do sprzedania cudowną książkę 'Król Lew'."; cl.CategoryID = cid; cl.DateAdded = new DateTime(2017, 01, 01, 13, 45, 00); cl.Counter = 5; cl.Reported = ""; cl.Price = 15; cl.State = "Used"; cl.CategoryPath = "Music and Education >> Books >> For children"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Król Lew (idealny stan)").Select(p => p.ClassifiedID).First(); lid = context.Locations.Where(p => p.LocationName == "Białystok, Centrum").Select(p => p.LocationID).First(); cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/krolLew_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = false; ph.Path = "/Content/photos/krolLew_1.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Król Lew (idealny stan)").Select(p => p.ClassifiedID).First(); aid = context.Attributes.Where(p => p.Name == "Number of pages").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "120"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); /////////////////////////////////////////////////////////////// uid = context.Users.Where(p => p.UserName == "witek15").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "Books").Select(p => p.CategoryID).First(); cl = new Classified(); cl.UserID = uid; cl.Name = "Dziennikarz śledczy"; cl.Description = "Mam do sprzedania bardzo ciekawą książkę 'Dziennikarz śledczy'. Bohaterem książki jest Cezary Gmyz."; cl.CategoryID = cid; cl.DateAdded = new DateTime(2017, 01, 02, 13, 45, 00); cl.Counter = 9; cl.Reported = ""; cl.Price = 30; cl.State = "New"; cl.CategoryPath = "Music and Education >> Books"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Dziennikarz śledczy").Select(p => p.ClassifiedID).First(); lid = context.Locations.Where(p => p.LocationName == "Białystok, Bema").Select(p => p.LocationID).First(); cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/dziennikarzSledczy_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Dziennikarz śledczy").Select(p => p.ClassifiedID).First(); aid = context.Attributes.Where(p => p.Name == "Number of pages").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "220"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); /////////////////////////////////////////////////////////////// uid = context.Users.Where(p => p.UserName == "witek15").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "Literature").Select(p => p.CategoryID).First(); cl = new Classified(); cl.UserID = uid; cl.Name = "Call of the wild"; cl.Description = "Mam do sprzedania bardzo ciekawą książkę 'Zew Krwi'."; cl.CategoryID = cid; cl.DateAdded = new DateTime(2017, 01, 03, 13, 45, 00); cl.Counter = 19; cl.Reported = ""; cl.Price = 29.99; cl.State = "New"; cl.CategoryPath = "Music and Education >> Books >> Literature"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Call of the wild").Select(p => p.ClassifiedID).First(); lid = context.Locations.Where(p => p.LocationName == "Białystok, Bema").Select(p => p.LocationID).First(); cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/callOfTheWild_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Call of the wild").Select(p => p.ClassifiedID).First(); aid = context.Attributes.Where(p => p.Name == "Number of pages").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "184"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); aid = context.Attributes.Where(p => p.Name == "Publication Year").Select(p => p.AttributeID).First(); cla = new ClassifiedAttribute(); cla.ClassifiedID = clid; cla.AttributeID = aid; cla.Value = "2010"; context.ClassifiedAttributes.AddOrUpdate(p => new { p.ClassifiedID, p.AttributeID }, cla); context.SaveChanges(); /////////////////////////////////////////////////////////////// uid = context.Users.Where(p => p.UserName == "jola17").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "Music and Education").Select(p => p.CategoryID).First(); cl = new Classified(); cl.UserID = uid; cl.Name = "CORT SFX-E NS Gitara elektroakustyczna"; cl.Description = "Mam do sprzedania bardzo ładnie brzmiącą gitarę firmy CORT"; cl.CategoryID = cid; cl.DateAdded = new DateTime(2017, 01, 02, 12, 45, 00); cl.Counter = 81; cl.Reported = ""; cl.Price = 850.00; cl.State = "Used"; cl.CategoryPath = "Music and Education"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "CORT SFX-E NS Gitara elektroakustyczna").Select(p => p.ClassifiedID).First(); lid = context.Locations.Where(p => p.LocationName == "Warszawa, Mokotów").Select(p => p.LocationID).First(); cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/gitaracort_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); /////////////////////////////////////////////////////////////// uid = context.Users.Where(p => p.UserName == "wiktor500").Select(p => p.Id).First(); cid = context.Categories.Where(p => p.Name == "Personal").Select(p => p.CategoryID).First(); cl = new Classified(); cl.UserID = uid; cl.Name = "Drzwi lexus is 200 is 300"; cl.Description = "Drzwi lexus is 200 is 300. Możliwość wysyłki"; cl.CategoryID = cid; cl.DateAdded = new DateTime(2017, 01, 07, 12, 45, 00); cl.Counter = 21; cl.Reported = ""; cl.Price = 120; cl.State = "Used"; cl.CategoryPath = "Motoring >> Auto parts >> Personal"; context.Classifieds.AddOrUpdate(p => p.Name, cl); context.SaveChanges(); clid = context.Classifieds.Where(p => p.Name == "Drzwi lexus is 200 is 300").Select(p => p.ClassifiedID).First(); lid = context.Locations.Where(p => p.LocationName == "Warszawa, Mokotów").Select(p => p.LocationID).First(); cll = new ClassifiedLocation(); cll.ClassifiedID = clid; cll.LocationID = lid; context.ClassifiedLocations.AddOrUpdate(p => new { p.LocationID, p.ClassifiedID }, cll); context.SaveChanges(); ph = new Photo(); ph.ClassifiedID = clid; ph.MainPhoto = true; ph.Path = "/Content/photos/drzwi_main.jpg"; context.Photos.AddOrUpdate(p => p.Path, ph); context.SaveChanges(); }