protected override void Seed(GarageContext context)
{
IList <BrandModel> brandModels = new List <BrandModel>
{
new BrandModel()
{
Name = "Abarth"
},
new BrandModel()
{
Name = "Audi"
},
new BrandModel()
{
Name = "BMW"
},
new BrandModel()
{
Name = "Citroen"
},
new BrandModel()
{
Name = "Maserati"
},
new BrandModel()
{
Name = "Mercedes"
}
};
BrandModel brand1 = new BrandModel()
{
Name = "Ford"
};
OwnerModels user1 = new OwnerModels()
{
FirstName = "Mateusz", LastName = "Wypych", Email = "*****@*****.**", PhoneNo = 506666666, ID = 1
};
DateTime newDAte = DateTime.Now;
IList <CarModels> carModels = new List <CarModels>
{
new CarModels()
{
Brand = brand1, ID = 1, Model = "Ka", Owner = user1, BrandID = 7, PurchaseDate = newDAte,
OwnerId = 1, PurchasePrice = 30000, Series = 1, VIN = 4445556667, Year = 1998, SaleDate = newDAte
}
};
foreach (var item in brandModels)
{
context.Brand.Add(item);
}
context.SaveChanges();
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
OwnerModels owner = new OwnerModels {
Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
//OwnerController ownerController=new OwnerController();
//ownerController.Create(owner);
// Aby uzyskać więcej informacji o sposobie włączania potwierdzania konta i resetowaniu hasła, odwiedź stronę https://go.microsoft.com/fwlink/?LinkID=320771
// Wyślij wiadomość e-mail z tym łączem
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Potwierdź konto", "Potwierdź konto, klikając <a href=\"" + callbackUrl + "\">tutaj</a>");
return(RedirectToAction("Create", "Owner"));
}
AddErrors(result);
}
// Dotarcie do tego miejsca wskazuje, że wystąpił błąd, wyświetl ponownie formularz
return(View(model));
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
using (GarageContext db = new GarageContext())
{
var m = new OwnerModels {
Email = model.Email, Name = model.Name, Surname = model.Surname, PhoneNumber = model.PhoneNumber
};
m.UserID = user.Id;
db.Owner.Add(m);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult DeleteConfirmed(int id)
{
OwnerModels ownerModels = db.Owner.Find(id);
db.Owner.Remove(ownerModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Name,LastName,PhoneNo,Email")] OwnerModels ownerModels)
{
if (ModelState.IsValid)
{
db.Entry(ownerModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ownerModels));
}
// GET: RepairsModels/Create
public ActionResult Create()
{
string UserEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == UserEmail);
List <CarModels> Car = db.Car.Where(a => a.OwnerID == owner.ID).ToList();
ViewBag.CarId = new SelectList(Car, "ID", "Make");
return(View());
}
// GET: AdvertismentModels/Create
public ActionResult Create()
{
string userEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == userEmail);
int ownerId = owner.ID;
List <CarModels> cars = db.Car.Where(c => c.OwnerID == ownerId).ToList();
ViewBag.CarId = new SelectList(cars, "ID", "Make");
return(View());
}
public ActionResult Create([Bind(Include = "ID,UserID,Name,Surname,PhoneNumber,Email")] OwnerModels ownerModels)
{
if (ModelState.IsValid)
{
db.Owner.Add(ownerModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ownerModels));
}
public ActionResult Create([Bind(Include = "ID,Name,LastName,PhoneNo,Email")] OwnerModels ownerModels)
{
if (ModelState.IsValid)
{
db.Owner.Add(ownerModels);
db.SaveChanges();
return(RedirectToAction("Create", "Car"));
}
return(View(ownerModels));
}
public ActionResult Create(int?id)
{
if (id != null)
{
CarModels car = db.Cars.Where(c => c.ID == id).FirstOrDefault();
OwnerModels owner = db.Owners.Where(o => o.Cars.Contains(car)).FirstOrDefault();
RepairModels repair = db.Repairs.Where(r => r.Car.Owner == owner).FirstOrDefault();
return(View(repair));
}
ViewBag.CarId = new SelectList(db.Cars, "ID", "Model");
return(View());
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,PhoneNo,Email")] OwnerModels ownerModels)
{
string currentMail = User.Identity.GetUserName();
if (ModelState.IsValid)
{
ownerModels.Email = currentMail;
db.Entry(ownerModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ownerModels));
}
public ActionResult Edit([Bind(Include = "ID,Make,Model,Year,VIN,Name,Picture,PurchaseDate,PurchaseAmount,SalesDate,SalesAmount,OwnerID")] CarModels carModels)
{
if (ModelState.IsValid)
{
string email = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(o => o.Email == email);
carModels.OwnerID = owner.ID;
db.Entry(carModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carModels));
}
// GET: Owner/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OwnerModels ownerModels = db.Owner.Find(id);
if (ownerModels == null)
{
return(HttpNotFound());
}
return(View(ownerModels));
}
private void SeedOwner(GarageContext context)
{
for (int i = 0; i < 10; i++)
{
var owners = new OwnerModels
{
FirstName = "Imiê" + i.ToString(),
LastName = "Nazwisko" + i.ToString(),
PhoneNum = "123456789" + i,
Mail = "mail" + i.ToString() + "@poczta.pl"
};
context.Owner.Add(owners);
}
context.SaveChanges();
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
OwnerModels owner = db.Owners.Find(id);
if (owner == null)
{
return(HttpNotFound());
}
return(View(owner));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,PhoneNo,Email")] OwnerModels ownerModels)
{
string currentMail = User.Identity.GetUserName();
if (ModelState.IsValid)
{
ownerModels.Email = currentMail;
db.Owner.Add(ownerModels);
db.SaveChanges();
return(RedirectToAction("Index", "OwnerModels"));
}
return(View(ownerModels));
}
public ActionResult Buy([Bind(Include = "ID,CarId,Brand,Name,PartNumber,PurchasePrice,SellPrice,PurchaseDate,SaleDate")] PartsModels partsModels)
{
//if (ModelState.IsValid)
//{
DateTime newDate = DateTime.Now;
OwnerModels ownerId = db.Owners.Where(o => o.Email == User.Identity.Name).FirstOrDefault();
partsModels.SaleDate = newDate;
partsModels.Owner = ownerId.ID;
db.Parts.Add(partsModels);
db.SaveChanges();
return(RedirectToAction("IndexUser"));
//}
//return RedirectToAction("IndexUser");
}
public ActionResult Create([Bind(Include = "ID,CarId,Active")] AdvertismentModels advertismentModels)
{
if (ModelState.IsValid)
{
db.Advertisment.Add(advertismentModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
string userEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == userEmail);
int ownerId = owner.ID;
List <CarModels> cars = db.Car.Where(c => c.OwnerID == ownerId).ToList();
ViewBag.CarId = new SelectList(cars, "ID", "Make", advertismentModels.CarId);
return(View(advertismentModels));
}
public ActionResult Create([Bind(Include = "ID,CarId,Name,Description,RepairPrice")] RepairsModels repairsModels)
{
if (ModelState.IsValid)
{
db.Repair.Add(repairsModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
string UserEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == UserEmail);
List <CarModels> Car = db.Car.Where(a => a.OwnerID == owner.ID).ToList();
ViewBag.CarId = new SelectList(Car, "ID", "Make", repairsModels.CarId);
return(View(repairsModels));
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,PhoneNo,Email")] OwnerModels owner)
{
if (ModelState.IsValid)
{
db.Entry(owner).State = EntityState.Modified;
db.SaveChanges();
if (User.IsInRole("admin"))
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("IndexUser"));
}
}
return(View(owner));
}
public ActionResult Create([Bind(Include = "FirstName, LastName, PhoneNo, Email")] OwnerModels owner)
{
if (ModelState.IsValid)
{
db.Owners.Add(owner);
db.SaveChanges();
if (User.IsInRole("admin"))
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("IndexUser"));
}
}
return(View(owner));
}
// GET: Car/Create
public ActionResult Create()
{
string query = "SELECT * FROM OwnerModels WHERE Email = @email";
try
{
OwnerModels owner = db.Owner.SqlQuery(query, new SqlParameter("@email", User.Identity.Name)).FirstOrDefault();
Console.Out.WriteLine(User.Identity.Name);
ViewBag.OwnerId = owner.ID;
ViewBag.exist = true;
}
catch (Exception e)
{
ViewBag.exist = false;
}
return(View());
}
// GET: Car
public ActionResult Index()
{
string query = "SELECT * FROM OwnerModels WHERE Email = @email";
try
{
OwnerModels owner = db.Owner.SqlQuery(query, new SqlParameter("@email", User.Identity.Name)).FirstOrDefault();
Console.Out.WriteLine(User.Identity.Name);
ViewBag.OwnerId = owner.ID;
ViewBag.exist = true;
var cars = db.Cars.Include(c => c.Owner).Where(c => c.OwnerID == owner.ID);
return(View(cars.ToList()));
}
catch (Exception e)
{
ViewBag.exist = false;
return(View());
}
}
// GET: AdvertismentModels/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdvertismentModels advertismentModels = db.Advertisment.Find(id);
if (advertismentModels == null)
{
return(HttpNotFound());
}
string userEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == userEmail);
int ownerId = owner.ID;
List <CarModels> cars = db.Car.Where(c => c.OwnerID == ownerId).ToList();
ViewBag.CarId = new SelectList(cars, "ID", "Make", advertismentModels.CarId);
return(View(advertismentModels));
}
// GET: RepairsModels/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RepairsModels repairsModels = db.Repair.Find(id);
if (repairsModels == null)
{
return(HttpNotFound());
}
string UserEmail = User.Identity.GetUserName();
OwnerModels owner = db.Owner.Single(a => a.Email == UserEmail);
List <CarModels> Car = db.Car.Where(a => a.OwnerID == owner.ID).ToList();
ViewBag.CarId = new SelectList(Car, "ID", "Make", repairsModels.CarId);
return(View(repairsModels));
}
