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