protected DBContextResult <object> InsertExpense(TRN_Expense p_TRN_Expense)
{
return(ExecuteDALMethod <TRN_Expense, object>(db, (DataContext, P_TRN_Expense) =>
{
DataContext.TRN_Expense.Add(P_TRN_Expense);
DataContext.SaveChanges();
return null;
}, p_TRN_Expense));
}
protected DBContextResult <object> DeleteExpense(int p_ExpenseId)
{
return(ExecuteDALMethod <int, object>(db, (DataContext, P_ExpenseId) =>
{
TRN_Expense Obj = DataContext.TRN_Expense.Find(P_ExpenseId);
Obj.IsActive = false;
DataContext.SaveChanges();
return null;
}, p_ExpenseId));
}
protected DBContextResult <object> UpdateExpense(TRN_Expense p_TRN_Expense)
{
return(ExecuteDALMethod <TRN_Expense, object>(db, (DataContext, P_TRN_Expense) =>
{
TRN_Expense Obj = DataContext.TRN_Expense.Find(P_TRN_Expense.ExpenseId);
Obj.CategoryId = P_TRN_Expense.CategoryId;
Obj.Amount = P_TRN_Expense.Amount;
Obj.CreatedDate = P_TRN_Expense.CreatedDate;
Obj.Note = P_TRN_Expense.Note;
Obj.ModifiedDate = P_TRN_Expense.ModifiedDate;
DataContext.SaveChanges();
return null;
}, p_TRN_Expense));
}
public DBContextResult <object> DAL_UpdateExpense(TRN_Expense p_TRN_Expense)
{
return(UpdateExpense(p_TRN_Expense));
}
public DBContextResult <object> DAL_SaveExpense(TRN_Expense p_TRN_Expense)
{
return(InsertExpense(p_TRN_Expense));
}
