public int addNewTaskOtherExpense(TaskOtherExpense taskOtherExpense)
{
string sql =
$@"INSERT INTO [dbo].[Task_Other_Expense]([Task_Other_Expense_Id], [Expense_Name], [Task_Expense_Id]) VALUES (@Task_Other_Expense_Id, @Expense_Name, '{taskOtherExpense.TaskExpense.Task_Expense_Id}');";
return(unitOfWork.Connection.Execute(sql, taskOtherExpense, unitOfWork.Transaction));
}
public bool AddOtherExpense(TaskOtherExpense taskOtherExpense)
{
using (DalSession dalSession = new DalSession())
{
UnitOfWork unitOfWork = dalSession.UnitOfWork();
unitOfWork.Begin();
try
{
_taskOtherExpenseRepository = new TaskOtherExpenseRepository(unitOfWork);
_taskExpenseRepository = new TaskExpenseRepository(unitOfWork);
taskOtherExpense.Task_Other_Expense_Id = Guid.NewGuid().ToString();
taskOtherExpense.TaskExpense.Task_Expense_Id = Guid.NewGuid().ToString();
if (_taskExpenseRepository.addNewTaskExpense(taskOtherExpense.TaskExpense) == 1)
{
if (_taskOtherExpenseRepository.addNewTaskOtherExpense(taskOtherExpense) == 1)
{
unitOfWork.Commit();
return(true);
}
else
{
unitOfWork.Rollback();
return(false);
}
}
else
{
unitOfWork.Rollback();
return(false);
}
}
catch
{
unitOfWork.Rollback();
throw;
}
}
}
