public List <AdminBO> GetAdminInfoByOrgKey(string gOrgKeyEncrypted) { List <AdminBO> AdminList = new List <AdminBO>(); int OrgId = 0; int AdminOrgId = 0; try { using (var Context = DataObjectFactory.CreateContext()) { var OrgQuery = (from response in Context.Organizations where response.OrganizationKey == gOrgKeyEncrypted select new { response.OrganizationId }).First(); OrgId = OrgQuery.OrganizationId; var AdminOrgQuery = (from response in Context.Organizations where response.IsHostOrganization == true select new { response.OrganizationId }).First(); AdminOrgId = AdminOrgQuery.OrganizationId; var AdminQuery = (from response in Context.Admins where response.OrganizationId == OrgId && response.IsActive == true && response.Notify == true select new { response }); var AdminQuery1 = (from response in Context.Admins where response.OrganizationId == AdminOrgId && response.IsActive == true && response.Notify == true select new { response }); foreach (var row in AdminQuery) { AdminBO AdminBO = new AdminBO(); AdminBO.AdminEmail = row.response.AdminEmail; AdminBO.IsActive = row.response.IsActive; AdminList.Add(AdminBO); } foreach (var row in AdminQuery1) { AdminBO AdminBO = new AdminBO(); AdminBO.AdminEmail = row.response.AdminEmail; AdminBO.IsActive = row.response.IsActive; AdminList.Add(AdminBO); } } } catch (Exception ex) { throw (ex); } return(AdminList); }
/// <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 void InsertAdmin(AdminBO Admin) { try { using (var Context = DataObjectFactory.CreateContext()) { Admin AdminEntity = Mapper.ToEF(Admin); Context.AddToAdmins(AdminEntity); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } // Get Admin Id try { using (var Context = DataObjectFactory.CreateContext()) { var Query = (from _Admin in Context.Admins where _Admin.AdminEmail == Admin.AdminEmail && _Admin.FirstName == Admin.FirstName && Admin.LastName == _Admin.LastName select new { _Admin.AdminId }).Distinct(); var DataRow = Query.Distinct(); foreach (var Row in DataRow) { Admin.AdminId = Row.AdminId; break; } } } catch (Exception ex) { throw (ex); } // Insert Address using (var Context = DataObjectFactory.CreateContext()) { Address AddressEntity = Mapper.ToAddressEF(Admin); Context.AddToAddresses(AddressEntity); Context.SaveChanges(); } }
public void ValidateServername(SurveyInfoBO pRequestMessage) { var Context = DataObjectFactory.CreateContext(); string eweAdostring = Context.Connection.ConnectionString.Substring(Context.Connection.ConnectionString.ToLower().IndexOf("data source="), Context.Connection.ConnectionString.Substring(Context.Connection.ConnectionString.ToLower().IndexOf("data source=")).IndexOf(";")); string epiDBstring = pRequestMessage.DBConnectionString.Substring(0, pRequestMessage.DBConnectionString.IndexOf(";")); if (eweAdostring.ToLower() != epiDBstring.ToLower()) { pRequestMessage.IsSqlProject = false; } }
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); }
/// <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 <SurveyInfoBO> GetAllSurveysByOrgKey(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); } try { using (var Context = DataObjectFactory.CreateContext()) { responseList = Context.SurveyMetaDatas.Where(x => x.OrganizationId == OrganizationId).ToList(); if (responseList.Count() > 0 && responseList[0] != null) { result = Mapper.Map(responseList); } } } catch (Exception ex) { throw (ex); } return(result); }
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(); Context.AddToEIDatasources(Mapper.Map(ConnectionString)); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Gets a specific SurveyResponse. /// </summary> /// <param name="SurveyResponseId">Unique SurveyResponse identifier.</param> /// <returns>SurveyResponse.</returns> public List <SurveyResponseBO> GetSurveyResponse(List <string> SurveyResponseIdList, Guid UserPublishKey, int PageNumber = -1, int PageSize = -1) { List <SurveyResponseBO> result = new List <SurveyResponseBO>(); if (SurveyResponseIdList.Count > 0) { foreach (string surveyResponseId in SurveyResponseIdList.Distinct()) { Guid Id = new Guid(surveyResponseId); using (var Context = DataObjectFactory.CreateContext()) { result.Add(Mapper.Map(Context.SurveyResponses.FirstOrDefault(x => x.ResponseId == Id))); } } } else { using (var Context = DataObjectFactory.CreateContext()) { result = Mapper.Map(Context.SurveyResponses.ToList()); } } 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 void InsertAdminInfo(AdminBO Admin) { try { using (var Context = DataObjectFactory.CreateContext()) { Admin AdminEntity = Mapper.ToEF(Admin); Context.AddToAdmins(AdminEntity); Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Updates a Organization. /// </summary> /// <param name="Organization">Organization.</param> public void UpdateOrganization(OrganizationBO Organization) { ////Update Survey try{ using (var Context = DataObjectFactory.CreateContext()) { var Query = from response in Context.Organizations where response.OrganizationKey == Organization.OrganizationKey select response; var DataRow = Query.Single(); DataRow.Organization1 = Organization.Organization; DataRow.IsEnabled = Organization.IsEnabled; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <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.SurveyName = SurveyInfo.SurveyName; DataRow.SurveyNumber = SurveyInfo.SurveyNumber; DataRow.TemplateXML = SurveyInfo.XML; DataRow.IntroductionText = SurveyInfo.IntroductionText; DataRow.ExitText = SurveyInfo.ExitText; DataRow.OrganizationName = SurveyInfo.OrganizationName; DataRow.DepartmentName = SurveyInfo.DepartmentName; DataRow.ClosingDate = SurveyInfo.ClosingDate; DataRow.SurveyTypeId = SurveyInfo.SurveyType; DataRow.UserPublishKey = SurveyInfo.UserPublishKey; DataRow.TemplateXMLSize = RemoveWhitespace(SurveyInfo.XML).Length; DataRow.IsDraftMode = SurveyInfo.IsDraftMode; DataRow.StartDate = SurveyInfo.StartDate; DataRow.LastUpdate = DateTime.Now; DataRow.IsSQLProject = SurveyInfo.IsSqlProject; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
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.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Inserts a new ErrorLog. /// </summary> /// <remarks> /// </remarks> /// <param name="pValue">ErrorText.</param> public void InsertErrorLog(Dictionary <string, string> pValue) { try { using (var Context = DataObjectFactory.CreateContext()) { ErrorLog ErrorLogEntity = new ErrorLog(); ErrorLogEntity.ErrorDate = DateTime.Now; ErrorLogEntity.Comment = "SurveyAPI Error"; StringBuilder ErrText = new StringBuilder(); foreach (KeyValuePair <string, string> kvp in pValue) { if (kvp.Key == "SurveyId") { ErrorLogEntity.SurveyId = new Guid(kvp.Value.ToString()); } else if (kvp.Key == "ResponseId") { ErrorLogEntity.ResponseId = new Guid(kvp.Value.ToString()); } else { ErrText.Append(" " + kvp.Key + " " + kvp.Value + ". "); } } ErrorLogEntity.ErrorText = ErrText.ToString(); Context.AddToErrorLogs(ErrorLogEntity); 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); }
/// <summary> /// Inserts a new SurveyResponse. /// </summary> /// <remarks> /// Following insert, SurveyResponse object will contain the new identifier. /// </remarks> /// <param name="SurveyResponse">SurveyResponse.</param> public void InsertSurveyResponse(SurveyResponseBO SurveyResponse) { try { using (var Context = DataObjectFactory.CreateContext()) { SurveyResponse SurveyResponseEntity = Mapper.ToEF(SurveyResponse); try { // SurveyResponseEntity.RecordSourceId = Context.lk_RecordSource.Where(u => u.RecordSource == "EIWS").Select(u => u.RecordSourceId).SingleOrDefault(); } catch (Exception) { } Context.AddToSurveyResponses(SurveyResponseEntity); 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()) { SurveyResponse surveyResponse = Context.SurveyResponses.First(x => x.ResponseId == Id); if (surveyResponse != null) { UserAuthenticationResponseBO.PassCode = surveyResponse.ResponsePasscode; } } } catch (Exception ex) { throw (ex); } return(UserAuthenticationResponseBO); }
public void UpdatePassCode(UserAuthenticationRequestBO passcodeBO) { try { Guid Id = new Guid(passcodeBO.ResponseId); //Update Survey using (var Context = DataObjectFactory.CreateContext()) { var Query = from response in Context.SurveyResponses where response.ResponseId == Id select response; var DataRow = Query.Single(); DataRow.ResponsePasscode = passcodeBO.PassCode; Context.SaveChanges(); } } catch (Exception ex) { throw (ex); } }
/// <summary> /// Gets SurveyResponses depending on criteria. /// </summary> /// <param name="SurveyResponseId">Unique SurveyResponse identifier.</param> /// <returns>SurveyResponse.</returns> public List <SurveyResponseBO> GetSurveyResponse(List <string> SurveyAnswerIdList, string pSurveyId, DateTime pDateCompleted, bool pIsDraftMode = false, int pStatusId = -1, int PageNumber = -1, int PageSize = -1) { List <SurveyResponseBO> Finalresult = new List <SurveyResponseBO>(); IEnumerable <SurveyResponseBO> result; List <SurveyResponse> responseList = new List <SurveyResponse>(); if (SurveyAnswerIdList.Count > 0) { foreach (string surveyResponseId in SurveyAnswerIdList.Distinct()) { try { Guid Id = new Guid(surveyResponseId); using (var Context = DataObjectFactory.CreateContext()) { SurveyResponse surveyResponse = Context.SurveyResponses.First(x => x.ResponseId == Id); if (surveyResponse != null) { responseList.Add(surveyResponse); } } } catch (Exception ex) { throw (ex); } } } else { try{ using (var Context = DataObjectFactory.CreateContext()) { if (!string.IsNullOrEmpty(pSurveyId)) { Guid Id = new Guid(pSurveyId); // responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id).ToList(); //if (pStatusId>0) //{ //responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id && x.StatusId == pStatusId && x.IsDraftMode == pIsDraftMode).OrderBy(x=>x.DateCompleted).ToList(); //} //else{ // pStatusId = -1; // responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id && x.StatusId != 4 && x.IsDraftMode == pIsDraftMode).OrderBy(x => x.DateCompleted).ToList(); //} // New client Epi info version 7.2 if (pStatusId == 0) // All 2,3,and 4 if available { responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id && x.IsDraftMode == pIsDraftMode).OrderBy(x => x.DateCompleted).ToList(); } if (pStatusId == 3) // Only 3 { responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id && x.StatusId == pStatusId && x.IsDraftMode == pIsDraftMode).OrderBy(x => x.DateCompleted).ToList(); } if (pStatusId == 4) // 3 and 4 { responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id && (x.StatusId == pStatusId || x.StatusId == 3) && x.IsDraftMode == pIsDraftMode).OrderBy(x => x.DateCompleted).ToList(); } // Old client Epi info version 7.1.5.2 if (pStatusId == -1) // All 2,3,and 4 if available { responseList = Context.SurveyResponses.Where(x => x.SurveyId == Id).OrderBy(x => x.DateCompleted).ToList(); } } } } catch (Exception ex) { throw (ex); } } //if(! string.IsNullOrEmpty(pSurveyId)) //{ // Guid Id = new Guid(pSurveyId); // List<SurveyResponse> surveyList = new List<SurveyResponse>(); // surveyList.AddRange(responseList.Where(x => x.SurveyId == Id)); // responseList = surveyList; //} //if (pStatusId > -1) //{ // List<SurveyResponse> statusList = new List<SurveyResponse>(); // statusList.AddRange(responseList.Where(x => x.StatusId == pStatusId)); // responseList = statusList; //} if (pDateCompleted > DateTime.MinValue) { List <SurveyResponse> dateList = new List <SurveyResponse>(); //dateList.AddRange(responseList.Where(x => x.DateCompleted.Value.Month == pDateCompleted.Month && x.DateCompleted.Value.Year == pDateCompleted.Year && x.DateCompleted.Value.Day == pDateCompleted.Day)); dateList.AddRange(responseList.Where(x => x.DateCompleted != null && x.DateCompleted.Value.Month == pDateCompleted.Month && x.DateCompleted.Value.Year == pDateCompleted.Year && x.DateCompleted.Value.Day == pDateCompleted.Day)); responseList = dateList; } //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); // } //} if (PageSize != -1 && PageNumber != -1) { result = Mapper.Map(responseList); result = result.Skip((PageNumber - 1) * PageSize).Take(PageSize); foreach (var item in result) { Finalresult.Add(item); } return(Finalresult); } else { Finalresult = Mapper.Map(responseList); return(Finalresult); } }
/// <summary> /// Gets SurveyInfo based on criteria /// </summary> /// <param name="SurveyInfoId">Unique SurveyInfo identifier.</param> /// <returns>SurveyInfo.</returns> public List <SurveyInfoBO> GetSurveyInfo(List <string> SurveyInfoIdList, DateTime pClosingDate, string pOrganizationKey, int pSurveyType = -1, int PageNumber = -1, int PageSize = -1) { List <SurveyInfoBO> result = new List <SurveyInfoBO>(); List <SurveyMetaData> responseList = new List <SurveyMetaData>(); int OrganizationId = 0; try { using (var Context = DataObjectFactory.CreateContext()) { OrganizationId = Context.Organizations.FirstOrDefault(x => x.OrganizationKey == pOrganizationKey).OrganizationId; } } catch (Exception ex) { throw (ex); } if (SurveyInfoIdList.Count > 0) { foreach (string surveyInfoId in SurveyInfoIdList.Distinct()) { Guid Id = new Guid(surveyInfoId); try{ using (var Context = DataObjectFactory.CreateContext()) { responseList.Add(Context.SurveyMetaDatas.FirstOrDefault(x => x.SurveyId == Id && x.OrganizationId == OrganizationId)); } } catch (Exception ex) { throw (ex); } } } else { using (var Context = DataObjectFactory.CreateContext()) { responseList = Context.SurveyMetaDatas.ToList(); } } if (responseList.Count > 0 && responseList[0] != null) { if (pSurveyType > -1) { List <SurveyMetaData> statusList = new List <SurveyMetaData>(); statusList.AddRange(responseList.Where(x => x.SurveyTypeId == pSurveyType)); responseList = statusList; } if (OrganizationId > 0) { List <SurveyMetaData> OIdList = new List <SurveyMetaData>(); OIdList.AddRange(responseList.Where(x => x.OrganizationId == OrganizationId)); responseList = OIdList; } if (pClosingDate != null) { if (pClosingDate > DateTime.MinValue) { List <SurveyMetaData> dateList = new List <SurveyMetaData>(); dateList.AddRange(responseList.Where(x => x.ClosingDate.Month >= pClosingDate.Month && x.ClosingDate.Year >= pClosingDate.Year && x.ClosingDate.Day >= pClosingDate.Day)); responseList = dateList; } } result = Mapper.Map(responseList); // remove the items to skip // remove the items after the page size if (PageNumber > 0 && PageSize > 0) { result.Sort(CompareByDateCreated); if (PageNumber * PageSize - PageSize > 0) { result.RemoveRange(0, PageSize); } if (PageNumber * PageSize < result.Count) { result.RemoveRange(PageNumber * PageSize, result.Count - PageNumber * PageSize); } } } return(result); }