public static Upsilab.Data.Model.UserProfile GetUserProfileByIdUserProfile(Int32 idUserProfile)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.UserProfile.Where(profile => profile.idUserProfile == idUserProfile).FirstOrDefault();
     }
 }

        public static Upsilab.Data.Model.User CreateUser(Upsilab.Data.Model.User user, String pasword)
        {
            user.UserPassword = UserBL.Encrypt(pasword);

            using (UpsilabEntities context = new UpsilabEntities())
            {
                var _user = new Data.Model.User();
                _user.idUser = user.idUser;
                _user.idUserProfile = user.idUserProfile;
                _user.UserLogin = user.UserLogin;
                _user.UserPassword = user.UserPassword;
                _user.UserName = user.UserName;
                _user.UserFirstName = user.UserFirstName;
                _user.UserMobilePhone = user.UserMobilePhone;
                _user.UserEmail = user.UserEmail;
                _user.IsActive = user.IsActive;
                _user.IsDeleted = user.IsDeleted;
                _user.DateCreated = DateTime.Now;
                _user.IdLicenseReport = user.IdLicenseReport;
                _user.IdLicenseLab = user.IdLicenseLab;
                //context.User.AddObject(user);
                context.User.AddObject(_user);
                context.SaveChanges();
            }

            return user;
        }

        public static List<LABAnswer> GetAnswersByIdParentQuestionAndIdCustomerProspect(LABStudyModel labStudyModel)
        {
            var lstLabAnswers = new List<LABAnswer>();
            LABAnswer tempAnswer = null;

            using (UpsilabEntities db = new UpsilabEntities())
            {

                //Get all answers for the current IdLabStudy
                IList<LABAnswer> allLABAnswers = db.LABAnswer.Where(ans => ans.idLABStudy == labStudyModel.idLABStudy
                                                                    && !ans.LABQuestion.IsDeleted).ToList();

                //Get answers for each question
                foreach (LABQuestion question in labStudyModel.LABQuestions)
                {
                    tempAnswer = allLABAnswers.Where(ans => ans.idLABQuestion == question.idLABQuestion).FirstOrDefault();

                    if (tempAnswer != null)
                    {
                        lstLabAnswers.Add(tempAnswer);
                    }
                }
            }

            return lstLabAnswers;
        }

 public static CRMListeDiffusion GetListByid(Guid pIdList)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.CRMListeDiffusion.Where(diff => diff.idliste == pIdList).FirstOrDefault();
     }
 }

        public static List<CustomEnum> GetAllCustomEnums()
        {
            List<Upsilab.Data.Model.CustomEnum> returnValue = null;
            if (ConfigurationManager.ExtranetType == @"EXE")
            {
                using (UpsilabEntities context = new UpsilabEntities())
                {
                    returnValue = context.CustomEnum.ToList();
                }
            }
            else
            {
                if (!CacheManager.Exists(CustomEnumBL.CacheKey))
                {
                    using (UpsilabEntities context = new UpsilabEntities())
                    {
                        returnValue = context.CustomEnum.ToList();
                        CacheManager.Add<List<CustomEnum>>(returnValue, CustomEnumBL.CacheKey, ConfigurationManager.CacheTimeout);
                    }
                }

                if (returnValue == null)
                    CacheManager.Get<List<CustomEnum>>(CustomEnumBL.CacheKey, out returnValue);
            }


            return returnValue;
        }

 public static SignatureTransactionStatusLog GetBySignatureAndDocument(Guid signatureTransactionId, int documentStatusId)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.SignatureTransactionStatusLog.Where(x => x.idDocumentStatus == documentStatusId && x.idSignatureTransaction == signatureTransactionId).FirstOrDefault();
     }
 }

 public static DocumentDB GetDocumentByIdSignatureTransaction(Guid idSignatureTransaction, string documentType)
 {
     using (var db = new UpsilabEntities())
     {
         return db.Document.FirstOrDefault(doc => doc.idSignatureTransaction == idSignatureTransaction && doc.DocumentType == documentType);
     }
 }

 public static Signatory GetSignatory(Guid idTransaction, Guid idUser)
 {
     using (var context = new UpsilabEntities())
     {
         return context.Signatory.FirstOrDefault(x => x.idSignatureTransaction == idTransaction && x.idUser == idUser);
     }
 }

 public static List<Signatory> GetSignatories(Guid idTransaction)
 {
     using (var context = new UpsilabEntities())
     {
         return context.Signatory.Where(x => x.idSignatureTransaction == idTransaction).ToList();
     }
 }

 public static ag_upsideo_referentiel GetReferentielById(int id)
 {
     using (var ctx = new UpsilabEntities())
     {
         return ctx.ag_upsideo_referentiel.FirstOrDefault(s => s.idrefsupport == id);
     }
 }

 public static Signatory CreateSignatory(Guid idTransaction, Guid idUser, string role)
 {
     using (var context = new UpsilabEntities())
     {
         return CreateSignatory(idTransaction, idUser, role, context);
     }
 }

 public static ag_upsideo_referentiel GetReferentielByName(string name)
 {
     using (var ctx = new UpsilabEntities())
     {
         return ctx.ag_upsideo_referentiel.FirstOrDefault(s => s.nomsupport == name);
     }
 }

 public static ag_upsideo_referentiel GetSupportReferentielByCodeIsIn(string codeisin)
 {
     using (var ctx = new UpsilabEntities())
     {
         return ctx.ag_upsideo_referentiel.FirstOrDefault(s => s.codeisin.Trim().ToUpper() == codeisin.Trim().ToUpper());
     }
 }

 public static Upsilab.Data.Model.UserProfile GetUserProfileByProfileName(string sProfileName)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.UserProfile.Where(profile => profile.UserProfileName.Equals(sProfileName)).FirstOrDefault();
     }
 }

 public static SignatureTransactionStatusLog Add(Guid signatureTransactionId, int documentStatusId)
 {
     using (var context = new UpsilabEntities())
     {
         return Add(signatureTransactionId, documentStatusId, context);
     }
 }

 public static DocumentStatus GetById(int id)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.DocumentStatus.Where(s => s.idDocumentStatus == id).FirstOrDefault();
     }
 }

 public static SignatureTransactionStatusLog GetById(int signatureTransactionStatutId)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.SignatureTransactionStatusLog.Where(x => x.idSignatureTransactionStatus == signatureTransactionStatutId).FirstOrDefault();
     }
 }

 public static DocumentStatus GetByCode(string code)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.DocumentStatus.Where(s => s.NameKey.ToUpper() == code.ToUpper()).FirstOrDefault();
     }
 }

 public static IList<ag_upsideo_typesupport> GetTypeSupports()
 {
     using (var ctx = new UpsilabEntities())
     {
         return ctx.ag_upsideo_typesupport.OrderBy(ts => ts.typesupport).ToList();
     }
 }

 public static List<DocumentStatus> GetAll()
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.DocumentStatus.ToList();
     }
 }