public static void AddBudgetItems(int BudgetId, List<Items> itemList)
{
DAL dalDataContext = new DAL();
List<OptimizedBudgetItemsDetails> bItemList = new List<OptimizedBudgetItemsDetails>();
try
{
foreach (Items item in itemList)
{
OptimizedBudgetItemsDetails bItem = new OptimizedBudgetItemsDetails(
BudgetId, item.EventID, item.typeString, item.ItemName);
bItemList.Add(bItem);
}
Table<OptimizedBudgetItemsDetails> budItems = dalDataContext.optimizedBudgetItemDetails;
budItems.InsertAllOnSubmit(bItemList);
budItems.Context.SubmitChanges();
}
catch (TransactionAbortedException tAbortedex)
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Saving Optimal Budget List: " + tAbortedex.Message));
}
catch (Exception ex)
{
throw new FaultException<SException>(new SException(),
new FaultReason("An Error occured While Saving Optimal Budget List: " + ex.Message));
}
}
public static Items GetItem(OptimizedBudgetItemsDetails bItem)
{
DAL dalDataContext = new DAL();
Items matchedItem = (from item in dalDataContext.items
where item.typeString == bItem.typeString
&& item.EventID == bItem.EventID
&& item.ItemName == bItem.ItemName
select item).FirstOrDefault<Items>();
return matchedItem;
}
public Items GetItemDetail(OptimizedBudgetItemsDetails bItem)
{
return ItemsController.GetItem(bItem);
}