public ActionResult Index(int?brand, int?model)
{
JivivContext context = new JivivContext();
var models = context.Models.Where(x => x.BrandId == brand).ToList();
var brands = context.Brands.ToList();
ViewBag.Brands = new SelectList(brands, "Id", "Name");
ViewBag.Models = new SelectList(models, "Id", "Name");
var detail = new DetailSaleInformation();
var lstBrands = new List <Brand>();
var lstModels = new List <CarModel>();
var lstUsers = new List <User>();
var sales = context.Sales.Where(x => x.BrandId == brand && x.ModelId == model).ToList();
foreach (var item in sales)
{
lstBrands.Add(context.Brands.Find(item.BrandId));
lstModels.Add(context.Models.Find(item.ModelId));
lstUsers.Add(context.Users.Find(item.UserId));
}
detail.Brands = lstBrands;
detail.Models = lstModels;
detail.Users = lstUsers;
detail.Sales = sales;
return(View(detail));
}
public ActionResult EditModel(int id)
{
JivivContext context = new JivivContext();
var model = context.Models.Single(x => x.Id == id);
return(View(model));
}
public ActionResult EditBrand(int id)
{
JivivContext context = new JivivContext();
var brand = context.Brands.Single(x => x.Id == id);
return(View(brand));
}
public ActionResult BrandDetail()
{
JivivContext context = new JivivContext();
var brands = context.Brands.ToList();
return(View(brands));
}
public ActionResult SellCar(int?brand, int?model, decimal?price)
{
JivivContext context = new JivivContext();
var brands = context.Brands.ToList();
var models = context.Models.Where(x => x.BrandId == brand).ToList();
ViewBag.Brands = new SelectList(brands, "Id", "Name");
ViewBag.Models = new SelectList(models, "Id", "Name");
if (price == null)
{
ViewBag.Message = "Please enter price";
}
if (brand != null && model != null && price != null)
{
Sale sale = new Sale();
sale.BrandId = brand ?? default(int);
sale.ModelId = model ?? default(int);
sale.UserId = Convert.ToInt32(Session["userId"]);
sale.Price = price ?? 0;
context.Sales.Add(sale);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult CreateModel()
{
JivivContext context = new JivivContext();
var brands = context.Brands.ToList();
ViewBag.brandName = new SelectList(brands, "Id", "Name");
return(View());
}
public ActionResult ModelDetail(int?brand)
{
JivivContext context = new JivivContext();
var models = context.Models.Where(x => x.BrandId == brand).ToList();
var brands = context.Brands.ToList();
ViewBag.Brands = new SelectList(brands, "Id", "Name");
return(View(models));
}
public ActionResult Register(User user)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
context.Users.Add(user);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult CreateBrand(Brand brand)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
context.Brands.Add(brand);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult CreateModel(CarModel model)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
context.Models.Add(model);
context.SaveChanges();
return(RedirectToAction("ModelDetail", new { @brand = model.BrandId }));
}
return(View());
}
public ActionResult EditBrand(Brand brand)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
var updatedBrand = context.Brands.Find(brand.Id);
updatedBrand.Name = brand.Name;
context.SaveChanges();
return(RedirectToAction("BrandDetail"));
}
return(View(brand));
}
public ActionResult EditModel(CarModel mod)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
var updatedModel = context.Models.Find(mod.Id);
updatedModel.Name = mod.Name;
context.SaveChanges();
return(RedirectToAction("ModelDetail", new { @brand = mod.BrandId }));
}
return(View());
}
public ActionResult DeleteModel(int id)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
var deletedValue = context.Models.Find(id);
int brandId = deletedValue.BrandId;
context.Models.Remove(deletedValue);
context.SaveChanges();
return(RedirectToAction("ModelDetail", new { @brand = brandId }));
}
return(View());
}
public ActionResult DeleteBrand(int id)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
var models = context.Models.Where(x => x.BrandId == id).ToList();
foreach (var mod in models)
{
context.Models.Remove(mod);
context.SaveChanges();
}
var deletedValue = context.Brands.Find(id);
context.Brands.Remove(deletedValue);
context.SaveChanges();
return(RedirectToAction("BrandDetail"));
}
return(View());
}
public ActionResult UserProfile(int id)
{
var detail = new DetailSaleInformation();
var lstBrands = new List <Brand>();
var lstModels = new List <CarModel>();
JivivContext context = new JivivContext();
var sales = context.Sales.Where(x => x.UserId == id).ToList();
foreach (var item in sales)
{
lstBrands.Add(context.Brands.Find(item.BrandId));
lstModels.Add(context.Models.Find(item.ModelId));
}
detail.Brands = lstBrands;
detail.Models = lstModels;
detail.Sales = sales;
return(View(detail));
}
public ActionResult Index(User user)
{
if (ModelState.IsValid)
{
JivivContext context = new JivivContext();
try
{
var loginUser = context.Users.Single(x => x.Username == user.Username && x.Password == user.Password);
Session["userId"] = loginUser.Id;
ViewBag.Message = null;
return(RedirectToAction("UserProfile", "Sale", new { @id = loginUser.Id }));
} catch (Exception)
{
ViewBag.Message = "Incorrect username and / or password";
return(View());
}
}
return(View());
}