public ActionResult Index(NarucbaFilter filter)
{
var dbContext = new shopDbContext();
var dataQuery = dbContext.Orders.ToList();
if (!string.IsNullOrWhiteSpace(filter.KupacIme))
{
dataQuery = dataQuery.Where(p => p.Kupac.Name.Contains(filter.KupacIme)).ToList();
}
if (!string.IsNullOrWhiteSpace(filter.CarIme))
{
dataQuery = dataQuery.Where(p => p.Car != null && p.Car.Name.Contains(filter.CarIme)).ToList();
}
if (!string.IsNullOrWhiteSpace(filter.Prodavac))
{
dataQuery = dataQuery.Where(p => p.Prodavac != null && p.Prodavac.Name.Contains(filter.Prodavac)).ToList();
}
if (!string.IsNullOrWhiteSpace(filter.DucanIme))
{
dataQuery = dataQuery.Where(p => p.Ducani != null && p.Ducani.Name.Contains(filter.DucanIme)).ToList();
}
foreach (var data in dataQuery)
{
data.profit = Izracun.porez(data.cijena);
}
var total = new Tuple <IEnumerable <Narudzbe>, double>(dataQuery, Izracun.Profit(dataQuery));
return(View(total));
}
public ActionResult Index()
{
var dbContext = new shopDbContext();
var data = dbContext.Orders
.ToList();
return(View(data));
}
public ActionResult Edit(int id)
{
using (var dbContext = new shopDbContext())
{
var model = dbContext.Cars
.FirstOrDefault(p => p.ID == id);
return(View(model));
}
}
public ActionResult Index()
{
using (var dbContext = new shopDbContext())
{
var data = dbContext.Cars
.ToList();
return(View(data));
}
}
public ActionResult Edit(int id)
{
this.FillDropDownValues();
using (var dbContext = new shopDbContext())
{
var model = dbContext.Orders
.FirstOrDefault(p => p.ID == id);
return(View(model));
}
}
public ActionResult Delete(int id)
{
using (var dbContext = new shopDbContext())
{
var model = dbContext.Cars
.FirstOrDefault(p => p.ID == id);
dbContext.Entry(model).State = EntityState.Deleted;
dbContext.SaveChanges();
return(Json(new { isSuccess = true }));
}
}
public ActionResult Create(Car model)
{
if (ModelState.IsValid)
{
var dbContext = new shopDbContext();
dbContext.Cars.Add(model);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public ActionResult Details(int?id = null)
{
if (id == null)
{
return(View());
}
using (var dbContext = new shopDbContext())
{
var data = dbContext.Cars
.ToList()
.FirstOrDefault(p => p.ID == id);
return(View(data));
}
}
public ActionResult Index()
{
var dbContext = new shopDbContext();
var data = dbContext.Orders
.ToList();
foreach (var d in data)
{
d.profit = Izracun.porez(d.cijena);
}
var total = new Tuple <IEnumerable <Narudzbe>, double>(data, Izracun.Profit(data));
return(View(total));
}
public ActionResult EditPost(int id)
{
using (var dbContext = new shopDbContext()) {
var model = dbContext.Kupci
.FirstOrDefault(p => p.ID == id);
var didUpdateModelSucceed = this.TryUpdateModel(model);
if (didUpdateModelSucceed && ModelState.IsValid)
{
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
}
public ActionResult Create(Narudzbe model)
{
if (ModelState.IsValid)
{
var dbContext = new shopDbContext();
var data = dbContext.Cars
.ToList();
int carId = (int)model.CarId;
var car = data.FirstOrDefault(p => p.ID == carId);
model.cijena = Izracun.izracunaj(car.SellPrice, 500);
dbContext.Orders.Add(model);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
this.FillDropDownValues();
return(View(model));
}
}
private void FillDropDownValues()
{
using (var dbContext = new shopDbContext())
{
var possibleManagers = dbContext.Users
.ToList();
var possibleCars = dbContext.Cars
.ToList();
var possibleStores = dbContext.Stores
.ToList();
var possibleBuyers = dbContext.Kupci
.ToList();
var selectItems = new List <System.Web.Mvc.SelectListItem>();
//Polje je opcionalno
var listItem = new SelectListItem();
listItem.Text = "- odaberite -";
listItem.Value = "";
selectItems.Add(listItem);
foreach (var aa in possibleManagers)
{
listItem = new SelectListItem();
listItem.Text = aa.Name;
listItem.Value = aa.ID.ToString();
listItem.Selected = false;
selectItems.Add(listItem);
}
ViewBag.PossibleManagers = selectItems;
//////////////////////////////////////////////////////////////////////////////
selectItems = new List <System.Web.Mvc.SelectListItem>();
//Polje je opcionalno
listItem = new SelectListItem();
listItem.Text = "- odaberite -";
listItem.Value = "";
selectItems.Add(listItem);
foreach (var aa in possibleCars)
{
listItem = new SelectListItem();
listItem.Text = aa.Name;
listItem.Value = aa.ID.ToString();
listItem.Selected = false;
selectItems.Add(listItem);
}
ViewBag.possibleCars = selectItems;
selectItems = new List <System.Web.Mvc.SelectListItem>();
//////////////////////////////////////////////////////////////////////////////
//Polje je opcionalno
listItem = new SelectListItem();
listItem.Text = "- odaberite -";
listItem.Value = "";
selectItems.Add(listItem);
foreach (var aa in possibleStores)
{
listItem = new SelectListItem();
listItem.Text = aa.Name;
listItem.Value = aa.ID.ToString();
listItem.Selected = false;
selectItems.Add(listItem);
}
ViewBag.possibleStores = selectItems;
//////////////////////////////////////////////////////////////////////////////
selectItems = new List <System.Web.Mvc.SelectListItem>();
//Polje je opcionalno
listItem = new SelectListItem();
listItem.Text = "- odaberite -";
listItem.Value = "";
selectItems.Add(listItem);
foreach (var aa in possibleBuyers)
{
listItem = new SelectListItem();
listItem.Text = aa.Name;
listItem.Value = aa.ID.ToString();
listItem.Selected = false;
selectItems.Add(listItem);
}
ViewBag.possibleBuyers = selectItems;
}
}
