public int Insert_Update_Budget(BudgetResult objBudget) { DataAccessClass objData = new DataAccessClass(); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue(SPParameter.Budget_Year, objBudget.Year); cmd.Parameters.AddWithValue(SPParameter.Budget_Month, objBudget.Month); cmd.Parameters.AddWithValue(SPParameter.Budget_ProjectId, objBudget.ProjectId); cmd.Parameters.AddWithValue(SPParameter.Budget_CostCodeId, objBudget.CostCodeId); cmd.Parameters.AddWithValue(SPParameter.Budget_Budget, objBudget.Budget); cmd.Parameters.AddWithValue(SPParameter.Budget_BusinessVerticalId, objBudget.BusinessVerticalId); if (objBudget.BudgetId != 0) { if (objBudget.Budget == 0) { cmd = new SqlCommand(); cmd.Parameters.AddWithValue(SPParameter.LastModifiedById, objBudget.CreatedById); cmd.Parameters.AddWithValue(SPParameter.BudgetId, objBudget.BudgetId); return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Delete_Budget, cmd))); } else { cmd.Parameters.AddWithValue(SPParameter.LastModifiedById, objBudget.CreatedById); cmd.Parameters.AddWithValue(SPParameter.BudgetId, objBudget.BudgetId); return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Update_Budget, cmd))); } } else { cmd.Parameters.AddWithValue(SPParameter.CreatedBy, objBudget.CreatedById); return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Insert_Budget, cmd))); } }
public async Task <IEnumerable <BudgetResult> > CalculateForMonth(Month month) { var allBudgets = await _db.Budgets .Where(x => x.ClientId == _currentClient.Id && x.Category != null && x.Category != "") .OrderBy(x => x.Category) .ToListAsync(); var allLines = await _db.Lines.ByClient(_currentClient).ByMonth(month).ByNotIgnored().ByCategoryNotEmpty().Select(x => new { Amount = x.Amount ?? x.OriginalAmount, x.Category }).ToListAsync(); var result = new List <BudgetResult>(); foreach (var budget in allBudgets) { var budgetResult = new BudgetResult(budget.Category); var budgetCategory = budget.Category.ToLower(); budgetResult.Amount = allLines.Where(x => x.Category.ToLower() == budgetCategory).Select(x => x.Amount).Sum(); budgetResult.Limit = budget.NormalizeLimit(month); result.Add(budgetResult); } return(result); }
public int Delete_Budget(BudgetResult objBudget) { DataAccessClass objData = new DataAccessClass(); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue(SPParameter.BudgetId, objBudget.BudgetId); cmd.Parameters.AddWithValue(SPParameter.LastModifiedById, objBudget.CreatedById); return(Convert.ToInt32(objData.ExecuteScalarSP_WithConnection(SPNames.Delete_Budget, cmd))); }
public List <BudgetResult> GetBudget(BudgetResult objBudget) { DataAccessClass objData = new DataAccessClass(); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue(SPParameter.Budget_Year, objBudget.Year); cmd.Parameters.AddWithValue(SPParameter.Budget_Month, objBudget.Month); cmd.Parameters.AddWithValue(SPParameter.Budget_ProjectId, objBudget.ProjectId); return(objData.ExecuteReaderSP_WithConnection <BudgetResult>(SPNames.Get_Budget, cmd)); }
public PartialViewResult RenderCostCodeLists(BudgetResult objBudgetModel) { List <BudgetResult> lstBudgetResult = _IBudgetService.Get_Budget(objBudgetModel); var lstBudget = lstBudgetResult.Where(p => p.BudgetId != 0).ToList(); foreach (var item in lstBudgetResult) { if (!lstBudget.Where(p => p.MasterID == item.MasterID).Any()) { lstBudget.Add(item); } } if (objBudgetModel.ProjectId == -9999) { ViewData["BusinessVerticals"] = CommonRepository.FillMasterDropDownList(CommonConstants.BusinessVerticals); } return(PartialView(RMS.Common.Constants.CommonConstants.PartialListCostCodes, lstBudget)); }
public List <BudgetResult> Get_Budget(BudgetResult objMaster) { return(_IBudgetRepository.GetBudget(objMaster)); }
public int Delete_Budget(BudgetResult objMaster) { return(_IBudgetRepository.Delete_Budget(objMaster)); }
public int Insert_Budget(BudgetResult objMaster) { return(_IBudgetRepository.Insert_Update_Budget(objMaster)); }