public ActionResult Edit([Bind(Include = "PersonalizedCategoryID,CategoryID,UserID,PriceMin,PriceMax,State,Path")] PersonalizedCategory personalizedCategory, Location l)
        {
            if (ModelState.IsValid)
            {
                string pom = db.Categories.Where(p => p.CategoryID == personalizedCategory.CategoryID).Select(p => p.Name).First().ToString();
                personalizedCategory.Path            = categoryPath(pom);
                db.Entry(personalizedCategory).State = EntityState.Modified;
                db.SaveChanges();


                #region editing classifiedLocation

                if (l.LocationName != "----") // jesli wybrano loc
                {
                    PCL    pcl;
                    string lid = db.Locations.Where(p => p.LocationName == l.LocationName).Select(p => p.LocationID).First().ToString();

                    bool contactExists = db.PCLs.Any(p => p.PersonalizedCategoryID == personalizedCategory.PersonalizedCategoryID);
                    if (contactExists) // jesli wczesniej istnial
                    {
                        pcl            = db.PCLs.Where(p => p.PersonalizedCategoryID == personalizedCategory.PersonalizedCategoryID).First();
                        pcl.LocationID = Int32.Parse(lid);
                        db.SaveChanges();
                    }
                    else
                    {
                        pcl = new PCL();
                        pcl.PersonalizedCategoryID = personalizedCategory.PersonalizedCategoryID;
                        pcl.LocationID             = Int32.Parse(lid);
                        db.PCLs.Add(pcl);
                        db.SaveChanges();
                    }
                }
                else
                {
                    bool contactExists = db.PCLs.Any(p => p.PersonalizedCategoryID == personalizedCategory.PersonalizedCategoryID);
                    if (contactExists) // jesli wczesniej istnial
                    {
                        PCL pcl;
                        pcl = db.PCLs.Where(p => p.PersonalizedCategoryID == personalizedCategory.PersonalizedCategoryID).First();
                        db.PCLs.Remove(pcl);
                        db.SaveChanges();
                    }
                }
                #endregion

                if (User.IsInRole("Admin"))
                {
                    return(RedirectToAction("Index"));
                }
                return(RedirectToAction("MyCategories", "Home"));
            }
            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", personalizedCategory.CategoryID);
            ViewBag.UserID     = new SelectList(db.Users, "Id", "Email", personalizedCategory.UserID);
            return(View(personalizedCategory));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            PersonalizedCategory personalizedCategory = db.PersonalizedCategories.Find(id);

            db.PersonalizedCategories.Remove(personalizedCategory);
            db.SaveChanges();
            if (User.IsInRole("Admin"))
            {
                return(RedirectToAction("Index"));
            }


            return(RedirectToAction("MyCategories", "Home"));
        }
        // GET: PersonalizedCategories/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PersonalizedCategory personalizedCategory = db.PersonalizedCategories.Find(id);

            if (personalizedCategory == null)
            {
                return(HttpNotFound());
            }
            return(View(personalizedCategory));
        }
        // GET: PersonalizedCategories/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            PersonalizedCategory personalizedCategory = db.PersonalizedCategories.Find(id);

            if (personalizedCategory == null)
            {
                return(HttpNotFound());
            }

            if (!User.Identity.GetUserId().Equals((personalizedCategory.User.Id)) && !User.IsInRole("Admin"))
            {
                return(RedirectToAction("Index"));
            }

            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", personalizedCategory.CategoryID);
            ViewBag.UserID     = new SelectList(db.Users, "Id", "Email", personalizedCategory.UserID);

            IEnumerable <SelectListItem> lss;
            List <SelectListItem>        ls = new List <SelectListItem>
            {
                new SelectListItem()
                {
                    Text = "New", Value = "1"
                },
                new SelectListItem()
                {
                    Text = "Used", Value = "2"
                },
                new SelectListItem()
                {
                    Text = "----", Value = "3"
                }
            };

            lss           = ls;
            ViewBag.State = new SelectList(lss, "Text", "Text", personalizedCategory.State);

            return(View(personalizedCategory));
        }
        // GET: PersonalizedCategories/Create
        public ActionResult Create()
        {
            if (!User.IsInRole("Admin"))
            {
                ViewBag.UserID = new SelectList(db.Users, "Id", "Email", User.Identity.GetUserName().ToString());
            }
            else
            {
                ViewBag.UserID = new SelectList(db.Users, "Id", "Email");
            }

            PersonalizedCategory pc = new PersonalizedCategory();

            pc.CategoryID = 0;
            pc.Path       = "";


            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name");

            IEnumerable <SelectListItem> lss;
            List <SelectListItem>        ls = new List <SelectListItem>
            {
                new SelectListItem()
                {
                    Text = "----", Value = "3", Selected = true
                },
                new SelectListItem()
                {
                    Text = "New", Value = "1"
                },
                new SelectListItem()
                {
                    Text = "Used", Value = "2"
                }
            };

            lss           = ls;
            ViewBag.State = new SelectList(lss, "Text", "Text");


            return(View(pc));
        }
        // GET: PersonalizedCategories/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }



            PersonalizedCategory personalizedCategory = db.PersonalizedCategories.Find(id);

            if (personalizedCategory == null)
            {
                return(HttpNotFound());
            }

            if (!User.Identity.GetUserId().Equals(personalizedCategory.User.Id) && !User.IsInRole("Admin"))
            {
                return(RedirectToAction("Index"));
            }

            return(View(personalizedCategory));
        }
        public ActionResult Create([Bind(Include = "PersonalizedCategoryID,CategoryID,UserID,PriceMin,PriceMax,State,Path")] PersonalizedCategory personalizedCategory, Location l)
        {
            if (ModelState.IsValid)
            {
                if (!User.IsInRole("Admin"))
                {
                    personalizedCategory.UserID = User.Identity.GetUserId();
                }
                string pom = db.Categories.Where(p => p.CategoryID == personalizedCategory.CategoryID).Select(p => p.Name).First().ToString();
                personalizedCategory.Path = categoryPath(pom);

                bool contactExists = db.PersonalizedCategories.Any(p => p.Path == personalizedCategory.Path && p.UserID == personalizedCategory.UserID);
                if (contactExists) // jesli wczesniej istnial
                {
                    ViewBag.ErrorP     = "You already have Favourite Category '" + personalizedCategory.Path + "' in your Collection!";
                    ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", personalizedCategory.CategoryID);
                    ViewBag.UserID     = new SelectList(db.Users, "Id", "Email", personalizedCategory.UserID);

                    IEnumerable <SelectListItem> lss2;
                    List <SelectListItem>        ls2 = new List <SelectListItem>
                    {
                        new SelectListItem()
                        {
                            Text = "New", Value = "1"
                        },
                        new SelectListItem()
                        {
                            Text = "Used", Value = "2"
                        },
                        new SelectListItem()
                        {
                            Text = "----", Value = "3", Selected = true
                        }
                    };
                    lss2          = ls2;
                    ViewBag.State = new SelectList(lss2, "Text", "Text");

                    return(View(personalizedCategory));
                }

                db.PersonalizedCategories.Add(personalizedCategory);
                db.SaveChanges();



                #region adding classifiedLocation
                PCL pcl = new PCL();
                pcl.PersonalizedCategoryID = personalizedCategory.PersonalizedCategoryID;
                if (l.LocationName != "----")
                {
                    string lid = db.Locations.Where(p => p.LocationName == l.LocationName).Select(p => p.LocationID).First().ToString();
                    pcl.LocationID = Int32.Parse(lid);
                    db.PCLs.Add(pcl);
                    db.SaveChanges();
                }
                #endregion



                if (User.IsInRole("Admin"))
                {
                    return(RedirectToAction("Index"));
                }
                return(RedirectToAction("MyCategories", "Home"));
            }

            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", personalizedCategory.CategoryID);
            ViewBag.UserID     = new SelectList(db.Users, "Id", "Email", personalizedCategory.UserID);

            IEnumerable <SelectListItem> lss;
            List <SelectListItem>        ls = new List <SelectListItem>
            {
                new SelectListItem()
                {
                    Text = "New", Value = "1"
                },
                new SelectListItem()
                {
                    Text = "Used", Value = "2"
                },
                new SelectListItem()
                {
                    Text = "----", Value = "3", Selected = true
                }
            };
            lss           = ls;
            ViewBag.State = new SelectList(lss, "Text", "Text");



            return(View(personalizedCategory));
        }
예제 #8
0
        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();
        }