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