public static EIDatasource Map(DbConnectionStringBO ConnectionString)
{
EIDatasource Datasource = new EIDatasource();
Datasource.DatabaseType = ConnectionString.DatabaseType;
Datasource.DatabaseUserID = ConnectionString.DatabaseUserID;
Datasource.DatasourceID = ConnectionString.DatasourceID;
Datasource.DatasourceServerName = ConnectionString.DatasourceServerName;
Datasource.InitialCatalog = ConnectionString.InitialCatalog;
Datasource.Password = ConnectionString.Password;
Datasource.SurveyId = ConnectionString.SurveyId;
Datasource.PersistSecurityInfo = ConnectionString.PersistSecurityInfo;
return(Datasource);
}
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 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);
}
}
private SurveyRequestResultBO Publish(SurveyInfoBO pRequestMessage)
{
SurveyRequestResultBO result = new SurveyRequestResultBO();
string _Xml = pRequestMessage.XML;
var SurveyId = Guid.NewGuid();
if (pRequestMessage != null)
{
//if (! string.IsNullOrEmpty(pRequestMessage.SurveyNumber) && ValidateOrganizationKey(pRequestMessage.OrganizationKey))
if (ValidateOrganizationKeyByUser(pRequestMessage.OrganizationKey, pRequestMessage.OwnerId)) //EW-96
{
if (ValidateSurveyFields(pRequestMessage))
{
try
{
if (pRequestMessage.IsSqlProject)
{
this.SurveyInfoDao.ValidateServername(pRequestMessage);
}
XDocument xdoc = XDocument.Parse(pRequestMessage.XML);
xdoc.Descendants().Where(e => e.Name == "SourceTable").Remove();
pRequestMessage.XML = xdoc.ToString();
var BO = ToBusinessObject(pRequestMessage, SurveyId);
this.SurveyInfoDao.InsertSurveyInfo(BO);
//Insert Connection string..
if (pRequestMessage.IsSqlProject)
{
DbConnectionStringBO DbConnectionStringBO = new DbConnectionStringBO();
DbConnectionStringBO = GetConnection(pRequestMessage.DBConnectionString);
DbConnectionStringBO.SurveyId = SurveyId;
this.SurveyInfoDao.InsertConnectionString(DbConnectionStringBO);
}
// Set Survey Settings
this.SurveyInfoDao.InsertFormdefaultSettings(SurveyId.ToString(), pRequestMessage.IsSqlProject, GetSurveyControls(BO));
Dictionary <int, string> SurveyIdsList = new Dictionary <int, string>();
SurveyIdsList.Add(GetViewId(pRequestMessage.XML), SurveyId.ToString());
result.ViewIdAndFormIdList = SurveyIdsList;
result.URL = GetURL(pRequestMessage, SurveyId);
result.IsPulished = true;
}
catch (Exception ex)
{
System.Console.Write(ex.ToString());
//Entities.ObjectStateManager.GetObjectStateEntry(SurveyMetaData).Delete();
result.URL = "";
result.IsPulished = false;
result.StatusText = "An Error has occurred while publishing your survey.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "One or more survey required fields are missing values.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "Organization Key is invalid.";
}
}
SetSourceTable(_Xml, SurveyId.ToString());
return(result);
}
private SurveyRequestResultBO Publish(SurveyInfoBO pRequestMessage)
{
string _Xml = pRequestMessage.XML;
SurveyRequestResultBO result = new SurveyRequestResultBO();
var SurveyId = Guid.NewGuid();
if (pRequestMessage != null)
{
//if (! string.IsNullOrEmpty(pRequestMessage.SurveyNumber) && ValidateOrganizationKey(pRequestMessage.OrganizationKey))
if (ValidateOrganizationKey(pRequestMessage.OrganizationKey))
{
if (ValidateSurveyFields(pRequestMessage))
{
try
{
Epi.Web.Common.BusinessObject.SurveyInfoBO BO = new Epi.Web.Common.BusinessObject.SurveyInfoBO();
//BO.SurveyId = SurveyId.ToString();
//BO.ClosingDate = pRequestMessage.ClosingDate;
//BO.IntroductionText = pRequestMessage.IntroductionText;
//BO.ExitText = pRequestMessage.ExitText;
//BO.DepartmentName = pRequestMessage.DepartmentName;
//BO.OrganizationName = pRequestMessage.OrganizationName;
//BO.SurveyNumber = pRequestMessage.SurveyNumber;
//XDocument xdoc = XDocument.Parse(pRequestMessage.XML);
//xdoc.Descendants().Where(e => e.Name == "SourceTable").Remove();
//BO.XML = xdoc.ToString();
//BO.SurveyName = pRequestMessage.SurveyName;
//BO.SurveyType = pRequestMessage.SurveyType;
//BO.UserPublishKey = pRequestMessage.UserPublishKey;
//BO.OrganizationKey = pRequestMessage.OrganizationKey;
//BO.OrganizationKey = pRequestMessage.OrganizationKey;
//BO.TemplateXMLSize = pRequestMessage.TemplateXMLSize;
//BO.IsDraftMode = pRequestMessage.IsDraftMode;
//BO.StartDate = pRequestMessage.StartDate;
BO = ToBusinessObject(pRequestMessage, SurveyId);
if (pRequestMessage.IsSqlProject)
{
this.SurveyInfoDao.ValidateServername(pRequestMessage);
}
BO.IsSqlProject = pRequestMessage.IsSqlProject;
this.SurveyInfoDao.InsertSurveyInfo(BO);
result.URL = GetURL(pRequestMessage, SurveyId);
result.IsPulished = true;
//Insert Connection string..
if (pRequestMessage.IsSqlProject)
{
DbConnectionStringBO DbConnectionStringBO = new DbConnectionStringBO();
DbConnectionStringBO = GetConnection(pRequestMessage.DBConnectionString);
DbConnectionStringBO.SurveyId = SurveyId;
this.SurveyInfoDao.InsertConnectionString(DbConnectionStringBO);
}
//Source Table
SetSourceTable(_Xml, SurveyId.ToString());
// View and ID setup
Dictionary <int, string> SurveyIdsList = new Dictionary <int, string>();
SurveyIdsList.Add(GetViewId(pRequestMessage.XML), SurveyId.ToString());
result.ViewIdAndFormIdList = SurveyIdsList;
}
catch (Exception ex)
{
System.Console.Write(ex.ToString());
//Entities.ObjectStateManager.GetObjectStateEntry(SurveyMetaData).Delete();
result.URL = "";
result.IsPulished = false;
result.StatusText = "An Error has occurred while publishing your survey.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "One or more survey required fields are missing values.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "Organization Key is invalid.";
}
}
return(result);
}
private SurveyRequestResultBO Publish(SurveyInfoBO pRequestMessage)
{
SurveyRequestResultBO result = new SurveyRequestResultBO();
var SurveyId = Guid.NewGuid();
if (pRequestMessage != null)
{
//if (! string.IsNullOrEmpty(pRequestMessage.SurveyNumber) && ValidateOrganizationKey(pRequestMessage.OrganizationKey))
if (ValidateOrganizationKeyByUser(pRequestMessage.OrganizationKey, pRequestMessage.OwnerId)) //EW-96
{
if (ValidateSurveyFields(pRequestMessage))
{
try
{
// if (pRequestMessage.IsSqlProject)
// this.SurveyInfoDao.ValidateServername(pRequestMessage);
var BO = ToBusinessObject(pRequestMessage, SurveyId);
this.SurveyInfoDao.InsertSurveyInfo(BO);
//Insert Connection string..
if (pRequestMessage.IsSqlProject)
{
DbConnectionStringBO DbConnectionStringBO = new DbConnectionStringBO();
DbConnectionStringBO = GetConnection(pRequestMessage.DBConnectionString);
DbConnectionStringBO.SurveyId = SurveyId;
this.SurveyInfoDao.InsertConnectionString(DbConnectionStringBO);
}
List <string> List = new List <string>();
// var list= ViewColumnNames.Where(x => x.Key == BO.ViewId);
//foreach (var item in list)
//{
// List.Add(item.Value.ToString());
//}
//// Set Survey Settings
//this.SurveyInfoDao.InsertFormdefaultSettings(SurveyId.ToString(), pRequestMessage.IsSqlProject, List);
Dictionary <int, string> SurveyIdsList = new Dictionary <int, string>();
//SurveyIdsList.Add(GetViewId(pRequestMessage.XML), SurveyId.ToString());
SurveyIdsList.Add(BO.ViewId, SurveyId.ToString());
result.ViewIdAndFormIdList = SurveyIdsList;
result.URL = GetURL(pRequestMessage, SurveyId);
result.IsPulished = true;
}
catch (Exception ex)
{
System.Console.Write(ex.ToString());
//Entities.ObjectStateManager.GetObjectStateEntry(SurveyMetaData).Delete();
result.URL = "";
result.IsPulished = false;
result.StatusText = "An Error has occurred while publishing your survey.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "One or more survey required fields are missing values.";
}
}
else
{
result.URL = "";
result.IsPulished = false;
result.StatusText = "Organization Key is invalid.";
}
}
return(result);
}
