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