public SurveyLayoutData SurveyLayoutGet(int surveyId,string languageCode=null)
{
SurveyLayoutData sld = new SurveyLayoutData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@SurveyId", surveyId).SqlValue);
commandParameters.Add(new SqlParameter("@LanguageCode", languageCode).SqlValue);
}
DbConnection.db.LoadDataSet( "vts_spSurveylayoutGet", sld, new string[] { "SurveyLayout" }, commandParameters.ToArray());
return sld;
}
protected void OnSave(object sender, CommandEventArgs e)
{
SQLServerDAL.SurveyLayout sl = new SQLServerDAL.SurveyLayout();
SurveyLayoutData sld = new SurveyLayoutData();
SurveyLayoutData.SurveyLayoutRow slr = sld.SurveyLayout.NewSurveyLayoutRow();
slr.SurveyId = ((PageBase)Page).SurveyId;;
slr.SurveyCss = ddlTemplate.SelectedIndex > 0 ? ddlTemplate.SelectedItem.Text : "";
slr.SurveyHeaderText = txtPageHeader.Text;
slr.SurveyFooterText = txtPageFooter.Text;
sld.SurveyLayout.AddSurveyLayoutRow(slr);
sl.SurveyLayoutUpdate(sld, LanguagesDropdownlist.SelectedValue);
}
public void SurveyLayoutUpdate(SurveyLayoutData sld, string languageCode = null)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand command = new SqlCommand("vts_spSurveyLayoutUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SurveyID",sld.SurveyLayout[0].SurveyId));
command.Parameters.Add(new SqlParameter("@SurveyHeaderText", sld.SurveyLayout[0].SurveyHeaderText));
command.Parameters.Add(new SqlParameter("@SurveyFooterText", sld.SurveyLayout[0].SurveyFooterText));
command.Parameters.Add(new SqlParameter("@SurveyCss", sld.SurveyLayout[0].SurveyCss));
command.Parameters.Add(new SqlParameter("@LanguageCode", languageCode));
// insertCommand.Parameters.Add(new SqlParameter("@SurveyId", SqlDbType.Int, 0xff, "RoleName"));
DbConnection.db.UpdateDataSet(sld, "SurveyLayout", command, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
// SqlHelper.ExecuteNonQuery(SqlHelper.DbConnectionString, CommandType.StoredProcedure, "vts_spRoleSecurityRightAddNew", commandParameters);
}
public void SurveyLayoutUpdate(SurveyLayoutData sld, string languageCode = null)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand command = new SqlCommand("vts_spSurveyLayoutUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SurveyID", sld.SurveyLayout[0].SurveyId));
command.Parameters.Add(new SqlParameter("@SurveyHeaderText", sld.SurveyLayout[0].SurveyHeaderText));
command.Parameters.Add(new SqlParameter("@SurveyFooterText", sld.SurveyLayout[0].SurveyFooterText));
command.Parameters.Add(new SqlParameter("@SurveyCss", sld.SurveyLayout[0].SurveyCss));
command.Parameters.Add(new SqlParameter("@LanguageCode", languageCode));
// insertCommand.Parameters.Add(new SqlParameter("@SurveyId", SqlDbType.Int, 0xff, "RoleName"));
DbConnection.db.UpdateDataSet(sld, "SurveyLayout", command, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
// SqlHelper.ExecuteNonQuery(SqlHelper.DbConnectionString, CommandType.StoredProcedure, "vts_spRoleSecurityRightAddNew", commandParameters);
}
protected void Page_Init(object sender, EventArgs e)
{
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(((PageBase)Page).SurveyId);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css2 = new HtmlGenericControl("link");
css2.Attributes.Add("rel", "stylesheet");
css2.Attributes.Add("type", "text/css");
css2.Attributes.Add("href", ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss));
Page.Header.Controls.Add(css2);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/surveypreview.css"));
Page.Header.Controls.Add(css);
}
//this.SurveyHeaderCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyHeaderText);
//this.SurveyFooterCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyFooterText);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/surveypreview.css"));
Page.Header.Controls.Add(css);
}
}
private void BindFields()
{
SQLServerDAL.SurveyLayout sl = new SQLServerDAL.SurveyLayout();
SurveyLayoutData ud = sl.SurveyLayoutGet(((PageBase)Page).SurveyId, LanguagesDropdownlist.SelectedValue);
string[] names = Directory.GetFiles(Constants.Constants.GetFilePathCSS(SurveyId));
int i;
for (i = 0; i < names.Length; i++)
{
names[i] = Path.GetFileName(names[i]);
}
ddlTemplate.Items.Clear();
ddlTemplate.Items.Add(new ListItem(GetPageResource("DdlNoSelect"), "-1"));
ddlTemplate.DataSource = names;
ddlTemplate.DataBind();
bool cssSelected = false;
if (ud.SurveyLayout.Count > 0)
{
foreach (ListItem item in ddlTemplate.Items)
{
if (item.Text == ud.SurveyLayout[0].SurveyCss)
{
item.Selected = true;
cssSelected = true;
break;
}
}
if (!cssSelected)
{
ddlTemplate.SelectedIndex = 0;
}
txtPageFooter.Text = ud.SurveyLayout[0].SurveyFooterText;
txtPageHeader.Text = ud.SurveyLayout[0].SurveyHeaderText;
}
}
protected void Page_Init(object sender, EventArgs e)
{
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(((PageBase)Page).SurveyId);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css2 = new HtmlGenericControl("link");
css2.Attributes.Add("rel", "stylesheet");
css2.Attributes.Add("type", "text/css");
css2.Attributes.Add("href", ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss));
Page.Header.Controls.Add(css2);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/surveypreview.css"));
Page.Header.Controls.Add(css);
}
//this.SurveyHeaderCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyHeaderText);
//this.SurveyFooterCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyFooterText);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/surveypreview.css"));
Page.Header.Controls.Add(css);
}
}
private void InitiateSurvey(int surveyId = -1)
{
if (surveyId > -1 || (ddlSurveys.Visible == true && ddlSurveys.SelectedValue != "-1"))
{
SurveyControl.SurveyId = surveyId > -1 ? surveyId : int.Parse(ddlSurveys.SelectedValue);
}
else
{
return;
}
ddlSurveys.Visible = false;
ChooseSurveyLabel.Visible = false;
// custom CSS:
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(SurveyControl.SurveyId);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
//defaultCSS.InnerHtml = "@import url(\"desktopmodules/surveybox/Css/" + SurveyControl.SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss + "\")";
string cssurl = ResolveUrl("Css/" + SurveyControl.SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss);
defaultCSS.InnerHtml = "@import url(\"" + cssurl + "\");";
}
}
else
{
string alt2css = ResolveUrl("Css/surveymobile.css");
defaultCSS.InnerHtml = "@import url(\"" + alt2css + "\");";
}
SurveyControl.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LocalizePage();
if (!IsPostBack)
{
//on initial pageload get SurveyId from DNN module settings; if null int 0 is returned;
SurveyControl.SurveyId = SurveyID();
ModuleSecurity ms = new ModuleSecurity(this.ModuleConfiguration);
if (ms.HasPermission2 && UserID() != 0)
{
ShowSurveyDDL();
SurveyControl.Visible = false;
}
else
{
if (SurveyID() >= 1)
{
SurveyControl.Visible = true;
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(SurveyControl.SurveyId);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
string cssurl = ResolveUrl("Css/" + SurveyControl.SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss);
defaultCSS.InnerHtml = "@import url(\"" + cssurl + "\");";
}
}
else
{
string alt2css = ResolveUrl("Css/surveymobile.css");
defaultCSS.InnerHtml = "@import url(\"" + alt2css + "\");";
}
}
else
{ //test:
SurveyControl.SurveyId = 0;
SurveyControl.Visible = false;
}
}
}
//Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
////_userSettings = u.SurveyLayoutGet(((PageBase)Page).getSurveyId());
////test set surveyid to 1
//_userSettings = u.SurveyLayoutGet(SurveyControl.SurveyId);
//if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
//{
// if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
// {
// defaultCSS.InnerHtml = "@import url(\"desktopmodules/surveybox/Css/" + SurveyControl.SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss + "\")";
// }
//}
//Used if surveyid is taken from DNN module settings
// should depend on module permissions
//SurveyControl.SurveyId = SurveyID();
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException("ErrorDetails:" + exc.StackTrace + "& Inner:" + exc.GetBaseException(), this, exc, true);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
SetupSecurity();
LocalizePage();
if (!IsPostBack)
{
ShowSurveyDDL();
}
UITabList.SetTakeSurveyTabs((MsterPageTabs)Page.Master, UITabList.TakeSurveyTabs.TakeSurvey);
//if(!SurveyStarted) InitiateSurvey();
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(((PageBase)Page).getSurveyId());
string href = ResolveUrl("~/NSurveyAdmin/CSS/surveypreview.css");
//string href= VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/nsurveyform.css" );
//Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
//HtmlGenericControl css = new HtmlGenericControl("link");
//css.Attributes.Add("rel", "stylesheet");
//css.Attributes.Add("type", "text/css");
//css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/nsurveyform.css"));
//Page.Header.Controls.Add(css);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
// href=ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss);
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css2 = new HtmlGenericControl("link");
css2.Attributes.Add("rel", "stylesheet");
css2.Attributes.Add("type", "text/css");
css2.Attributes.Add("href", ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss));
Page.Header.Controls.Add(css2);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", href);
Page.Header.Controls.Add(css);
}
// this.SurveyHeaderCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyHeaderText);
// this.SurveyFooterCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyFooterText);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", href);
Page.Header.Controls.Add(css);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
SetupSecurity();
LocalizePage();
if (!IsPostBack)
{
ShowSurveyDDL();
}
UITabList.SetTakeSurveyTabs((MsterPageTabs)Page.Master, UITabList.TakeSurveyTabs.TakeSurvey);
//if(!SurveyStarted) InitiateSurvey();
Votations.NSurvey.SQLServerDAL.SurveyLayout u = new Votations.NSurvey.SQLServerDAL.SurveyLayout();
_userSettings = u.SurveyLayoutGet(((PageBase)Page).getSurveyId());
string href = ResolveUrl("~/NSurveyAdmin/CSS/surveypreview.css");
//string href= VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/nsurveyform.css" );
//Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
//HtmlGenericControl css = new HtmlGenericControl("link");
//css.Attributes.Add("rel", "stylesheet");
//css.Attributes.Add("type", "text/css");
//css.Attributes.Add("href", VirtualPathUtility.ToAbsolute("~/NSurveyAdmin/CSS/nsurveyform.css"));
//Page.Header.Controls.Add(css);
if (!(_userSettings == null || _userSettings.SurveyLayout.Count == 0))
{
if (!string.IsNullOrEmpty(_userSettings.SurveyLayout[0].SurveyCss))
{
// href=ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss);
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css2 = new HtmlGenericControl("link");
css2.Attributes.Add("rel", "stylesheet");
css2.Attributes.Add("type", "text/css");
css2.Attributes.Add("href", ResolveUrl(UserSettingsConstants.CssStoragePath + "/" + SurveyId.ToString() + "/" + _userSettings.SurveyLayout[0].SurveyCss));
Page.Header.Controls.Add(css2);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", href);
Page.Header.Controls.Add(css);
}
// this.SurveyHeaderCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyHeaderText);
// this.SurveyFooterCustom.Text = HttpUtility.HtmlDecode(_userSettings.SurveyLayout[0].SurveyFooterText);
}
else
{
Page.Header.Controls.Add(new LiteralControl(Environment.NewLine));
HtmlGenericControl css = new HtmlGenericControl("link");
css.Attributes.Add("rel", "stylesheet");
css.Attributes.Add("type", "text/css");
css.Attributes.Add("href", href);
Page.Header.Controls.Add(css);
}
}
protected void OnSave(object sender, CommandEventArgs e)
{
SQLServerDAL.SurveyLayout sl = new SQLServerDAL.SurveyLayout();
SurveyLayoutData sld = new SurveyLayoutData();
SurveyLayoutData.SurveyLayoutRow slr = sld.SurveyLayout.NewSurveyLayoutRow();
slr.SurveyId = ((PageBase)Page).SurveyId; ;
slr.SurveyCss = ddlTemplate.SelectedIndex > 0 ? ddlTemplate.SelectedItem.Text : "";
slr.SurveyHeaderText = txtPageHeader.Text;
slr.SurveyFooterText = txtPageFooter.Text;
sld.SurveyLayout.AddSurveyLayoutRow(slr);
sl.SurveyLayoutUpdate(sld,LanguagesDropdownlist.SelectedValue);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
SurveyLayoutData ds = new SurveyLayoutData();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "SurveyLayoutDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
