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);
}
