/// <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 List <OrganizationBO> GetOrganizationInfoForAdmin(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 from UserOrganizationTable in Context.UserOrganizations where UserOrganizationTable.OrganizationID == OrganizationTable.OrganizationId && UserOrganizationTable.UserID == UserId && UserOrganizationTable.RoleId >= 2 && UserOrganizationTable.Active == true && OrganizationTable.IsEnabled == true 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 && UserOrganizationTable.RoleId == 2 && UserOrganizationTable.Active == true && OrganizationTable.IsEnabled == true select OrganizationTable; var DataRow = Query.Distinct(); foreach (var Row in DataRow) { result.Add(Mapper.Map(Row)); } return(result); } } } catch (Exception ex) { throw (ex); } }
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 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 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 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 List <UserBO> GetUserByFormId(string FormId) { Guid id = new Guid(FormId); List <UserBO> UserList = new List <UserBO>(); UserBO UserBO = new UserBO(); using (var Context = DataObjectFactory.CreateContext()) { SurveyMetaData SelectedUserQuery = Context.SurveyMetaDatas.First(x => x.SurveyId == id); IQueryable <User> Users = SelectedUserQuery.Users.AsQueryable(); foreach (User user in Users) { UserList.Add(Mapper.MapToUserBO(user)); } } return(UserList); }
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); } }
public List <SurveyInfoBO> GetChildInfoByParentId(string ParentFormId, int ViewId) { List <SurveyInfoBO> result = new List <SurveyInfoBO>(); try { Guid Id = new Guid(ParentFormId); using (var Context = DataObjectFactory.CreateContext()) { result.Add(Mapper.Map(Context.SurveyMetaDatas.FirstOrDefault(x => x.ParentId == Id && x.ViewId == ViewId))); } } catch (Exception ex) { throw (ex); } return(result); }
public SurveyInfoBO GetParentInfoByChildId(string ChildId) { SurveyInfoBO result = new SurveyInfoBO(); try { Guid Id = new Guid(ChildId); using (var Context = DataObjectFactory.CreateContext()) { result = Mapper.Map(Context.SurveyMetaDatas.FirstOrDefault(x => x.SurveyId == Id)); } } catch (Exception ex) { throw (ex); } return(result); }
public int GetUserHighestRole(int UserId) { int HighestRole = 0; try { using (var Context = DataObjectFactory.CreateContext()) { var Rows = Context.UserOrganizations.Where(x => x.UserID == UserId && x.Active == true && x.Organization.IsEnabled == true); HighestRole = Rows.Max(x => x.RoleId); } } catch (Exception ex) { throw (ex); } return(HighestRole); }
public List <UserBO> GetAdminsBySelectedOrgs(FormSettingBO FormSettingBO, string formId) { List <UserBO> AdminList = new List <UserBO>(); using (var Context = DataObjectFactory.CreateContext()) { foreach (var item in FormSettingBO.SelectedOrgList) { int OrgId = int.Parse(item.Value); var users = Context.UserOrganizations.Where(x => x.RoleId == 2 && x.OrganizationID == OrgId && x.Active == true); foreach (var user in users) { AdminList.Add(Mapper.MapToUserBO(user.User, user.RoleId)); } } } return(AdminList); }
public List <string> GetAllColumnNames(string FormId) { Guid Id = new Guid(FormId); try { using (var Context = DataObjectFactory.CreateContext()) { List <string> Columns = (from c in Context.SurveyMetaDataTransforms where c.SurveyId == Id && (c.FieldTypeId != 2 && c.FieldTypeId != 20 && c.FieldTypeId != 3 && c.FieldTypeId != 21 && c.FieldTypeId != 4 && c.FieldTypeId != 13) //filter non-data fields. orderby c.FieldName select c.FieldName).ToList(); return(Columns); } } catch (Exception ex) { throw (ex); } }
public List <SurveyInfoBO> GetFormsHierarchyIdsByRootId(string RootId) { List <SurveyInfoBO> result = new List <SurveyInfoBO>(); List <string> list = new List <string>(); try { Guid Id = new Guid(RootId); using (var Context = DataObjectFactory.CreateContext()) { IQueryable <SurveyMetaData> Query = Context.SurveyMetaDatas.Where(x => x.SurveyId == Id).Traverse(x => x.SurveyMetaData1).AsQueryable(); result = Mapper.Map(Query); } } catch (Exception ex) { throw (ex); } return(result); }
public bool HasDraftRecords(string FormId) { try { Guid Id = new Guid(FormId); bool _HasDraftRecords = false; using (var Context = DataObjectFactory.CreateContext()) { var DraftRecords = Context.SurveyResponses.Where(x => x.SurveyId == Id && x.IsDraftMode == true); if (DraftRecords.Count() > 0) { _HasDraftRecords = true; } } return(_HasDraftRecords); } catch (Exception ex) { throw (ex); } }
/// <summary> /// Updates a Organization. /// </summary> /// <param name="Organization">Organization.</param> public bool UpdateOrganization(OrganizationBO Organization) { ////Update Survey try { using (var Context = DataObjectFactory.CreateContext()) { var Query = from org in Context.Organizations where org.OrganizationKey == Organization.OrganizationKey select org; var SuperAdminChkQry = from usrorg in Context.UserOrganizations join org in Context.Organizations on usrorg.OrganizationID equals org.OrganizationId where org.OrganizationKey == Organization.OrganizationKey && usrorg.RoleId > 2 select usrorg; var DataRow = Query.Single(); var SuperAdminRow = SuperAdminChkQry.FirstOrDefault(); DataRow.Organization1 = Organization.Organization; if (SuperAdminRow != null && DataRow.IsEnabled != Organization.IsEnabled) { return(false); } DataRow.IsEnabled = Organization.IsEnabled; Context.SaveChanges(); return(true); } } catch (Exception ex) { throw (ex); } }
public FormInfoBO GetFormByFormId(string FormId) { FormInfoBO FormInfoBO = new FormInfoBO(); try { Guid Id = new Guid(FormId); using (var Context = DataObjectFactory.CreateContext()) { SurveyMetaData SurveyMetaData = Context.SurveyMetaDatas.Single(x => x.SurveyId == Id); FormInfoBO = Mapper.ToFormInfoBO(SurveyMetaData); } } catch (Exception ex) { throw (ex); } return(FormInfoBO); }
public void UpdateConnectionString(DbConnectionStringBO ConnectionString) { try { using (var Context = DataObjectFactory.CreateContext()) { var Query = from DataSource in Context.EIDatasources where DataSource.SurveyId == ConnectionString.SurveyId select DataSource; var DataRow = Query.Single(); DataRow = Mapper.Map(ConnectionString); Context.AddToEIDatasources(DataRow); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
public void DeleteDraftRecords(string FormId) { Guid NewId = new Guid(FormId); try { using (var Context = DataObjectFactory.CreateContext()) { List <string> Ids = new List <string>(); List <SurveyInfoBO> result = GetFormsHierarchyIdsByRootId(FormId); foreach (var item in result) { Ids.Add(item.SurveyId); } Ids.Reverse(); //Get Root foreach (var Id in Ids) { Guid _Id = new Guid(Id); Context.SurveyResponses.Where(x => x.SurveyId == _Id && x.IsDraftMode == true).ToList().ForEach(Context.SurveyResponses.DeleteObject); Context.SaveChanges(); } } } catch (Exception ex) { throw (ex); } }
public bool UpdateUserInfo(UserBO User, OrganizationBO OrgBO) { try { using (var Context = DataObjectFactory.CreateContext()) { User user = Context.Users.First(x => x.UserID == User.UserId); user.EmailAddress = User.EmailAddress; user.FirstName = User.FirstName; user.LastName = User.LastName; UserOrganization UserOrganization = Context.UserOrganizations.First(x => x.OrganizationID == OrgBO.OrganizationId && x.UserID == User.UserId); UserOrganization.RoleId = User.Role; UserOrganization.Active = User.IsActive; Context.SaveChanges(); } return(true); } catch (Exception ex) { throw (ex); } }
public List <UserBO> GetUserByOrgId(int OrgId) { List <UserBO> UserList = new List <UserBO>(); using (var Context = DataObjectFactory.CreateContext()) { var SelectedUserQuery = from UserOrg in Context.UserOrganizations join user in Context.Users on UserOrg.UserID equals user.UserID where UserOrg.OrganizationID == OrgId select user; foreach (var user in SelectedUserQuery) { var UserBO = Mapper.MapToUserBO(user); var User = Context.UserOrganizations.Where(x => x.UserID == user.UserID && x.OrganizationID == OrgId).Single(); UserBO.IsActive = User.Active; UserBO.Role = User.RoleId; UserList.Add(UserBO); } } return(UserList); }