public Dictionary <int, string> GetOrgAdmins(Dictionary <int, string> SelectedOrgList) { Dictionary <int, string> GetOrgAdmins = new Dictionary <int, string>(); int i = 0; try { foreach (var org in SelectedOrgList) { using (var Context = DataObjectFactory.CreateContext()) { int OrgId = int.Parse(org.Value); var AdminList = Context.UserOrganizations.Where(x => x.OrganizationID == OrgId && x.RoleId == 2 && x.Active == true).ToList(); foreach (var item in AdminList) { GetOrgAdmins.Add(i, item.User.EmailAddress); i++; } } } } catch (Exception ex) { throw (ex); } return(GetOrgAdmins); }
public List <UserBO> GetOrgAdminsByFormId(string FormId) { List <UserBO> BoList = new List <UserBO>(); Dictionary <int, string> GetOrgAdmins = new Dictionary <int, string>(); Guid Id = new Guid(FormId); try { using (var Context = DataObjectFactory.CreateContext()) { SurveyMetaData Response = Context.SurveyMetaDatas.First(x => x.SurveyId == Id); var _Org = new HashSet <int>(Response.Organizations.Select(x => x.OrganizationId)); var Orgs = Context.Organizations.Where(t => _Org.Contains(t.OrganizationId)).ToList(); foreach (var Org in Orgs) { var AdminList = Context.UserOrganizations.Where(x => x.OrganizationID == Org.OrganizationId && x.RoleId == 2 && x.Active == true); foreach (var Admin in AdminList) { UserBO UserBO = new UserBO(); UserBO.EmailAddress = Admin.User.EmailAddress; UserBO.UserId = Admin.User.UserID; BoList.Add(UserBO); } } } } catch (Exception ex) { throw (ex); } return(BoList); }
public FormSettingBO GetFormSettings() { FormSettingBO FormSettingBO = new FormSettingBO(); Dictionary <int, string> DataAccessRuleIds = new Dictionary <int, string>(); Dictionary <string, string> DataAccessRuleDescription = new Dictionary <string, string>(); int selectedDataAccessRuleId = -1;; var Context = DataObjectFactory.CreateContext(); try { //// Available DataAccess Rule Ids list IQueryable <DataAccessRule> RuleIDs = Context.DataAccessRules.ToList().AsQueryable(); foreach (var Rule in RuleIDs) { DataAccessRuleIds.Add(Rule.RuleId, Rule.RuleName); DataAccessRuleDescription.Add(Rule.RuleName, Rule.RuleDescription); } FormSettingBO.SelectedDataAccessRule = selectedDataAccessRuleId; FormSettingBO.DataAccessRuleDescription = DataAccessRuleDescription; FormSettingBO.DataAccessRuleIds = DataAccessRuleIds; } catch (Exception ex) { throw (ex); } return(FormSettingBO); }
public OrganizationBO GetOrganizationInfoByKey(string key) { OrganizationBO OrganizationBO = new OrganizationBO(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = (from response in Context.Organizations where response.OrganizationKey == key select response); if (Query.Count() > 0) { OrganizationBO = Mapper.Map(Query.SingleOrDefault()); } else { return(null); } } } catch (Exception ex) { throw (ex); } return(OrganizationBO); }
public void UpDateColumnNames(FormSettingBO FormSettingBO, string FormId) { Guid Id = new Guid(FormId); try { using (var Context = DataObjectFactory.CreateContext()) { IQueryable <ResponseDisplaySetting> ColumnList = Context.ResponseDisplaySettings.Where(x => x.FormId == Id); //Delete old columns foreach (var item in ColumnList) { Context.ResponseDisplaySettings.DeleteObject(item); } Context.SaveChanges(); //insert new columns ResponseDisplaySetting ResponseDisplaySettingEntity = new ResponseDisplaySetting(); foreach (var item in FormSettingBO.ColumnNameList) { ResponseDisplaySettingEntity = Mapper.ToColumnName(item, Id); Context.AddToResponseDisplaySettings(ResponseDisplaySettingEntity); //Context.SaveChanges(); } Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Gets a specific Organization. /// </summary> /// <param name="OrganizationId">Unique Organization identifier.</param> /// <returns>Organization.</returns> public List <OrganizationBO> GetOrganizationKeys(string OrganizationName) { List <OrganizationBO> OrganizationBO = new List <OrganizationBO>(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = from response in Context.Organizations where response.Organization1 == OrganizationName select response; var DataRow = Query; foreach (var Row in DataRow) { OrganizationBO.Add(Mapper.Map(Row)); } } } catch (Exception ex) { throw (ex); } return(OrganizationBO); }
public bool InsertUser(UserBO User, OrganizationBO OrgBO) { try { User.UGuid = Guid.NewGuid(); using (var Context = DataObjectFactory.CreateContext()) { var Org = Context.Organizations.Where(x => x.OrganizationId == OrgBO.OrganizationId).Single(); Context.Organizations.Attach(Org); Context.Users.AddObject(Mapper.ToUserEntity(User)); UserOrganization UserOrganizationEntity = Mapper.ToUserOrganizationEntity(User, OrgBO); Context.UserOrganizations.AddObject(UserOrganizationEntity); Context.SaveChanges(); } return(true); } catch (Exception ex) { throw (ex); } }
public List <OrganizationBO> GetOrganizationsByUserId(int UserId) { List <OrganizationBO> result = new List <OrganizationBO>(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = from OrganizationTable in Context.Organizations from UserOrganizationTable in Context.UserOrganizations where UserOrganizationTable.OrganizationID == OrganizationTable.OrganizationId && UserOrganizationTable.UserID == UserId && UserOrganizationTable.Active == true && OrganizationTable.IsEnabled == true select OrganizationTable; var DataRow = Query; foreach (var Row in DataRow) { result.Add(Mapper.Map(Row)); } return(result); } } catch (Exception ex) { throw (ex); } }
public void UpDateFormMode(FormInfoBO FormInfoBO) { try { Guid Id = new Guid(FormInfoBO.FormId); //Update Form Mode using (var Context = DataObjectFactory.CreateContext()) { var Query = from response in Context.SurveyMetaDatas where response.SurveyId == Id select response; var DataRow = Query.Single(); DataRow.IsDraftMode = FormInfoBO.IsDraftMode; DataRow.IsShareable = FormInfoBO.IsShareable; DataRow.DataAccessRuleId = FormInfoBO.DataAccesRuleId; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
public OrganizationBO GetOrganizationByOrgId(int OrganizationId) { OrganizationBO OrganizationBO = new OrganizationBO(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = from response in Context.Organizations where response.OrganizationId == OrganizationId select response; if (Query.Count() > 0) { OrganizationBO = Mapper.Map(Query.SingleOrDefault()); } else { return(null); } } } catch (Exception ex) { throw (ex); } return(OrganizationBO); }
public List <OrganizationBO> GetOrganizationInfo() { List <OrganizationBO> OrganizationBO = new List <OrganizationBO>(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = (from response in Context.Organizations select response); var DataRow = Query.Distinct(); foreach (var Row in DataRow) { OrganizationBO.Add(Mapper.Map(Row)); } } } catch (Exception ex) { throw (ex); } return(OrganizationBO); }
/// <summary> /// Updates a SurveyInfo. /// </summary> /// <param name="SurveyInfo">SurveyInfo.</param> public void UpdateSurveyInfo(SurveyInfoBO SurveyInfo) { try { Guid Id = new Guid(SurveyInfo.SurveyId); //Update Survey using (var Context = DataObjectFactory.CreateContext()) { //var Query = from response in Context.SurveyMetaDatas // where response.SurveyId == Id // select response; //var DataRow = Query.Single(); //DataRow = Mapper.ToEF(SurveyInfo); SurveyMetaData Row = Context.SurveyMetaDatas.First(x => x.SurveyId == Id); Row.IsSQLProject = SurveyInfo.IsSqlProject; Row.TemplateXML = SurveyInfo.XML; Row.IsDraftMode = SurveyInfo.IsDraftMode; Row.IsShareable = SurveyInfo.IsShareable; Row.DataAccessRuleId = SurveyInfo.DataAccessRuleId; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Inserts a new SurveyInfo. /// </summary> /// <remarks> /// Following insert, SurveyInfo object will contain the new identifier. /// </remarks> /// <param name="SurveyInfo">SurveyInfo.</param> public void InsertSurveyInfo(SurveyInfoBO SurveyInfo) { int OrganizationId = 0; try { using (var Context = DataObjectFactory.CreateContext()) { //retrieve OrganizationId based on OrganizationKey using (var ContextOrg = DataObjectFactory.CreateContext()) { string OrgKey = Epi.Web.Enter.Common.Security.Cryptography.Encrypt(SurveyInfo.OrganizationKey.ToString()); OrganizationId = ContextOrg.Organizations.FirstOrDefault(x => x.OrganizationKey == OrgKey).OrganizationId; } SurveyInfo.TemplateXMLSize = RemoveWhitespace(SurveyInfo.XML).Length; SurveyInfo.DateCreated = DateTime.Now; var SurveyMetaDataEntity = Mapper.Map(SurveyInfo); User User = Context.Users.FirstOrDefault(x => x.UserID == SurveyInfo.OwnerId); SurveyMetaDataEntity.Users.Add(User); SurveyMetaDataEntity.OrganizationId = OrganizationId; Context.AddToSurveyMetaDatas(SurveyMetaDataEntity); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
public List <OrganizationBO> GetOrganizationInfoByOrgKey(string gOrgKeyEncrypted) { List <OrganizationBO> OrganizationBO = new List <OrganizationBO>(); try { using (var Context = DataObjectFactory.CreateContext()) { var Query = (from response in Context.Organizations where response.OrganizationKey == gOrgKeyEncrypted && response.IsEnabled == true select response); var DataRow = Query; foreach (var Row in DataRow) { OrganizationBO.Add(Mapper.Map(Row)); } } } catch (Exception ex) { throw (ex); } return(OrganizationBO); }
/// <summary> /// Gets SurveyInfo based on a list of ids /// </summary> /// <param name="SurveyInfoId">Unique SurveyInfo identifier.</param> /// <returns>SurveyInfo.</returns> public List <SurveyInfoBO> GetSurveyInfo(List <string> SurveyInfoIdList, int PageNumber = -1, int PageSize = -1) { List <SurveyInfoBO> result = new List <SurveyInfoBO>(); if (SurveyInfoIdList.Count > 0) { try { foreach (string surveyInfoId in SurveyInfoIdList.Distinct()) { Guid Id = new Guid(surveyInfoId); using (var Context = DataObjectFactory.CreateContext()) { result.Add(Mapper.Map(Context.SurveyMetaDatas.FirstOrDefault(x => x.SurveyId == Id))); } } } catch (Exception ex) { throw (ex); } } else { try { using (var Context = DataObjectFactory.CreateContext()) { result = Mapper.Map(Context.SurveyMetaDatas.ToList()); } } catch (Exception ex) { throw (ex); } } // remove the items to skip // remove the items after the page size if (PageNumber > 0 && PageSize > 0) { result.Sort(CompareByDateCreated); // remove the items to skip if (PageNumber * PageSize - PageSize > 0) { result.RemoveRange(0, PageSize); } if (PageNumber * PageSize < result.Count) { result.RemoveRange(PageNumber * PageSize, result.Count - PageNumber * PageSize); } } return(result); }
public UserBO GetCurrentUser(int UserId) { UserBO Result = new UserBO(); using (var Context = DataObjectFactory.CreateContext()) { Result = Mapper.MapToUserBO(Context.Users.Single(x => x.UserID == UserId)); } return(Result); }
public bool UpdateUserOrganization(UserBO User, OrganizationBO OrgBO) { UserOrganization UserOrganizationEntity = Mapper.ToUserOrganizationEntity(User, OrgBO); using (var Context = DataObjectFactory.CreateContext()) { UserOrganizationEntity.UserID = User.UserId; Context.AddToUserOrganizations(UserOrganizationEntity); Context.SaveChanges(); return(true); } }
public List <SurveyInfoBO> GetSurveyInfoByOrgKey(string SurveyId, string Okey) { List <SurveyInfoBO> result = new List <SurveyInfoBO>(); List <SurveyMetaData> responseList = new List <SurveyMetaData>(); int OrganizationId = 0; try { using (var Context = DataObjectFactory.CreateContext()) { var Query = (from response in Context.Organizations where response.OrganizationKey == Okey select response).SingleOrDefault(); if (Query != null) { OrganizationId = Query.OrganizationId; } } } catch (Exception ex) { throw (ex); } if (!string.IsNullOrEmpty(SurveyId)) { try { Guid Id = new Guid(SurveyId); using (var Context = DataObjectFactory.CreateContext()) { responseList.Add(Context.SurveyMetaDatas.FirstOrDefault(x => x.SurveyId == Id && x.OrganizationId == OrganizationId)); if (responseList[0] != null) { result = Mapper.Map(responseList); } } } catch (Exception ex) { throw (ex); } } return(result); }
public bool IsUserExistsInOrganizaion(UserBO User, OrganizationBO OrgBO) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from userorganization in Context.UserOrganizations where userorganization.UserID == User.UserId && userorganization.OrganizationID == OrgBO.OrganizationId select userorganization; bool Result = false; foreach (var user in UserQuery) { Result = true; } return(Result); }
public bool GetExistingUser(UserBO User) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from user in Context.Users where user.UserName == User.UserName && user.LastName == User.LastName && user.EmailAddress == User.EmailAddress select user; bool Result = false; foreach (var user in UserQuery) { Result = true; } return(Result); }
public bool IsUserExistsInOrganization(string OrgKey, int UserId) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from userorganization in Context.UserOrganizations join organization in Context.Organizations on userorganization.OrganizationID equals organization.OrganizationId where userorganization.UserID == UserId && organization.OrganizationKey == OrgKey select userorganization; bool Result = false; foreach (var user in UserQuery) { Result = true; } return(Result); }
public bool UpdateUserPassword(UserBO User) { try { var Context = DataObjectFactory.CreateContext(); var user = Context.Users.Single(a => a.UserName == User.UserName); user.PasswordHash = User.PasswordHash; user.ResetPassword = User.ResetPassword; Context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public void InsertConnectionString(DbConnectionStringBO ConnectionString) { try { using (var Context = DataObjectFactory.CreateContext()) { Context.usp_AddDatasource(ConnectionString.DatasourceServerName, ConnectionString.DatabaseType, ConnectionString.InitialCatalog, ConnectionString.PersistSecurityInfo, ConnectionString.DatabaseUserID, ConnectionString.SurveyId, ConnectionString.Password); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
public UserBO GetUser(UserBO User) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from user in Context.Users where user.UserName == User.UserName && user.PasswordHash == User.PasswordHash select user; UserBO Result = new UserBO(); foreach (var user in UserQuery) { Result = Mapper.MapToUserBO(user); return(Result); } return(null); }
public UserBO GetUserByEmail(UserBO User) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from Users in Context.Users where Users.EmailAddress == User.EmailAddress select Users; UserBO Result = new UserBO(); foreach (var user in UserQuery) { Result = Mapper.MapToUserBO(user); return(Result); } return(null); }
public void InsertFormdefaultSettings(string FormId, bool IsSqlProject, List <string> ControlsNameList) { try { //Delete old columns using (var Context = DataObjectFactory.CreateContext()) { Guid Id = new Guid(FormId); IQueryable <ResponseDisplaySetting> ColumnList = Context.ResponseDisplaySettings.Where(x => x.FormId == Id); foreach (var item in ColumnList) { Context.ResponseDisplaySettings.DeleteObject(item); } Context.SaveChanges(); } // Adding new columns List <string> ColumnNames = new List <string>(); if (!IsSqlProject) { ColumnNames = MetaDaTaColumnNames(); } else { ColumnNames = ControlsNameList; } int i = 1; foreach (string Column in ColumnNames) { using (var Context = DataObjectFactory.CreateContext()) { ResponseDisplaySetting SettingEntity = Mapper.Map(FormId, i, Column); Context.AddToResponseDisplaySettings(SettingEntity); Context.SaveChanges(); } i++; } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Inserts a new Organization. /// </summary> /// <remarks> /// Following insert, Organization object will contain the new identifier. /// </remarks> /// <param name="Organization">Organization.</param> public void InsertOrganization(OrganizationBO Organization) { try { using (var Context = DataObjectFactory.CreateContext()) { Organization OrganizationEntity = Mapper.ToEF(Organization); Context.AddToOrganizations(OrganizationEntity); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
//public UserAuthenticationResponseBO GetAuthenticationResponse(UserAuthenticationRequestBO UserAuthenticationRequestBO) //{ // UserAuthenticationResponseBO UserAuthenticationResponseBO = Mapper.ToAuthenticationResponseBO(UserAuthenticationRequestBO); // try // { // Guid Id = new Guid(UserAuthenticationRequestBO.ResponseId); // using (var Context = DataObjectFactory.CreateContext()) // { // Organization surveyResponse = Context.Organizations.First(x => x.ResponseId == Id); // if (surveyResponse != null) // { // UserAuthenticationResponseBO.PassCode = surveyResponse.ResponsePasscode; // } // } // } // catch (Exception ex) // { // throw (ex); // } // return UserAuthenticationResponseBO; //} /// <summary> /// Reads a Organization /// </summary> /// <param name="Organization">Organization.</param> public List <OrganizationBO> GetOrganizationInfoByUserId(int UserId, int UserRole) { List <OrganizationBO> result = new List <OrganizationBO>(); try { using (var Context = DataObjectFactory.CreateContext()) { if (UserRole == 3) { var Query = from OrganizationTable in Context.Organizations select OrganizationTable; var DataRow = Query.Distinct(); foreach (var Row in DataRow) { result.Add(Mapper.Map(Row)); } return(result); } else { var Query = from OrganizationTable in Context.Organizations from UserOrganizationTable in Context.UserOrganizations where UserOrganizationTable.OrganizationID == OrganizationTable.OrganizationId && UserOrganizationTable.UserID == UserId select OrganizationTable; var DataRow = Query; foreach (var Row in DataRow) { result.Add(Mapper.Map(Row)); } return(result); } } } catch (Exception ex) { throw (ex); } }
public UserBO GetUserByUserIdAndOrgId(UserBO User, OrganizationBO OrgBO) { var Context = DataObjectFactory.CreateContext(); var UserQuery = from Users in Context.Users where Users.UserID == User.UserId select Users; UserBO Result = new UserBO(); foreach (var user in UserQuery) { Result = Mapper.MapToUserBO(user); var _User = Context.UserOrganizations.Where(x => x.UserID == user.UserID && x.OrganizationID == OrgBO.OrganizationId).Single(); Result.IsActive = _User.Active; Result.Role = _User.RoleId; } return(Result); }
public bool InsertOrganization(OrganizationBO Organization, int UserId, int RoleId) { try { UserOrganization UserOrganizationEntity = Mapper.ToUserOrganizationEntity(Organization.IsEnabled, UserId, RoleId, Organization); using (var Context = DataObjectFactory.CreateContext()) { Context.AddToUserOrganizations(UserOrganizationEntity); Context.SaveChanges(); return(true); } } catch (Exception ex) { throw (ex); } }