public async Task <IActionResult> Edit(int id, [Bind("SaleManId,SaleManName,BikeAmount,SaleDate")] SaleMan saleMan) { if (id != saleMan.SaleManId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(saleMan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SaleManExists(saleMan.SaleManId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(saleMan)); }
public async Task <IActionResult> Create([Bind("SaleManId,SaleManName,BikeAmount,SaleDate")] SaleMan saleMan) { if (ModelState.IsValid) { _context.Add(saleMan); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(saleMan)); }
public async Task <IActionResult> Create([Bind("FirstMidName,LastName,HighDate,Email,TipoDocumento,NumDocumento,Direccion,Telefono")] SaleMan saleMan) { if (ModelState.IsValid) { _context.Add(saleMan); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(saleMan)); }
public static void Seed(MvcTpvContext context) { /* if (context == null) * { * throw new ArgumentNullException(nameof(context)); * }*/ context.Database.EnsureCreated(); if (context.Products.Any()) { return; } var categorias = new Category[] { new Category { CategoryName = "Cars" }, new Category { CategoryName = "Planes" }, new Category { CategoryName = "Trucks" }, new Category { CategoryName = "Boats" }, new Category { CategoryName = "Rockets" }, }; foreach (Category c in categorias) { context.Categories.Add(c); } context.SaveChanges(); var productos = new Product[] { new Product { ProductName = "Convertible Car", Description = "This convertible car is fast! The engine is powered by a neutrino based battery (not included)." + "Power it up and let it go!", ImagePath = "carconvert.png", //UnitPrice = 22.50, Stock = 3, CategoryID = 1 }, new Product { ProductName = "Old-time Car", Description = "There's nothing old about this toy car, except it's looks. Compatible with other old toy cars.", ImagePath = "carearly.png", Stock = 15, CategoryID = 1 }, new Product { ProductName = "Fast Car", Description = "Yes this car is fast, but it also floats in water.", ImagePath = "carfast.png", Stock = 3, CategoryID = 1 }, new Product { ProductName = "Super Fast Car", Description = "Use this super fast car to entertain guests. Lights and doors work!", ImagePath = "carfaster.png", Stock = 3, CategoryID = 1 }, new Product { ProductName = "Old Style Racer", Description = "This old style racer can fly (with user assistance). Gravity controls flight duration." + "No batteries required.", ImagePath = "carracer.png", Stock = 3, CategoryID = 1 }, new Product { ProductName = "Ace Plane", Description = "Authentic airplane toy. Features realistic color and details.", ImagePath = "planeace.png", Stock = 3, CategoryID = 2 }, new Product { ProductName = "Glider", Description = "This fun glider is made from real balsa wood. Some assembly required.", ImagePath = "planeglider.png", //UnitPrice = 4.95, Stock = 3, CategoryID = 2 }, new Product { ProductName = "Paper Plane", Description = "This paper plane is like no other paper plane. Some folding required.", ImagePath = "planepaper.png", //UnitPrice = 2.95, Stock = 3, CategoryID = 2 }, new Product { ProductName = "Propeller Plane", Description = "Rubber band powered plane features two wheels.", ImagePath = "planeprop.png", //UnitPrice = 32.95, Stock = 3, CategoryID = 2 }, new Product { ProductName = "Early Truck", Description = "This toy truck has a real gas powered engine. Requires regular tune ups.", ImagePath = "truckearly.png", //UnitPrice = 15.00, Stock = 3, CategoryID = 3 }, new Product { ProductName = "Fire Truck", Description = "You will have endless fun with this one quarter sized fire truck.", ImagePath = "truckfire.png", //UnitPrice = 26.00, Stock = 3, CategoryID = 3 }, new Product { ProductName = "Big Truck", Description = "This fun toy truck can be used to tow other trucks that are not as big.", ImagePath = "truckbig.png", //UnitPrice = 29.00, Stock = 3, CategoryID = 3 }, new Product { ProductName = "Big Ship", Description = "Is it a boat or a ship. Let this floating vehicle decide by using its " + "artifically intelligent computer brain!", ImagePath = "boatbig.png", //UnitPrice = 95.00, Stock = 3, CategoryID = 4 }, new Product { ProductName = "Paper Boat", Description = "Floating fun for all! This toy boat can be assembled in seconds. Floats for minutes!" + "Some folding required.", ImagePath = "boatpaper.png", //UnitPrice = 4.95, Stock = 3, CategoryID = 4 }, new Product { ProductName = "Sail Boat", Description = "Put this fun toy sail boat in the water and let it go!", ImagePath = "boatsail.png", //UnitPrice = 42.95, Stock = 3, CategoryID = 4 }, new Product { ProductName = "Rocket", Description = "This fun rocket will travel up to a height of 200 feet.", ImagePath = "rocket.png", //UnitPrice = 122.95, Stock = 3, CategoryID = 5 } }; foreach (Product p in productos) { context.Products.Add(p); } context.SaveChanges(); var providers = new Provider[] { new Provider { CategoryID = 1, FirstMidName = "Laura", LastName = "Cars Provider", HighDate = DateTime.Parse("2013-09-01") }, new Provider { CategoryID = 2, FirstMidName = "Nino", LastName = "Plane Provider", HighDate = DateTime.Parse("2005-09-01") }, new Provider { CategoryID = 3, FirstMidName = "Norman", LastName = "Truck Provider", HighDate = DateTime.Parse("2013-09-01") }, new Provider { CategoryID = 4, FirstMidName = "Olivetto", LastName = "Ship Provider", HighDate = DateTime.Parse("2005-09-01") }, new Provider { CategoryID = 5, FirstMidName = "Lolo", LastName = "Rocket Provider", HighDate = DateTime.Parse("2013-09-01") }, }; foreach (Provider p in providers) { context.Providers.Add(p); } context.SaveChanges(); var customers = new Customer[] { new Customer { FirstMidName = "Carson", LastName = "Alexander", HighDate = DateTime.Parse("2010-09-01") }, new Customer { FirstMidName = "Meredith", LastName = "Alonso", HighDate = DateTime.Parse("2012-09-01") }, new Customer { FirstMidName = "Arturo", LastName = "Anand", HighDate = DateTime.Parse("2013-09-01") }, new Customer { FirstMidName = "Gytis", LastName = "Barzdukas", HighDate = DateTime.Parse("2012-09-01") }, new Customer { FirstMidName = "Laura", LastName = "Norman", HighDate = DateTime.Parse("2013-09-01") }, new Customer { FirstMidName = "Nino", LastName = "Olivetto", HighDate = DateTime.Parse("2005-09-01") } }; foreach (Customer c in customers) { context.Customers.Add(c); } context.SaveChanges(); var salemans = new SaleMan[] { new SaleMan { FirstMidName = "Yan", LastName = "Li", HighDate = DateTime.Parse("2012-09-01") }, new SaleMan { FirstMidName = "Peggy", LastName = "Justice", HighDate = DateTime.Parse("2011-09-01") }, }; foreach (SaleMan s in salemans) { context.SaleMans.Add(s); } context.SaveChanges(); var sales = new Sale[] { new Sale { CustomerID = 1, SaleManID = 1, Tipo_Comprobante = Comprobante.Recibo, Serie_comprobante = "01R", Num_comprobante = "0001", Fecha_Hora = DateTime.Parse("2016-09-01"), Impuesto = 0.14m, Estado = Estado.Emitido }, new Sale { CustomerID = 2, SaleManID = 1, Tipo_Comprobante = Comprobante.Recibo, Serie_comprobante = "01R", Num_comprobante = "0002", Fecha_Hora = DateTime.Parse("2012-10-01"), Impuesto = 0.14m, Estado = Estado.Anulada }, new Sale { CustomerID = 3, SaleManID = 2, Tipo_Comprobante = Comprobante.Factura, Serie_comprobante = "01F", Num_comprobante = "0001", Fecha_Hora = DateTime.Parse("2014-03-01"), Impuesto = 0.14m, Estado = Estado.Emitido }, new Sale { CustomerID = 4, SaleManID = 2, Tipo_Comprobante = Comprobante.Factura, Serie_comprobante = "01F", Num_comprobante = "0002", Fecha_Hora = DateTime.Parse("2015-05-01"), Impuesto = 0.14m, Estado = Estado.Facturado }, }; foreach (Sale s in sales) { context.Sales.Add(s); } context.SaveChanges(); var saledetails = new SaleDetail[] { new SaleDetail { ProductID = 1, SaleID = 1, Cantidad = 2, PVP = 22.50m, Descuento = 2.5m }, new SaleDetail { ProductID = 2, SaleID = 1, Cantidad = 2, PVP = 15.95m, Descuento = 2.5m }, new SaleDetail { ProductID = 3, SaleID = 1, Cantidad = 2, PVP = 32.99m, Descuento = 2.5m }, new SaleDetail { ProductID = 4, SaleID = 1, Cantidad = 2, PVP = 8.95m, Descuento = 2.5m }, new SaleDetail { ProductID = 5, SaleID = 2, Cantidad = 2, PVP = 32.99m, Descuento = 2.5m }, new SaleDetail { ProductID = 6, SaleID = 2, Cantidad = 2, PVP = 8.95m, Descuento = 2.5m }, }; foreach (SaleDetail sd in saledetails) { context.SaleDetails.Add(sd); } context.SaveChanges(); var inputs = new Input[] { new Input { ProviderID = 1, Tipo_Comprobante = "Albaran", serie_comprobante = "P1A", num_comprobante = "0001", Fecha_hora = DateTime.Parse("2017-09-01"), Impuesto = 0.14m }, new Input { ProviderID = 2, Tipo_Comprobante = "Albaran", serie_comprobante = "P1A", num_comprobante = "0002", Fecha_hora = DateTime.Parse("2014-10-01"), Impuesto = 0.14m }, new Input { ProviderID = 3, Tipo_Comprobante = "Factura", serie_comprobante = "P1F", num_comprobante = "0001", Fecha_hora = DateTime.Parse("2015-03-01"), Impuesto = 0.14m }, new Input { ProviderID = 4, Tipo_Comprobante = "Factura", serie_comprobante = "P1F", num_comprobante = "0002", Fecha_hora = DateTime.Parse("2016-05-01"), Impuesto = 0.14m }, }; foreach (Input i in inputs) { context.Inputs.Add(i); } context.SaveChanges(); var inputdetails = new InputDetail[] { new InputDetail { InputID = 1, ProductID = 1, Cantidad = 2, PNETO = 11.25m, PVP = 22.50m, }, new InputDetail { InputID = 1, ProductID = 2, Cantidad = 2, PNETO = 7.95m, PVP = 15.95m }, new InputDetail { InputID = 1, ProductID = 3, Cantidad = 2, PNETO = 17.51m, PVP = 32.99m }, new InputDetail { InputID = 1, ProductID = 4, Cantidad = 2, PNETO = 7.99m, PVP = 8.95m }, new InputDetail { InputID = 2, ProductID = 6, Cantidad = 2, PNETO = 49.95m, PVP = 95.00m }, new InputDetail { InputID = 2, ProductID = 7, Cantidad = 4, PNETO = 5.99m, PVP = 4.95m }, new InputDetail { InputID = 3, ProductID = 10, Cantidad = 2, PNETO = 7.50m, PVP = 15.00m }, new InputDetail { InputID = 3, ProductID = 11, Cantidad = 2, PNETO = 13.00m, PVP = 26.00m }, new InputDetail { InputID = 4, ProductID = 13, Cantidad = 2, PNETO = 49.95m, PVP = 4.95m }, }; foreach (InputDetail id in inputdetails) { context.InputDetails.Add(id); } context.SaveChanges(); }
// GET: SaleMen public async Task <IActionResult> Index(int?id, int?saleID, string sortOrder, string searchString) { var viewModel = new SaleManIndexData(); viewModel.SaleMans = await _context.SaleMans .Include(c => c.Sales) .ThenInclude(i => i.SaleDetails) .AsNoTracking() .OrderBy(i => i.SaleManID) .ToListAsync(); ViewData["CurrentSort"] = sortOrder; ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date"; switch (sortOrder) { case "name_desc": viewModel.SaleMans = viewModel.SaleMans.OrderByDescending(s => s.LastName); break; case "Date": viewModel.SaleMans = viewModel.SaleMans.OrderBy(s => s.HighDate); break; case "date_desc": viewModel.SaleMans = viewModel.SaleMans.OrderByDescending(s => s.HighDate); break; default: viewModel.SaleMans = viewModel.SaleMans.OrderBy(s => s.LastName); break; } ViewData["CurrentFilter"] = searchString; if (id != null) { ViewData["SaleManID"] = id.Value; //viewModel.SaleMans = await _context.SaleMans // .Include(c => c.Sales) // .ThenInclude(i => i.SaleDetails) // //.AsNoTracking() // .OrderBy(i => i.SaleManID) // .ToListAsync(); SaleMan saleman = viewModel.SaleMans .Where(p => p.SaleManID == id.Value) .Single(); viewModel.Sales = saleman.Sales.ToList(); } if (!String.IsNullOrEmpty(searchString)) { var saleman = from s in _context.SaleMans select s; saleman = saleman.Where(s => s.FirstMidName.ToUpper().Contains(searchString.ToUpper()) || s.LastName.ToUpper().Contains(searchString.ToUpper()) || s.Direccion.ToUpper().Contains(searchString.ToUpper()) || s.Email.Contains(searchString) || s.TipoDocumento.Contains(searchString) || s.NumDocumento.Contains(searchString) || s.Telefono.Contains(searchString) ); viewModel.SaleMans = saleman.ToList(); } return(View(viewModel)); //return View(await customer.ToListAsync()); //return View(await _context.SaleMans.ToListAsync()); }