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