public ActionResult Create(Projects_ParentProject projects_parentproject) { if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { projects_parentproject.CompanyId = CurrentUser.CompanyId; projects_parentproject.IsActive = true; bool wasCreated; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { wasCreated = projectsRep.Create(projects_parentproject); } if (wasCreated) { return(RedirectToAction("Index")); } else { return(Error(Loc.Dic.error_projects_create_error)); } } else { return(Error(ModelState)); } } else { return(Error(Loc.Dic.error_no_permission)); } }
public ActionResult Create(Projects_ParentProject projects_parentproject) { if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { projects_parentproject.CompanyId = CurrentUser.CompanyId; projects_parentproject.IsActive = true; bool wasCreated; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { wasCreated = projectsRep.Create(projects_parentproject); } if (wasCreated) return RedirectToAction("Index"); else return Error(Loc.Dic.error_projects_create_error); } else { return Error(ModelState); } } else { return Error(Loc.Dic.error_no_permission); } }
public ActionResult Edit(Projects_ParentProject projects_parentproject) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject projectFromDB; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { projectFromDB = projectsRep.GetEntity(projects_parentproject.Id); if (projectFromDB != null) { if (projectFromDB.CompanyId == CurrentUser.CompanyId) { projectFromDB.Name = projects_parentproject.Name; projectsRep.Update(projectFromDB); return(RedirectToAction("Index")); } else { return(Error(Loc.Dic.error_no_permission)); } } else { return(Error(Loc.Dic.error_projects_get_error)); } } } else { return(Error(Loc.Dic.error_no_permission)); } }
public ActionResult Details(int id = 0) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject Project; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { Project = projectsRep.GetEntity(id); } if (Project != null) { if (Project.CompanyId == CurrentUser.CompanyId) { return(View(Project)); } else { return(Error(Loc.Dic.error_no_permission)); } } else { return(Error(Loc.Dic.error_projects_get_error)); } } else { return(Error(Loc.Dic.error_no_permission)); } }
public ActionResult Create() { return(Error(Loc.Dic.Error_NoPermission)); if (Authorized(RoleType.SystemManager)) { using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { 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> projectsList = projectsRep.GetList() .Where(project => project.CompanyId == CurrentUser.CompanyId && project.IsActive) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); List <SelectListItemDB> subProjectsList = subProjectsRep.GetList() .Where(subProject => subProject.CompanyId == CurrentUser.CompanyId && subProject.IsActive) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name"); ViewBag.ParentProjectId = new SelectList(projectsList, "Id", "Name"); ViewBag.SubProjectId = new SelectList(subProjectsList, "Id", "Name"); } return(View()); } else { return(Error(Loc.Dic.error_no_permission)); } }
public ActionResult DeleteConfirmed(int id) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject project; using (OrdersRepository orderssRep = new OrdersRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { project = projectsRep.GetEntity(id); if (project != null) { if (project.CompanyId == CurrentUser.CompanyId) { project.IsActive = false; Projects_ParentProject update = projectsRep.Update(project); if (update != null) { return(RedirectToAction("Index")); } else { return(Error(Loc.Dic.error_projects_get_error)); } } else { return(Error(Loc.Dic.error_no_permission)); } } else { return(Error(Loc.Dic.error_projects_get_error)); } } } else { return(Error(Loc.Dic.error_no_permission)); } }
public ActionResult Create() { return Error(Loc.Dic.Error_NoPermission); if (Authorized(RoleType.SystemManager)) { using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { 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> projectsList = projectsRep.GetList() .Where(project => project.CompanyId == CurrentUser.CompanyId && project.IsActive) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); List<SelectListItemDB> subProjectsList = subProjectsRep.GetList() .Where(subProject => subProject.CompanyId == CurrentUser.CompanyId && subProject.IsActive) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name"); ViewBag.ParentProjectId = new SelectList(projectsList, "Id", "Name"); ViewBag.SubProjectId = new SelectList(subProjectsList, "Id", "Name"); } return View(); } else { return Error(Loc.Dic.error_no_permission); } }
public ActionResult Delete(int id = 0) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject project; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { project = projectsRep.GetEntity(id); if (project != null) { if (project.CompanyId == CurrentUser.CompanyId) { return View(project); } else { return Error(Loc.Dic.error_no_permission); } } else { return Error(Loc.Dic.error_projects_get_error); } } } else { return Error(Loc.Dic.error_no_permission); } }
public ActionResult Edit(Projects_ParentProject projects_parentproject) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject projectFromDB; using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { projectFromDB = projectsRep.GetEntity(projects_parentproject.Id); if (projectFromDB != null) { if (projectFromDB.CompanyId == CurrentUser.CompanyId) { projectFromDB.Name = projects_parentproject.Name; projectsRep.Update(projectFromDB); return RedirectToAction("Index"); } else { return Error(Loc.Dic.error_no_permission); } } else { return Error(Loc.Dic.error_projects_get_error); } } } else { return Error(Loc.Dic.error_no_permission); } }
public ActionResult DeleteConfirmed(int id) { if (Authorized(RoleType.SystemManager)) { Projects_ParentProject project; using (OrdersRepository orderssRep = new OrdersRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) { project = projectsRep.GetEntity(id); if (project != null) { if (project.CompanyId == CurrentUser.CompanyId) { project.IsActive = false; Projects_ParentProject update = projectsRep.Update(project); if (update != null) return RedirectToAction("Index"); else return Error(Loc.Dic.error_projects_get_error); } else { return Error(Loc.Dic.error_no_permission); } } else { return Error(Loc.Dic.error_projects_get_error); } } } else { return Error(Loc.Dic.error_no_permission); } }
public ActionResult Create(Budgets_Expenses budgets_expenses) { return Error(Loc.Dic.Error_NoPermission); if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { Budget budget; Projects_ParentProject project; Projects_SubProject subProject; using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { budget = budgetRep.GetEntity(budgets_expenses.BudgetId); project = projectsRep.GetEntity(budgets_expenses.ParentProjectId.Value); subProject = subProjectsRep.GetEntity(budgets_expenses.SubProjectId.Value); } if (budget != null && project != null && subProject != null) { if (budget.CompanyId == CurrentUser.CompanyId && project.CompanyId == CurrentUser.CompanyId && subProject.CompanyId == CurrentUser.CompanyId) { if (project.IsActive && subProject.IsActive) { bool wasCreated; budgets_expenses.CompanyId = CurrentUser.CompanyId; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) { wasCreated = expensesRep.Create(budgets_expenses); } if (wasCreated) return RedirectToAction("Index"); else return Error(Loc.Dic.error_expenses_create_error); } else { return Error(Loc.Dic.error_invalid_form); } } 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); } }
public ActionResult Edit(Budgets_Expenses budgets_expenses) { return Error(Loc.Dic.Error_NoPermission); if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { Budgets_Expenses expenseFromDB; Budget budget; Projects_ParentProject project; Projects_SubProject subProject; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { expenseFromDB = expensesRep.GetEntity(budgets_expenses.Id); budget = budgetRep.GetEntity(budgets_expenses.BudgetId); project = projectsRep.GetEntity(budgets_expenses.ParentProjectId.Value); subProject = subProjectsRep.GetEntity(budgets_expenses.SubProjectId.Value); if (expenseFromDB != null) { if (budget != null && project != null && subProject != null) { if (budget.CompanyId == CurrentUser.CompanyId && project.CompanyId == CurrentUser.CompanyId && subProject.CompanyId == CurrentUser.CompanyId) { if (project.IsActive && subProject.IsActive) { if (budgets_expenses.Amount < expenseFromDB.Amount) { decimal? allocatedToExpense; using (AllocationRepository allocationsRep = new AllocationRepository(CurrentUser.CompanyId)) { allocatedToExpense = allocationsRep.GetList() .Where(x => x.ExpenseId == expenseFromDB.Id) .Sum(allocation => (decimal?)allocation.CompanyId); //.Sum(allocation => (decimal?)allocation.Amount); } if (allocatedToExpense.HasValue && allocatedToExpense > budgets_expenses.Amount) return Error(Loc.Dic.error_expenses_allocations_exeeds_amount); } expenseFromDB.BudgetId = budgets_expenses.BudgetId; expenseFromDB.ParentProjectId = budgets_expenses.ParentProjectId; expenseFromDB.SubProjectId = budgets_expenses.SubProjectId; expenseFromDB.Amount = budgets_expenses.Amount; expenseFromDB.CustomName = budgets_expenses.CustomName; Budgets_Expenses update = expensesRep.Update(expenseFromDB); if (update != null) return RedirectToAction("Index"); else return Error(Loc.Dic.error_expenses_create_error); } else { return Error(Loc.Dic.error_invalid_form); } } else { return Error(Loc.Dic.error_no_permission); } } else { return Error(Loc.Dic.error_database_error); } } else { return Error(Loc.Dic.error_expenses_get_error); } } } else { return Error(ModelState); } } 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_Expenses expense; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { expense = expensesRep.GetEntity(id); if (expense != null) { if (expense.CompanyId == CurrentUser.CompanyId) { List<SelectListItemDB> budgetsList; List<SelectListItemDB> projectsList; List<SelectListItemDB> subProjectsList; try { 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(); projectsList = projectsRep.GetList() .Where(type => type.CompanyId == CurrentUser.CompanyId) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); subProjectsList = subProjectsRep.GetList() .Where(type => type.CompanyId == CurrentUser.CompanyId) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); } catch { return Error(Loc.Dic.error_database_error); } ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name", expense.BudgetId); ViewBag.ParentProjectId = new SelectList(projectsList, "Id", "Name", expense.ParentProjectId); ViewBag.SubProjectId = new SelectList(subProjectsList, "Id", "Name", expense.SubProjectId); return View(expense); } 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_Expenses budgets_expenses) { return(Error(Loc.Dic.Error_NoPermission)); if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { Budgets_Expenses expenseFromDB; Budget budget; Projects_ParentProject project; Projects_SubProject subProject; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { expenseFromDB = expensesRep.GetEntity(budgets_expenses.Id); budget = budgetRep.GetEntity(budgets_expenses.BudgetId); project = projectsRep.GetEntity(budgets_expenses.ParentProjectId.Value); subProject = subProjectsRep.GetEntity(budgets_expenses.SubProjectId.Value); if (expenseFromDB != null) { if (budget != null && project != null && subProject != null) { if (budget.CompanyId == CurrentUser.CompanyId && project.CompanyId == CurrentUser.CompanyId && subProject.CompanyId == CurrentUser.CompanyId) { if (project.IsActive && subProject.IsActive) { if (budgets_expenses.Amount < expenseFromDB.Amount) { decimal?allocatedToExpense; using (AllocationRepository allocationsRep = new AllocationRepository(CurrentUser.CompanyId)) { allocatedToExpense = allocationsRep.GetList() .Where(x => x.ExpenseId == expenseFromDB.Id) .Sum(allocation => (decimal?)allocation.CompanyId); //.Sum(allocation => (decimal?)allocation.Amount); } if (allocatedToExpense.HasValue && allocatedToExpense > budgets_expenses.Amount) { return(Error(Loc.Dic.error_expenses_allocations_exeeds_amount)); } } expenseFromDB.BudgetId = budgets_expenses.BudgetId; expenseFromDB.ParentProjectId = budgets_expenses.ParentProjectId; expenseFromDB.SubProjectId = budgets_expenses.SubProjectId; expenseFromDB.Amount = budgets_expenses.Amount; expenseFromDB.CustomName = budgets_expenses.CustomName; Budgets_Expenses update = expensesRep.Update(expenseFromDB); if (update != null) { return(RedirectToAction("Index")); } else { return(Error(Loc.Dic.error_expenses_create_error)); } } else { return(Error(Loc.Dic.error_invalid_form)); } } else { return(Error(Loc.Dic.error_no_permission)); } } else { return(Error(Loc.Dic.error_database_error)); } } else { return(Error(Loc.Dic.error_expenses_get_error)); } } } else { return(Error(ModelState)); } } 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_Expenses expense; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { expense = expensesRep.GetEntity(id); if (expense != null) { if (expense.CompanyId == CurrentUser.CompanyId) { List <SelectListItemDB> budgetsList; List <SelectListItemDB> projectsList; List <SelectListItemDB> subProjectsList; try { 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(); projectsList = projectsRep.GetList() .Where(type => type.CompanyId == CurrentUser.CompanyId) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); subProjectsList = subProjectsRep.GetList() .Where(type => type.CompanyId == CurrentUser.CompanyId) .Select(x => new SelectListItemDB() { Id = x.Id, Name = x.Name }) .ToList(); } catch { return(Error(Loc.Dic.error_database_error)); } ViewBag.BudgetId = new SelectList(budgetsList, "Id", "Name", expense.BudgetId); ViewBag.ParentProjectId = new SelectList(projectsList, "Id", "Name", expense.ParentProjectId); ViewBag.SubProjectId = new SelectList(subProjectsList, "Id", "Name", expense.SubProjectId); return(View(expense)); } 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 Create(Budgets_Expenses budgets_expenses) { return(Error(Loc.Dic.Error_NoPermission)); if (Authorized(RoleType.SystemManager)) { if (ModelState.IsValid) { Budget budget; Projects_ParentProject project; Projects_SubProject subProject; using (BudgetsRepository budgetRep = new BudgetsRepository(CurrentUser.CompanyId)) using (ParentProjectsRepository projectsRep = new ParentProjectsRepository()) using (SubProjectsRepository subProjectsRep = new SubProjectsRepository()) { budget = budgetRep.GetEntity(budgets_expenses.BudgetId); project = projectsRep.GetEntity(budgets_expenses.ParentProjectId.Value); subProject = subProjectsRep.GetEntity(budgets_expenses.SubProjectId.Value); } if (budget != null && project != null && subProject != null) { if (budget.CompanyId == CurrentUser.CompanyId && project.CompanyId == CurrentUser.CompanyId && subProject.CompanyId == CurrentUser.CompanyId) { if (project.IsActive && subProject.IsActive) { bool wasCreated; budgets_expenses.CompanyId = CurrentUser.CompanyId; using (BudgetsExpensesRepository expensesRep = new BudgetsExpensesRepository()) { wasCreated = expensesRep.Create(budgets_expenses); } if (wasCreated) { return(RedirectToAction("Index")); } else { return(Error(Loc.Dic.error_expenses_create_error)); } } else { return(Error(Loc.Dic.error_invalid_form)); } } 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)); } }