public List <TaskExpense> GetAllExpensesForTask(string projectTaskId) { using (DalSession dalSession = new DalSession()) { UnitOfWork unitOfWork = dalSession.UnitOfWork(); unitOfWork.Begin(); try { _taskExpenseRepository = new TaskExpenseRepository(unitOfWork); List <TaskExpense> expenses = _taskExpenseRepository.GetAllEXPsByProjectTaskId(projectTaskId); unitOfWork.Commit(); return(expenses); } catch { unitOfWork.Rollback(); throw; } } }
public TotalDetail GetTotalDetails() { using (DalSession dalSession = new DalSession()) { UnitOfWork unitOfWork = dalSession.UnitOfWork(); unitOfWork.Begin(); try { _projectRepository = new ProjectRepository(unitOfWork); _employeeRepo = new EmployeeRepo(unitOfWork); _assetRepository = new AssetRepository(unitOfWork); _taskExpenseRepository = new TaskExpenseRepository(unitOfWork); _projectIncomeRepository = new ProjectIncomeRepository(unitOfWork); TotalDetail totalDetail = new TotalDetail(); totalDetail.TotalProject = _projectRepository.GetTotalProjects(); totalDetail.TotalEmployees = _employeeRepo.GetTotalEmployees(); totalDetail.TotalAssets = _assetRepository.GetTotalAssets(); totalDetail.TotalIncome = _projectIncomeRepository.GetTotalProjectIncomesByMonthAndYear( DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString() ); totalDetail.TotalExpenses = _taskExpenseRepository.GetTotalProjectTasksExsByMonthAndYear( DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString() ); unitOfWork.Commit(); return(totalDetail); } catch { unitOfWork.Rollback(); throw; } } }
public bool AddAssetExpense(TaskAssetExpense taskAssetExpense) { using (DalSession dalSession = new DalSession()) { UnitOfWork unitOfWork = dalSession.UnitOfWork(); unitOfWork.Begin(); try { _taskAssetExpenseRepository = new TaskAssetExpenseRepository(unitOfWork); _taskExpenseRepository = new TaskExpenseRepository(unitOfWork); taskAssetExpense.Task_Asset_Expense_Id = Guid.NewGuid().ToString(); taskAssetExpense.TaskExpense.Task_Expense_Id = Guid.NewGuid().ToString(); if (_taskExpenseRepository.addNewTaskExpense(taskAssetExpense.TaskExpense) == 1) { if (_taskAssetExpenseRepository.addNewTaskAssetExpense(taskAssetExpense) == 1) { unitOfWork.Commit(); return(true); } else { unitOfWork.Rollback(); return(false); } } else { unitOfWork.Rollback(); return(false); } } catch { unitOfWork.Rollback(); throw; } } }