public ActionResult Create()
{
return(Error(Loc.Dic.Error_NoPermission));
if (Authorized(RoleType.SystemManager))
{
using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId))
using (BudgetsIncomesRepository incomesRep = new BudgetsIncomesRepository())
using (IncomeTypesRepository incomeTypesRep = new IncomeTypesRepository())
using (InstitutionsRepository institutionsRep = new InstitutionsRepository())
{
List <SelectListItemDB> budgetsList = budgetRep.GetList()
.Where(budget => budget.CompanyId == CurrentUser.CompanyId && budget.Year >= (DateTime.Now.Year - 1))
.Select(a => new { Id = a.Id, Name = a.Year })
.AsEnumerable()
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name.ToString()
})
.ToList();
List <SelectListItemDB> incomeTypesList = incomeTypesRep.GetList()
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name
})
.ToList();
List <SelectListItemDB> institutionsList = institutionsRep.GetList()
.Where(type => type.CompanyId == CurrentUser.CompanyId)
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name
})
.ToList();
ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name");
ViewBag.BudgetIncomeTypeId = new SelectList(incomeTypesList, "Id", "Name");
ViewBag.BudgetsIncomeInstitutions = new SelectList(institutionsList, "Id", "Name");
}
return(View());
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
public ActionResult Edit(int id = 0)
{
return(Error(Loc.Dic.Error_NoPermission));
if (Authorized(RoleType.SystemManager))
{
Budgets_Incomes income;
using (BudgetsIncomesRepository incomesRep = new BudgetsIncomesRepository())
using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId))
using (IncomeTypesRepository incomeTypesRep = new IncomeTypesRepository())
using (InstitutionsRepository institutionsRep = new InstitutionsRepository())
{
income = incomesRep.GetEntity(id);
try
{
List <SelectListItemDB> budgetsList = budgetRep.GetList()
.Where(budget => budget.CompanyId == CurrentUser.CompanyId && budget.Year >= (DateTime.Now.Year - 1))
.Select(a => new { Id = a.Id, Name = a.Year })
.AsEnumerable()
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name.ToString()
})
.ToList();
List <SelectListItemDB> incomeTypesList = incomeTypesRep.GetList()
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name
})
.ToList();
List <SelectListItemDB> institutionsList = institutionsRep.GetList()
.Where(type => type.CompanyId == CurrentUser.CompanyId)
.Select(x => new SelectListItemDB()
{
Id = x.Id, Name = x.Name
})
.ToList();
institutionsList.Insert(0, new SelectListItemDB()
{
Id = null, Name = ""
});
ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name", income.BudgetId);
ViewBag.BudgetIncomeTypeId = new SelectList(incomeTypesList, "Id", "Name", income.BudgetIncomeTypeId);
ViewBag.BudgetsIncomeInstitutions = new SelectList(institutionsList, "Id", "Name", income.BudgetsIncomeInstitutionsId);
}
catch
{
return(Error(Loc.Dic.error_database_error));
}
}
if (income != null)
{
if (income.CompanyId == CurrentUser.CompanyId)
{
return(View(income));
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
else
{
return(Error(Loc.Dic.error_income_get_error));
}
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
public ActionResult Edit(Budgets_Incomes budgets_incomes)
{
return(Error(Loc.Dic.Error_NoPermission));
if (Authorized(RoleType.SystemManager))
{
if (ModelState.IsValid)
{
Budgets_Incomes incomeFromDB;
Budget budget;
Budgets_Incomes_types incomeType;
Budgets_Incomes_Institutions institution;
using (BudgetsIncomesRepository incomesRep = new BudgetsIncomesRepository())
using (IncomeTypesRepository incomeTypesRep = new IncomeTypesRepository())
using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId))
using (InstitutionsRepository InstitutionsRep = new InstitutionsRepository())
{
incomeFromDB = incomesRep.GetEntity(budgets_incomes.Id);
budget = budgetRep.GetEntity(budgets_incomes.BudgetId);
incomeType = incomeTypesRep.GetEntity(budgets_incomes.BudgetIncomeTypeId);
if (budgets_incomes.BudgetsIncomeInstitutionsId.HasValue)
{
institution = InstitutionsRep.GetEntity(budgets_incomes.BudgetsIncomeInstitutionsId.Value);
}
else
{
institution = null;
}
if (incomeFromDB != null)
{
if (budget != null && incomeType != null && (!budgets_incomes.BudgetsIncomeInstitutionsId.HasValue || institution != null))
{
if (incomeFromDB.CompanyId == CurrentUser.CompanyId && budget.CompanyId == CurrentUser.CompanyId && (!budgets_incomes.BudgetsIncomeInstitutionsId.HasValue || institution.CompanyId == CurrentUser.CompanyId))
{
if (budgets_incomes.Amount < incomeFromDB.Amount)
{
decimal?allocatedIncome;
using (AllocationRepository allocationsRep = new AllocationRepository(CurrentUser.CompanyId))
{
allocatedIncome = allocationsRep.GetList()
.Where(x => x.IncomeId == incomeFromDB.Id)
.Sum(allocation => (decimal?)allocation.CompanyId);//.Sum(allocation => (decimal?)allocation.Amount);
}
if (allocatedIncome.HasValue && allocatedIncome > budgets_incomes.Amount)
{
return(Error(Loc.Dic.error_income_allocations_exeeds_amount));
}
}
incomeFromDB.BudgetId = budgets_incomes.BudgetId;
incomeFromDB.BudgetIncomeTypeId = budgets_incomes.BudgetIncomeTypeId;
incomeFromDB.BudgetsIncomeInstitutionsId = budgets_incomes.BudgetsIncomeInstitutionsId;
incomeFromDB.CustomName = budgets_incomes.CustomName;
incomeFromDB.Amount = budgets_incomes.Amount;
Budgets_Incomes update = incomesRep.Update(incomeFromDB);
if (update != null)
{
return(RedirectToAction("Index"));
}
else
{
return(Error(Loc.Dic.error_income_create_error));
}
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
else
{
return(Error(Loc.Dic.error_database_error));
}
}
else
{
return(Error(Loc.Dic.error_income_get_error));
}
}
}
else
{
return(Error(ModelState));
}
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
public ActionResult Create(Budgets_Incomes budgets_incomes)
{
return(Error(Loc.Dic.Error_NoPermission));
if (Authorized(RoleType.SystemManager))
{
if (ModelState.IsValid)
{
Budget budget;
Budgets_Incomes_types incomeType;
Budgets_Incomes_Institutions institution;
using (IncomeTypesRepository incomeTypesRep = new IncomeTypesRepository())
using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId))
using (InstitutionsRepository InstitutionsRep = new InstitutionsRepository())
{
budget = budgetRep.GetEntity(budgets_incomes.BudgetId);
incomeType = incomeTypesRep.GetEntity(budgets_incomes.BudgetIncomeTypeId);
if (budgets_incomes.BudgetsIncomeInstitutionsId.HasValue)
{
institution = InstitutionsRep.GetEntity(budgets_incomes.BudgetsIncomeInstitutionsId.Value);
}
else
{
institution = null;
}
}
if (budget != null && incomeType != null && (!budgets_incomes.BudgetsIncomeInstitutionsId.HasValue || institution != null))
{
if (budget.CompanyId == CurrentUser.CompanyId && (!budgets_incomes.BudgetsIncomeInstitutionsId.HasValue || institution.CompanyId == CurrentUser.CompanyId))
{
bool wasCreated;
budgets_incomes.CompanyId = CurrentUser.CompanyId;
using (BudgetsIncomesRepository incomesRep = new BudgetsIncomesRepository())
{
wasCreated = incomesRep.Create(budgets_incomes);
}
if (wasCreated)
{
return(RedirectToAction("Index"));
}
else
{
return(Error(Loc.Dic.error_income_create_error));
}
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
else
{
return(Error(Loc.Dic.error_database_error));
}
}
else
{
return(Error(ModelState));
}
}
else
{
return(Error(Loc.Dic.error_no_permission));
}
}
