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();
     }
 }
 public static LABMeasure GetLABMeasureByIdLABStudy(Guid LABStudy)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.LABMeasure.Where(labmeasure => labmeasure.idLABStudy == LABStudy).FirstOrDefault();
     }
 }
 public static LicenseType GetLicenseTypeeByName(string pName)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.LicenseType.Where(lic => lic.LicenseTypeName.ToLower().Equals(pName.ToLower())).FirstOrDefault();
     }
 }
 /// <summary>
 /// Récupération d'un UserAuthentification à partir d'un token 
 /// </summary>
 /// <param name="sToken"></param>
 /// <returns></returns>
 public static Upsilab.Data.Model.UserAuthentication GetUserAuthentificationByToken(String sToken)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.UserAuthentication.Where(userAuth => userAuth.UserAuthToken.Equals(sToken.Trim())).FirstOrDefault();
     }
 }
 public static ag_upsideo_fournisseur_code GetFournisseurCodeByFournisseurId(int idfournisseur)
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.ag_upsideo_fournisseur_code.Where(frn => frn.idfrontfournisseur == idfournisseur).FirstOrDefault();
     }
 }
 public static List<DateSouscriptionModel> GetDateSouscriptionByClient(Guid idclient)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.ExecuteStoreQuery<DateSouscriptionModel>("exec agreg.GetDateDeSouscriptionCompteByClient @IdClient", new SqlParameter("@IdClient", idclient)).ToList<DateSouscriptionModel>();
     }
 }
 public static List<Sponsor> GetAllSponsors()
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.Sponsor.OrderBy(s => s.Name).ToList();
     }
 }
Example #27
0
        public static Boolean IsEmailUsed(String email, Data.Model.User user = null)
        {
            using (UpsilabEntities context = new UpsilabEntities())
            {
                if (user != null)
                {
                    var existingUser = context.User.Where(u => u.UserEmail == email && !u.IsDeleted).FirstOrDefault();

                    if (existingUser != null)
                    {
                        if (user.idUser == existingUser.idUser)
                            return false;
                        else return true;
                    }
                    else return false;
                }
                else
                {
                    var existingUser = context.User.Where(u => u.UserEmail == email && !u.IsDeleted).FirstOrDefault();

                    if (existingUser != null)
                        return true;
                    else return false;
                }
            }
        }
 public static Sponsor GetById(int idSponsor)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.Sponsor.Where(s => s.IdSponsor == idSponsor).FirstOrDefault();
     }
 }
 public static LABModel GetLABModelsById(Guid pId)
 {
     using (UpsilabEntities db = new UpsilabEntities())
     {
         return db.LABModel.Where(lm=>lm.idLABModel == pId).FirstOrDefault();                
     }
 }
 public static IList<QuestionAssessment> Get()
 {
     using (UpsilabEntities context = new UpsilabEntities())
     {
         return context.QuestionAssessment.ToList();
     }
 }