public static bool UpdateReference(DTO.NewFolder1.Reference reference)
        {
            try
            {
                var ReferenceDb = db.Reference.FirstOrDefault(p => p.RefId == reference.RefId);

                if (ReferenceDb != null)
                {
                    ReferenceDb.Date           = reference.Date;
                    ReferenceDb.Description    = reference.Description;
                    ReferenceDb.BornDate       = reference.BornDate;
                    ReferenceDb.IsCare         = reference.IsCare;
                    ReferenceDb.UserName       = reference.UserName;
                    ReferenceDb.ProfId         = reference.ProfId;
                    ReferenceDb.TypeRef        = reference.TypeRef;
                    ReferenceDb.recommendation = reference.recommendation;
                    db.SaveChanges();
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
 public static bool AddReference(DTO.NewFolder1.Reference reference)
 {
     try
     {
         var r = DTO.NewFolder1.Reference.GetReference(reference);
         r.users         = db.users.FirstOrDefault(x => x.UserId == r.UserName);
         r.Professions   = db.Professions.FirstOrDefault(y => y.ProfId == r.ProfId);
         r.TypeReference = db.TypeReference.FirstOrDefault(z => z.RefId == r.TypeRef);
         db.Reference.Add(r);
         db.SaveChanges();
         return(true);
     }
     catch (Exception)
     {
         return(false);
     }
 }