public void DeleteActivity(int id)
{
TransAction actionToDelete = DB.TransActions.Where(p => p.ActivityID == id).SingleOrDefault();
if (actionToDelete != null)
{
DB.TransActions.Remove(actionToDelete);
DB.SaveChanges();
}
}
public ActivitiesDTO AddActivity(ActivitiesDTO activity)
{
TransAction transAction = new TransAction
{
Activity_Type = activity.typeOfAction,
Date_of_Activity = activity.date,
Value_of_Activity = activity.value,
Description_of_Activity = activity.description,
Type_Of_Expense = activity.typeOfExpense
};
DB.TransActions.Add(transAction);
DB.SaveChanges();
activity.id = transAction.ActivityID;
return(activity);
}
public ActivitiesDTO EditActivity(ActivitiesDTO activity)
{
TransAction actionToEdit = DB.TransActions.Where(p => p.ActivityID == activity.id).SingleOrDefault();
if (actionToEdit == null)
{
return(null);
}
actionToEdit.Activity_Type = activity.typeOfAction;
actionToEdit.Date_of_Activity = activity.date;
actionToEdit.Value_of_Activity = activity.value;
actionToEdit.Description_of_Activity = activity.description;
actionToEdit.Type_Of_Expense = activity.typeOfExpense;
DB.SaveChanges();
return(activity);
}
