public bool UpdateComprehensiveAssessment(ComprehensiveAssessment comprehensiveAssessmentData)
        {
            try
            {
                using (var dbModel = InitiateDbContext())
                {
                    var entity = dbModel.ComprehensiveAssessments.Find(comprehensiveAssessmentData.Id);

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

                    dbModel.Entry <ComprehensiveAssessment>(entity).CurrentValues.SetValues(comprehensiveAssessmentData);
                    dbModel.SaveChanges();

                    return(true);
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                throw;
            }
        }
 public int CreateComprehensiveAssessment(ComprehensiveAssessment comprehensiveAssessment)
 {
     try
     {
         using (var dbModel = InitiateDbContext())
         {
             dbModel.ComprehensiveAssessments.Add(comprehensiveAssessment);
             dbModel.SaveChanges();
             return(comprehensiveAssessment.Id);
         }
     }
     catch (Exception ex)
     {
         Debug.WriteLine(ex.ToString());
         throw;
     }
 }