public static List<OptimizedBudgetItemsDetails> GetBudgetItems(OptimizedBudgetItems Budget) { DAL dalDataContext = new DAL(); List<OptimizedBudgetItemsDetails> BudgetItems; BudgetItems = (from BudgetDetails in dalDataContext.optimizedBudgetItemDetails where BudgetDetails.BudgetID == Budget.BudgetID && BudgetDetails.EventID == Budget.EventID orderby BudgetDetails.typeString ascending select BudgetDetails).ToList<OptimizedBudgetItemsDetails>(); return BudgetItems; }
public ExportData(Events evnt, EventDay[] days, Task[] tasks, FacilityBookingConfirmed[][] facilities, Program[][] programs, Guest[][] guests, Participant[] participants , OptimizedBudgetItems optitems, BudgetIncome[] budgetincomes, Field[] field) { this.evnts = evnt; this.days = days; this.tasks = tasks; this.facilities = facilities; this.programs = programs; this.guests = guests; this.participants = participants; this.optitems = optitems; this.budgetincomes = budgetincomes; this.field = field; }
public static void SaveBudgetItemList(User saver, int eventID, int totalSat, decimal totalPrice, List<Items> itemList) { //Check if user has rights to manage Budget //if no throw exception try { DAL dalDataContext = new DAL(); Table<OptimizedBudgetItems> facReq = dalDataContext.optimizedBudgetItems; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { RemoveExistingBudget(eventID); //Remove if it exist, causing overwrite //Create a new one OptimizedBudgetItems Budget = new OptimizedBudgetItems(eventID, saver.UserID, totalSat, totalPrice); facReq.InsertOnSubmit(Budget); facReq.Context.SubmitChanges(); Budget = (from bgt in dalDataContext.optimizedBudgetItems where bgt.EventID == eventID && bgt.Generator == saver.UserID orderby bgt.GeneratedDate descending select bgt).FirstOrDefault<OptimizedBudgetItems>(); BudgetDetailsController.AddBudgetItems(Budget.BudgetID, itemList); tScope.Complete(); } } catch (Exception ex) { throw new FaultException<SException>(new SException(), new FaultReason("An Error occured While Saving Optimal Item List: " + ex.Message)); } }