public ActionResult GetLedgesPost(LedgesViewModel viewModel) { using (PriceDataModel2 db = new PriceDataModel2()) { if (viewModel.coloredPriceFactor != 0 || viewModel.colorlessPriceFactor != 0) { Ledge ledge = db.Ledges.Where(p => p.Activity == true && p.PicValue == viewModel.system).FirstOrDefault(); Ledge newLedgePrice = new Ledge(); if (viewModel.colorlessPriceFactor != 0 && viewModel.coloredPriceFactor == 0) { newLedgePrice.Activity = ledge.Activity; newLedgePrice.Colored = ledge.Colored; newLedgePrice.ColoredPriceFactor = ledge.ColoredPriceFactor; newLedgePrice.Colorless = ledge.Colorless; newLedgePrice.ColorlessPriceFactor = viewModel.colorlessPriceFactor; newLedgePrice.Model = ledge.Model; newLedgePrice.PicValue = ledge.PicValue; db.Ledges.Add(newLedgePrice); db.SaveChanges(); } if (viewModel.coloredPriceFactor != 0 && viewModel.colorlessPriceFactor == 0) { newLedgePrice.Activity = ledge.Activity; newLedgePrice.Colored = ledge.Colored; newLedgePrice.ColoredPriceFactor = viewModel.coloredPriceFactor; newLedgePrice.Colorless = ledge.Colorless; newLedgePrice.ColorlessPriceFactor = ledge.ColorlessPriceFactor; newLedgePrice.Model = ledge.Model; newLedgePrice.PicValue = ledge.PicValue; db.Ledges.Add(newLedgePrice); db.SaveChanges(); } if (viewModel.coloredPriceFactor != 0 && viewModel.colorlessPriceFactor != 0) { newLedgePrice.Activity = ledge.Activity; newLedgePrice.Colored = ledge.Colored; newLedgePrice.ColoredPriceFactor = viewModel.coloredPriceFactor; newLedgePrice.Colorless = ledge.Colorless; newLedgePrice.ColorlessPriceFactor = viewModel.colorlessPriceFactor; newLedgePrice.Model = ledge.Model; newLedgePrice.PicValue = ledge.PicValue; db.Ledges.Add(newLedgePrice); db.SaveChanges(); } ledge.Activity = false; db.Entry(ledge).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("GetLedges", "Price")); } }
public ActionResult GetLedges() { using (PriceDataModel2 db = new PriceDataModel2()) { LedgesViewModel ledgesModel = new LedgesViewModel(); var ledge = db.Ledges.Where(p => p.Activity == true).ToList(); List <SelectListItem> values = (from i in ledge.ToList() select new SelectListItem { Text = i.Model + "/" + i.Colorless + "-" + i.ColorlessPriceFactor + "€/" + i.Colored + "-" + i.ColoredPriceFactor + "€", Value = i.PicValue } ).ToList(); ViewBag.vls = values; return(View(ledgesModel)); } }