public bool UpdateTreatmentGoal(TreatmentGoal goalData)
        {
            try
            {
                using (var dbModel = InitiateDbContext())
                {
                    var entity = dbModel.TreatmentGoals.Find(goalData.Id);

                    if (entity == null)
                    {
                        return(false);
                    }

                    dbModel.Entry <TreatmentGoal>(entity).CurrentValues.SetValues(goalData);
                    dbModel.SaveChanges();

                    return(true);
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                throw;
            }
        }
        public int CreateTreatmentGoal(TreatmentGoal goalData)
        {
            try
            {
                using (var dbModel = InitiateDbContext())
                {
                    dbModel.TreatmentGoals.Add(goalData);
                    dbModel.SaveChanges();

                    return(goalData.Id);
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                throw;
            }
        }