/// <summary> /// /// </summary> /// <returns></returns> public BudgetStatusContract GetBudgetStatus() { BudgetStatusContract budgetStatus = new BudgetStatusContract(); var query = (from budgetStatusSingle in orgMaintEntitiesContext.BudgetStatus select budgetStatusSingle).FirstOrDefault(); if (query == null) { BudgetStatu budgStatu = new BudgetStatu(); budgStatu.BudgetAvailable = budgetStatus.BudgetAvailable = 0; budgStatu.BudgetAllocated = budgetStatus.BudgetAllocated = 0; budgStatu.BudgetRequired = budgetStatus.BudgetRequired = 00; budgStatu.DateUpdated = DateTime.Now; orgMaintEntitiesContext.BudgetStatus.Add(budgStatu); orgMaintEntitiesContext.SaveChanges(); } else { budgetStatus.BudgetAvailable = query.BudgetAvailable; budgetStatus.BudgetAllocated = query.BudgetAllocated; budgetStatus.BudgetRequired = query.BudgetRequired; budgetStatus.DateUpdated = query.DateUpdated; budgetStatus.DateUpdatedString = query.DateUpdated.ToShortDateString(); } return budgetStatus; }
private CacheData() { orgMaintEntitiesContext = new Org_MaintEntities(); budgetStatus = GetBudgetStatus(); budgetHistory = GetBudgetHistory(); #region admin // consider moving to a different webservice adminMainEntitiesContext = new AdminMaintEntities(); #endregion }