public int Insert_ReturnItems(UnOrderedItem item)
{
using (var context = new eRaceContext())
{
context.UnOrderedItems.Add(item);
context.SaveChanges();
return(item.ItemID);
}
}
public void AddUnorderedItem(UnorderedInfo item)
{
using (var context = new eRaceContext())
{
var newItem = new UnOrderedItem
{
ItemName = item.ItemName,
VendorProductID = item.VendorID,
Quantity = item.Quantity
};
context.UnOrderedItems.Add(newItem);
context.SaveChanges();
}
}
public int UnOrderedItem_Add(UnOrderedItem item)
{
using (var context = new RaceContext())
{
if (string.IsNullOrEmpty(item.ItemName))
{
throw new BusinessRuleException("Please enter an unordered item.", reasons);
}
else if (item.Quantity <= 0)
{
throw new BusinessRuleException("The Unordered item quantity must be greater than 0", reasons);
}
else
{
var exists = (from x in context.Products
where x.ItemName == item.ItemName
select x.ProductID).FirstOrDefault().ToString();
item.VendorProductID = exists;
item.OrderID = 999;
if (item.VendorProductID == null || int.Parse(item.VendorProductID) == 0)
{
throw new BusinessRuleException("Item does not exist in the database.", reasons);
}
else
{
context.UnOrderedItems.Add(item); //staging
context.SaveChanges(); //actual commit to the database
return(item.ItemID);
}
}
}
}
public int UnorderedItem_Delete(UnOrderedItem item)
{
return(UnorderedItem_Delete(item.ItemID));
}
