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));
}
