public ActionResult Edit(int consigneeId) { ConsigneeModel consigneeModel; using (var necessitiesContext = new NecessitiesContext()) { var consignee = necessitiesContext.Consignees.First(x => x.ConsigneeId == consigneeId); consigneeModel = new ConsigneeModel { AddressOne = consignee.AddressOne, AddressTwo = consignee.AddressTwo, City = consignee.City, ConsigneeId = consignee.ConsigneeId, CreationDate = consignee.CreationDate, Email = consignee.Email, FirstName = consignee.FirstName, LastName = consignee.LastName, Percentage = consignee.Percentage * 100, PhoneNumber = consignee.PhoneNumber, PostalCode = consignee.PostalCode, State = consignee.State, UpdatedDate = consignee.UpdatedDate }; } return View(consigneeModel); }
public ActionResult Index() { IEnumerable<SaleModel> saleModels; using (var necessitiesContext = new NecessitiesContext()) { saleModels = necessitiesContext.Sales.Select(sale => new SaleModel { SaleId = sale.SaleId, Date = sale.Date, TaxRate = sale.TaxRate, CreationDate = sale.CreationDate, UpdatedDate = sale.UpdatedDate, SaleItems = sale.SaleItems.Select( item => new SaleItemModel { SaleItemId = item.SaleItemId, Amount = item.Amount, Description = item.Description, ItemTypeId = item.ItemTypeId, ConsigneeId = item.ConsigneeId, SaleId = item.SaleId, CreationDate = item.CreationDate, UpdatedDate = item.UpdatedDate }).ToList() }).ToList(); } return View(saleModels); }
public ActionResult Create(ConsigneeModel consigneeModel) { if (ModelState.IsValid) { using (var necessitiesContext = new NecessitiesContext()) { necessitiesContext.Consignees.Add( new Consignee { ConsigneeId = consigneeModel.ConsigneeId, FirstName = consigneeModel.FirstName, LastName = consigneeModel.LastName, AddressOne = consigneeModel.AddressOne, AddressTwo = consigneeModel.AddressTwo, City = consigneeModel.City, State = consigneeModel.State, PostalCode = consigneeModel.PostalCode, PhoneNumber = GetCleanPhoneNumber(consigneeModel.PhoneNumber), Email = consigneeModel.Email, Percentage = consigneeModel.Percentage/100, CreationDate = DateTime.Now, UpdatedDate = DateTime.Now }); necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); } return View(consigneeModel); }
public ActionResult Index() { IEnumerable<SalesTaxRateModel> salesTaxRateModels; using (var necessitiesContext = new NecessitiesContext()) { salesTaxRateModels = necessitiesContext.SalesTaxRates.ToList().Select( str => new SalesTaxRateModel {StartDate = str.StartDate, TaxRate = str.TaxRate}); } return View(salesTaxRateModels); }
public ActionResult Edit(int itemTypeId) { ItemType itemType; using (var necessitiesContext = new NecessitiesContext()) { itemType = necessitiesContext.ItemTypes.First(x => x.ItemTypeId == itemTypeId); } return View(itemType); }
public ActionResult Edit(ItemTypeModel itemTypeModel) { using (var necessitiesContext = new NecessitiesContext()) { var itemType = necessitiesContext.ItemTypes.First(x => x.ItemTypeId == itemTypeModel.ItemTypeId); itemType.Description = itemTypeModel.Description; itemType.Active = itemTypeModel.Active; necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Index() { IEnumerable<ItemTypeModel> itemTypeModels; using (var necessitiesContext = new NecessitiesContext()) { itemTypeModels = necessitiesContext.ItemTypes.ToList().Select( str => new ItemTypeModel { ItemTypeId = str.ItemTypeId, Description = str.Description, Active = str.Active }); } return View(itemTypeModels); }
public ActionResult Create(DateTime startDate, decimal taxRate) { var salesTaxRateModel = new SalesTaxRateModel { StartDate = startDate, TaxRate = taxRate / 100 }; using (var necessitiesContext = new NecessitiesContext()) { necessitiesContext.SalesTaxRates.Add(new SalesTaxRate { StartDate = salesTaxRateModel.StartDate, TaxRate = salesTaxRateModel.TaxRate }); necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Create(ItemTypeModel itemTypeModel) { using (var necessitiesContext = new NecessitiesContext()) { necessitiesContext.ItemTypes.Add( new ItemType { Description = itemTypeModel.Description, Active = true }); necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Create() { Percentage taxRate = 0; using (var necessitiesContext = new NecessitiesContext()) { var str = necessitiesContext.SalesTaxRates.OrderByDescending(rate => rate.StartDate) .FirstOrDefault(rate => rate.StartDate <= DateTime.Now); if (str != default(SalesTaxRate)) { taxRate = str.TaxRate; } } return View(new SaleModel { SaleId = 0, Date = DateTime.Now, TaxRate = taxRate, CreationDate = DateTime.Now, UpdatedDate = DateTime.Now, SaleItems = new List<SaleItemModel>() }); }
public ActionResult Create(SaleModel saleModel) { if (ModelState.IsValid) { using (var necessitiesContext = new NecessitiesContext()) { necessitiesContext.Sales.Add( new Sale { SaleId = saleModel.SaleId, Date = saleModel.Date, TaxRate = saleModel.TaxRate, CreationDate = DateTime.Now, UpdatedDate = DateTime.Now, SaleItems = saleModel.SaleItems.Select( item => new SaleItem { SaleItemId = item.SaleItemId, Amount = item.Amount, Description = item.Description, ItemTypeId = item.ItemTypeId, ConsigneeId = item.ConsigneeId, SaleId = item.SaleId, CreationDate = item.CreationDate, UpdatedDate = item.UpdatedDate }).ToList() }); necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); } return View(saleModel); }
public ActionResult Edit(ConsigneeModel consigneeModel) { if (ModelState.IsValid) { using (var necessitiesContext = new NecessitiesContext()) { var consignee = necessitiesContext.Consignees.First(x => x.ConsigneeId == consigneeModel.ConsigneeId); consignee.ConsigneeId = consigneeModel.ConsigneeId; consignee.FirstName = consigneeModel.FirstName; consignee.LastName = consigneeModel.LastName; consignee.AddressOne = consigneeModel.AddressOne; consignee.AddressTwo = consigneeModel.AddressTwo; consignee.City = consigneeModel.City; consignee.State = consigneeModel.State; consignee.PostalCode = consigneeModel.PostalCode; consignee.PhoneNumber = GetCleanPhoneNumber(consigneeModel.PhoneNumber); consignee.Email = consigneeModel.Email; consignee.Percentage = consigneeModel.Percentage / 100; consignee.UpdatedDate = DateTime.Now; necessitiesContext.SaveChanges(); } return RedirectToAction("Index"); } return View(consigneeModel); }
public ActionResult Index() { IEnumerable<ConsigneeModel> consigneeModels; using (var necessitiesContext = new NecessitiesContext()) { consigneeModels = necessitiesContext.Consignees.ToList().Select( str => new ConsigneeModel { ConsigneeId = str.ConsigneeId, FirstName = str.FirstName, LastName = str.LastName, AddressOne = str.AddressOne, AddressTwo = str.AddressTwo, City = str.City, State = str.State, PostalCode = str.PostalCode, PhoneNumber = str.PhoneNumber, Email = str.Email, Percentage = str.Percentage, CreationDate = str.CreationDate, UpdatedDate = str.UpdatedDate }); } return View(consigneeModels); }