public int addNewTaskEmpExpense(TaskEmpExpense taskEmpExpense) { string sql = $@"INSERT INTO [dbo].[Task_Emp_Expense]([Task_Emp_Expense_Id], [Task_Expense_Id], [User_Id]) VALUES (@Task_Emp_Expense_Id, '{taskEmpExpense.TaskExpense.Task_Expense_Id}', '{taskEmpExpense.User.User_Id}');"; return(unitOfWork.Connection.Execute(sql, taskEmpExpense, unitOfWork.Transaction)); }
public bool AddTaskEmpExpense(TaskEmpExpense taskEmpExpense) { using (DalSession dalSession = new DalSession()) { UnitOfWork unitOfWork = dalSession.UnitOfWork(); unitOfWork.Begin(); try { _taskExpenseRepository = new TaskExpenseRepository(unitOfWork); _taskEmpExpenseRepository = new TaskEmpExpenseRepository(unitOfWork); taskEmpExpense.TaskExpense.Task_Expense_Id = Guid.NewGuid().ToString(); taskEmpExpense.Task_Emp_Expense_Id = Guid.NewGuid().ToString(); if (_taskExpenseRepository.addNewTaskExpense(taskEmpExpense.TaskExpense) == 1) { if (_taskEmpExpenseRepository.addNewTaskEmpExpense(taskEmpExpense) == 1) { unitOfWork.Commit(); return(true); } else { unitOfWork.Rollback(); return(false); } } else { unitOfWork.Rollback(); return(false); } } catch { unitOfWork.Rollback(); throw; } } }