/// <summary>
/// Saves the settings.
/// </summary>
/// <param name="pageId">The page id.</param>
/// <param name="header">The header.</param>
/// <param name="footer">The footer.</param>
/// <param name="msg">The MSG.</param>
public static void SaveSettings(int pageId, string header, string footer, string msg)
{
string conn = ConnectionManager();
form_setting settings;
LotusDataContext db = new LotusDataContext(conn);
if (db.form_settings.Where(s => s.page_id == pageId).Any())
{
settings = db.form_settings.Where(s => s.page_id == pageId).Single <form_setting>();
settings.header = header;
settings.footer = footer;
settings.thank_you_message = msg;
}
else
{
settings = new form_setting();
settings.page_id = pageId;
settings.header = header;
settings.footer = footer;
settings.thank_you_message = msg;
db.form_settings.InsertOnSubmit(settings);
}
db.SubmitChanges();
}
/// <summary>
/// Gets the control.
/// </summary>
/// <param name="control">The control.</param>
/// <returns>Returns custom user control</returns>
public Control GetControl(form_field_definition control)
{
string conn = Data.ConnectionManager();
int ctrlId = control.form_field_definition_id;
LotusDataContext db = new LotusDataContext(conn);
List <form_field_value> listOfValues = db.form_field_values.Where(v => v.form_field_definition_id == ctrlId).ToList <form_field_value>();
Control newControl = new Control();
string name = control.form_field_name;
string id = name.Replace(" ", "");
string type = control.input_type;
int sorting = control.sorting;
bool required = control.is_required;
string defaultValue = string.Empty;
int width = 200;
int height = 50;
if (control.default_value != null)
{
defaultValue = control.default_value;
}
if (control.width.HasValue)
{
width = control.width.Value;
}
if (control.height.HasValue)
{
height = control.height.Value;
}
Label nameLbl = new Label();
nameLbl.Text = name;
PlaceHolder ctrlHolder = new PlaceHolder();
RequiredFieldValidator validator = new RequiredFieldValidator();
RequiredFieldValidator validator1 = new RequiredFieldValidator();
if (type != "header" && type != "lblNoName" && type != "addressCtrl")
{
ctrlHolder.Controls.Add(new LiteralControl("<td align=\"left\">"));
ctrlHolder.Controls.Add(nameLbl);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(new LiteralControl(" : "));
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
}
switch (type)
{
case "label":
Label labelCtrl = new Label();
labelCtrl.ID = id;
labelCtrl.Width = width;
labelCtrl.Text = defaultValue;
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(labelCtrl);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
break;
case "txtBox":
TextBox txtBoxCtrl = new TextBox();
txtBoxCtrl.ID = id;
txtBoxCtrl.Text = defaultValue;
txtBoxCtrl.Width = width;
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(txtBoxCtrl);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
if (required)
{
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
validator.ControlToValidate = txtBoxCtrl.ID;
validator.ErrorMessage = "*";
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(validator);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
}
else
{
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
}
break;
case "txtArea":
TextBox txtArea = new TextBox();
txtArea.ID = id;
txtArea.Text = defaultValue;
txtArea.Width = width;
txtArea.Height = height;
txtArea.TextMode = TextBoxMode.MultiLine;
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(txtArea);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
if (required)
{
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
validator.ControlToValidate = txtArea.ID;
validator.ErrorMessage = "*";
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(validator);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
}
else
{
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
}
;
break;
case "ddList":
DropDownList ddList = new DropDownList();
ddList.ID = id;
ddList.Width = width;
foreach (form_field_value value in listOfValues)
{
ListItem item = new ListItem(value.display_value, value.display_value);
ddList.Items.Add(item);
if (value.is_default.Value)
{
ddList.SelectedValue = item.Value;
}
}
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(ddList);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "chkBox":
CheckBox box = new CheckBox();
box.ID = id;
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(box);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "chkBoxList":
CheckBoxList boxList = new CheckBoxList();
boxList.ID = id;
foreach (form_field_value value in listOfValues)
{
ListItem item = new ListItem(value.display_value, value.display_value);
boxList.Items.Add(item);
if (value.is_default.Value)
{
boxList.SelectedValue = item.Value;
}
}
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(boxList);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "radioBtnList":
RadioButtonList radioList = new RadioButtonList();
radioList.ID = id;
foreach (form_field_value value in listOfValues)
{
ListItem item = new ListItem(value.display_value, value.display_value);
radioList.Items.Add(item);
if (value.is_default.Value)
{
radioList.SelectedValue = item.Value;
}
}
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(radioList);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "datePicker":
//EclipseWebSolutions.DatePicker.DatePicker datePicker = new EclipseWebSolutions.DatePicker.DatePicker();
//datePicker.ID = id;
//datePicker.CalendarPosition = EclipseWebSolutions.DatePicker.DatePicker.CalendarDisplay.DisplayRight;
Panel datePicker = new Panel();
DropDownList days = new DropDownList();
days.ID = "days";
DropDownList months = new DropDownList();
months.ID = "months";
DropDownList years = new DropDownList();
years.ID = "years";
for (int i = 1; i <= 31; i++)
{
if (i < 10)
{
days.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString()));
}
else
{
days.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
for (int i = 1; i <= 12; i++)
{
if (i < 10)
{
months.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString()));
}
else
{
months.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
for (int i = 2008; i <= 2015; i++)
{
years.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
datePicker.Controls.Add(new LiteralControl("<table><tr>"));
datePicker.Controls.Add(new LiteralControl("<td>"));
datePicker.Controls.Add(days);
datePicker.Controls.Add(new LiteralControl("</td>"));
datePicker.Controls.Add(new LiteralControl("<td>"));
datePicker.Controls.Add(months);
datePicker.Controls.Add(new LiteralControl("</td>"));
datePicker.Controls.Add(new LiteralControl("<td>"));
datePicker.Controls.Add(years);
datePicker.Controls.Add(new LiteralControl("</td>"));
datePicker.Controls.Add(new LiteralControl("</tr></table>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(datePicker);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "timePicker":
DropDownList hour = new DropDownList();
hour.ID = "hours";
DropDownList minutes = new DropDownList();
minutes.ID = "minutes";
Panel timePicker = new Panel();
for (int i = 0; i < 60; i++)
{
if (i > 0 && i <= 24)
{
if (i < 10)
{
hour.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString()));
}
else
{
hour.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
if (i % 10 == 0)
{
if (i < 10)
{
minutes.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString()));
}
else
{
minutes.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
}
}
timePicker.Controls.Add(new LiteralControl("<table><tr>"));
timePicker.Controls.Add(new LiteralControl("<td>"));
timePicker.Controls.Add(hour);
timePicker.Controls.Add(new LiteralControl("</td>"));
timePicker.Controls.Add(new LiteralControl("<td>"));
timePicker.Controls.Add(new LiteralControl(":"));
timePicker.Controls.Add(new LiteralControl("</td>"));
timePicker.Controls.Add(new LiteralControl("<td>"));
timePicker.Controls.Add(minutes);
timePicker.Controls.Add(new LiteralControl("</td>"));
timePicker.Controls.Add(new LiteralControl("</tr></table>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(timePicker);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "addressCtrl":
Unit adressWidth = new Unit(150);
string xmlFileName = "";
if (listOfValues.Count != 0)
{
xmlFileName = listOfValues[0].display_value;
string path = HttpContext.Current.Server.MapPath("~/App_Data/") + xmlFileName;
city.ID = "city" + defaultValue;
region.ID = "region" + defaultValue;
city.Width = adressWidth;
region.Width = adressWidth;
region.Enabled = false;
city.DataSource = Data.GetXmlElements(path);
city.DataBind();
Label cityLabel = new Label();
Label regionLabel = new Label();
Label addressLabel = new Label();
cityLabel.Text = "City " + defaultValue;
regionLabel.Text = "Region " + defaultValue;
addressLabel.Text = "Address " + defaultValue;
TextBox addressTxtBox = new TextBox();
addressTxtBox.ID = "address1" + defaultValue;
addressTxtBox.TextMode = TextBoxMode.MultiLine;
addressTxtBox.Width = adressWidth;
Panel addressPanel = new Panel();
addressPanel.ID = id;
city.SelectedIndexChanged += new EventHandler(city_SelectedIndexChanged);
city.AutoPostBack = true;
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(new LiteralControl("<table>"));
ctrlHolder.Controls.Add(new LiteralControl("<tr>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(cityLabel);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(new LiteralControl(" : "));
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(city);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
validator1.ControlToValidate = city.ID;
validator1.InitialValue = "Please select city";
validator1.ErrorMessage = "*";
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(validator1);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("</tr>"));
ctrlHolder.Controls.Add(new LiteralControl("<tr>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(regionLabel);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(new LiteralControl(" : "));
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(region);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
ctrlHolder.Controls.Add(new LiteralControl("</tr>"));
ctrlHolder.Controls.Add(new LiteralControl("<tr>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(addressLabel);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(new LiteralControl(" : "));
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(addressTxtBox);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
validator.ControlToValidate = addressTxtBox.ID;
validator.ErrorMessage = "*";
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(validator);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
ctrlHolder.Controls.Add(new LiteralControl("</tr>"));
ctrlHolder.Controls.Add(new LiteralControl("</table>"));
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
}
else
{
Label errorLabel = new Label();
errorLabel.Text = "Please enter XML source file!";
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(errorLabel);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
}
break;
case "header":
Label headerCtrl = new Label();
headerCtrl.ID = id;
headerCtrl.Text = defaultValue;
headerCtrl.Font.Bold = true;
ctrlHolder.Controls.Add(new LiteralControl("<td colspan=\"3\">"));
ctrlHolder.Controls.Add(headerCtrl);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
case "lblNoName":
Label infoCtrl = new Label();
infoCtrl.ID = id;
infoCtrl.Text = defaultValue;
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td></td>"));
ctrlHolder.Controls.Add(new LiteralControl("<td>"));
ctrlHolder.Controls.Add(infoCtrl);
ctrlHolder.Controls.Add(new LiteralControl("</td>"));
break;
}
newControl = ctrlHolder;
return(newControl);
}
