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(); } }
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(); } }