public PartialViewResult GenerateAllAttributes(int?id)
{
AllAtributesModel aam = new AllAtributesModel();
aam.Engine_power = 100;
aam.Enginie_capacity = 1.9;
aam.Mileage = 1000000;
aam.Number_of_pages = 100;
aam.Year = 2017;
aam.Publication_Year = 2017;
ViewBag.fuel = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 1), "Value", "Value");
ViewBag.Body_type = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 4), "Value", "Value");
ViewBag.Transmission = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 5), "Value", "Value");
ViewBag.Country_of_origin = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 6), "Value", "Value");
ViewBag.Color = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 9), "Value", "Value");
if (id != null)
{
Classified c = db.Classifieds.Find(id);
var list = giveMeSelectedAttributes2(c.Category.Name);
foreach (string s in list)
{
string ss = whiteSpacesAgain(s);
ClassifiedAttribute ca = db.ClassifiedAttributes.Where(p => p.ClassifiedID == c.ClassifiedID && p.Attribute.Name == ss).First();
switch (s)
{
case "fuel": aam.fuel = ca.Value; ViewBag.fuel = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 1), "Value", "Value", aam.fuel); break;
case "Engine_power": aam.Engine_power = Double.Parse(ca.Value); break;
case "Engine_capacity": aam.Enginie_capacity = Double.Parse(ca.Value); break;
case "Body_type": aam.Body_type = ca.Value; ViewBag.Body_type = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 4), "Value", "Value", aam.Body_type); break;
case "Transmission": aam.Transmission = ca.Value; ViewBag.Transmission = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 5), "Value", "Value", aam.Transmission); break;
case "Country_of_origin": aam.Country_of_origin = ca.Value; ViewBag.Country_of_origin = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 6), "Value", "Value", aam.Country_of_origin); break;
case "Mileage": aam.Mileage = Double.Parse(ca.Value); break;
case "Year": aam.Year = Int32.Parse(ca.Value); break;
case "Color": aam.Color = ca.Value; ViewBag.Color = new SelectList(db.AttributeValues.Where(p => p.AttributeID == 9), "Value", "Value", aam.Color); break;
case "Number_of_pages": aam.Number_of_pages = Int32.Parse(ca.Value); break;
case "Publication_Year": aam.Publication_Year = Int32.Parse(ca.Value); break;
}
}
ViewBag.edit = "true";
}
return(PartialView("GenerateAllAttributes", aam));
}
public ActionResult Edit([Bind(Include = "ClassifiedID,UserID,Name,Description,CategoryID,DateAdded,Price,State,Counter,Reported")] Classified classified, AllAtributesModel aam, Location l, HttpPostedFileBase upload0, HttpPostedFileBase upload1, HttpPostedFileBase upload2, HttpPostedFileBase upload3)
{
if (ModelState.IsValid)
{
ViewBag.badWord = consistBadWord(classified.Description);
if (ViewBag.badWord != "")
{
return(View("BadWord"));
}
string pom = db.Categories.Where(p => p.CategoryID == classified.CategoryID).Select(p => p.Name).First().ToString();
classified.CategoryPath = categoryPath(pom);
db.Entry(classified).State = EntityState.Modified;
db.SaveChanges();
ClassifiedLocation cl = db.ClassifiedLocations.Where(p => p.ClassifiedID == classified.ClassifiedID).First();
string lid = db.Locations.Where(p => p.LocationName == l.LocationName).Select(p => p.LocationID).First().ToString();
cl.LocationID = Int32.Parse(lid);
db.SaveChanges();
if (upload0 != null)
{
//remove old
var old = findOld(classified.ClassifiedID, "upload0");
var photoName = old.Path;
string fullPath = Request.MapPath(photoName);
if (!old.Path.Equals("default.jpg"))
{
System.IO.File.Delete(fullPath);
db.Photos.Remove(old);
db.SaveChanges();
//add new
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload0.jpg");
//zapis
upload0.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload0.jpg";
p.MainPhoto = true;
db.Photos.Add(p);
db.SaveChanges();
}
else
{
//add new
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload0.jpg");
//zapis
upload0.SaveAs(path);
old.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload0.jpg";
old.MainPhoto = true;
db.SaveChanges();
}
}
else
{
}
if (upload1 != null)
{
//remove old
var old = findOld(classified.ClassifiedID, "upload1");
if (old != null)
{
var photoName = old.Path;
string fullPath = Request.MapPath(photoName);
System.IO.File.Delete(fullPath);
db.Photos.Remove(old);
db.SaveChanges();
//add new
}
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload1.jpg");
//zapis
upload1.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload1.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
if (upload2 != null)
{
//remove old
var old = findOld(classified.ClassifiedID, "upload2");
if (old != null)
{
var photoName = old.Path;
string fullPath = Request.MapPath(photoName);
System.IO.File.Delete(fullPath);
db.Photos.Remove(old);
db.SaveChanges();
//add new
}
//add new
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload2.jpg");
//zapis
upload2.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload2.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
if (upload3 != null)
{
//remove old
var old = findOld(classified.ClassifiedID, "upload3");
if (old != null)
{
var photoName = old.Path;
string fullPath = Request.MapPath(photoName);
System.IO.File.Delete(fullPath);
db.Photos.Remove(old);
db.SaveChanges();
//add new
}
//add new
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload3.jpg");
//zapis
upload3.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload3.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
var list2 = db.ClassifiedAttributes.Where(p => p.ClassifiedID == classified.ClassifiedID).ToList();
foreach (var i in list2)
{
db.ClassifiedAttributes.Remove(i);
}
db.SaveChanges();
var list = giveMeSelectedAttributes(classified.CategoryID);
foreach (string s in list)
{
ClassifiedAttribute ca = new ClassifiedAttribute();
ca.ClassifiedID = classified.ClassifiedID;
string ss = HomeController.whiteSpacesAgain(s);
string aid = db.Attributes.Where(p => p.Name == ss).Select(p => p.AttributeID).First().ToString();
ca.AttributeID = Int32.Parse(aid);
switch (s)
{
case "fuel": ca.Value = aam.fuel; break;
case "Engine_power": ca.Value = aam.Engine_power.ToString(); break;
case "Engine_capacity": ca.Value = aam.Enginie_capacity.ToString(); break;
case "Body_type": ca.Value = aam.Body_type; break;
case "Transmission": ca.Value = aam.Transmission; break;
case "Country_of_origin": ca.Value = aam.Country_of_origin; break;
case "Mileage": ca.Value = aam.Mileage.ToString(); break;
case "Year": ca.Value = aam.Year.ToString(); break;
case "Color": ca.Value = aam.Color; break;
case "Number_of_pages": ca.Value = aam.Number_of_pages.ToString(); break;
case "Publication_Year": ca.Value = aam.Publication_Year.ToString(); break;
}
db.ClassifiedAttributes.Add(ca);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", classified.CategoryID);
ViewBag.UserID = new SelectList(db.Users, "Id", "Email", classified.UserID);
return(View(classified));
}
public ActionResult Create([Bind(Include = "ClassifiedID,UserID,Name,Description,CategoryID,DateAdded,Price,State,Counter,Reported")] Classified classified, AllAtributesModel aam, Location l, HttpPostedFileBase upload0, HttpPostedFileBase upload1, HttpPostedFileBase upload2, HttpPostedFileBase upload3)
{
if (ModelState.IsValid && classified.CategoryID != 0)
{
classified.DateAdded = DateTime.Now;
classified.UserID = User.Identity.GetUserId();
ViewBag.badWord = consistBadWord(classified.Description);
if (ViewBag.badWord != "")
{
return(View("BadWord"));
}
string pom = db.Categories.Where(p => p.CategoryID == classified.CategoryID).Select(p => p.Name).First().ToString();
classified.CategoryPath = categoryPath(pom);
db.Classifieds.Add(classified);
db.SaveChanges();
#region adding classifiedLocation
ClassifiedLocation cl = new ClassifiedLocation();
cl.ClassifiedID = classified.ClassifiedID;
string lid = db.Locations.Where(p => p.LocationName == l.LocationName).Select(p => p.LocationID).First().ToString();
cl.LocationID = Int32.Parse(lid);
db.ClassifiedLocations.Add(cl);
db.SaveChanges();
#endregion
#region adding photos
if (upload0 != null)
{
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload0.jpg");
//zapis
upload0.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload0.jpg";
p.MainPhoto = true;
db.Photos.Add(p);
db.SaveChanges();
}
else
{
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
p.Path = "/Content/photos/default.jpg";
p.MainPhoto = true;
db.Photos.Add(p);
db.SaveChanges();
}
if (upload1 != null)
{
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload1.jpg");
//zapis
upload1.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload1.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
if (upload2 != null)
{
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload2.jpg");
//zapis
upload2.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload2.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
if (upload3 != null)
{
Photo p = new Photo();
p.ClassifiedID = classified.ClassifiedID;
//pelny sciezka do pliku
var path = Path.Combine(Server.MapPath("~/Content/photos"), classified.ClassifiedID.ToString() + "_upload3.jpg");
//zapis
upload3.SaveAs(path);
p.Path = "/Content/photos/" + classified.ClassifiedID.ToString() + "_upload3.jpg";
p.MainPhoto = false;
db.Photos.Add(p);
db.SaveChanges();
}
#endregion
#region adding classifiedAttributes
var list = giveMeSelectedAttributes(classified.CategoryID);
foreach (string s in list)
{
ClassifiedAttribute ca = new ClassifiedAttribute();
ca.ClassifiedID = classified.ClassifiedID;
string ss = HomeController.whiteSpacesAgain(s);
string aid = db.Attributes.Where(p => p.Name == ss).Select(p => p.AttributeID).First().ToString();
ca.AttributeID = Int32.Parse(aid);
switch (s)
{
case "fuel": ca.Value = aam.fuel; break;
case "Engine_power": ca.Value = aam.Engine_power.ToString(); break;
case "Engine_capacity": ca.Value = aam.Enginie_capacity.ToString(); break;
case "Body_type": ca.Value = aam.Body_type; break;
case "Transmission": ca.Value = aam.Transmission; break;
case "Country_of_origin": ca.Value = aam.Country_of_origin; break;
case "Mileage": ca.Value = aam.Mileage.ToString(); break;
case "Year": ca.Value = aam.Year.ToString(); break;
case "Color": ca.Value = aam.Color; break;
case "Number_of_pages": ca.Value = aam.Number_of_pages.ToString(); break;
case "Publication_Year": ca.Value = aam.Publication_Year.ToString(); break;
}
db.ClassifiedAttributes.Add(ca);
db.SaveChanges();
}
#endregion
return(RedirectToAction("Index"));
}
if (classified.CategoryID == 0)
{
ViewBag.Category0 = "You didn't choose Category!";
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", classified.CategoryID);
ViewBag.UserID = new SelectList(db.Users, "Id", "Email", classified.UserID);
IEnumerable <SelectListItem> lss;
List <SelectListItem> ls = new List <SelectListItem>
{
new SelectListItem()
{
Text = "New", Value = "1", Selected = true
},
new SelectListItem()
{
Text = "Used", Value = "2"
}
};
lss = ls;
ViewBag.State = new SelectList(lss, "Text", "Text");
return(View(classified));
}
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();
}