public void ValidateDatesTest(string startDateText, string endDateText, bool datesRequired, bool expectedResult)
{
//Arrange
var textBoxStartDate = new TextBox()
{
Text = startDateText
};
var textBoxEndDate = new TextBox()
{
Text = endDateText
};
const int archiveYears = 5;
var phError = new PlaceHolder();
var lblErrorMessage = new Label();
try
{
InitializeFakes();
//Act
var result = _dateValidator.ValidateDates(textBoxStartDate, textBoxEndDate, archiveYears, phError, lblErrorMessage, datesRequired);
//Assert
result.ShouldBe(expectedResult);
}
finally
{
if (textBoxStartDate != null)
{
textBoxStartDate.Dispose();
}
if (textBoxEndDate != null)
{
textBoxEndDate.Dispose();
}
if (phError != null)
{
phError.Dispose();
}
if (lblErrorMessage != null)
{
lblErrorMessage.Dispose();
}
}
}
public void TearDown()
{
_labelMessage?.Dispose();
_mpeMessage?.Dispose();
_rptSideBar?.Dispose();
_rptSpam?.Dispose();
_rptPotentialProblems?.Dispose();
_rptCodeHtmlValidation?.Dispose();
_rptLinkCheck?.Dispose();
_labelCodeAnalysisResult?.Dispose();
_labelLinkCheckResult?.Dispose();
_litHtml?.Dispose();
_plHtmlValidation?.Dispose();
_plPotentialProblems?.Dispose();
_imageMap1?.Dispose();
_labelPublicURL?.Dispose();
_shimContext.Dispose();
}
public void TearDown()
{
_lblErrorMessage.Dispose();
_phError.Dispose();
_shimContext.Dispose();
}
private void RenderNode(PlaceHolder placeHolder, SiteMapNode node, int level)
{
//<section>
// <h3><a href="#" class="nav-current">Current section (4) example </a></h3>
// <ul>
// <li><a href="#">Item 4a</a></li>
// <li><a href="#" class="nav-current">Current item (4b) example</a>
// <ul>
// <li><a href="#">Item 4bi</a></li>
// <li><a href="#" class="nav-current">Current sub (4bii) item example</a></li>
// <li><a href="#">Item 4biii</a></li>
// </ul>
// </li>
// <li><a href="#">Item 4c</a></li>
// </ul>
//</section>
if (!ShowNode(node, level))
{
return;
}
string cssClass = GetCssClass(node, level);
String cssClassHtml = String.Empty;
if (!String.IsNullOrEmpty(cssClass))
{
cssClassHtml = String.Format(" class=\"{0}\"", cssClass);
}
// figure out the wrapper that you want to put around the Node depending on the level
// handle the section headers
if (level == 0)
{
// add the "<section><h3>"
placeHolder.Controls.Add(new LiteralControl(SectionOpenHTML + SectionHeaderOpenHtml));
}
else
{
// render a "<LI>" for the item
placeHolder.Controls.Add(new LiteralControl(String.Format(ListItemOpenHtml, cssClassHtml)));
}
// Render the link for the item or title
RenderNodeItem(placeHolder, node, cssClass);
// render any closing elements for the level
if (level == 0)
{
placeHolder.Controls.Add(new LiteralControl(SectionHeaderCloseHtml));
}
// render any expandable child items
if (IsNodeExpandable(node, level))
{
SiteMapNodeCollection nodes = _provider.GetChildNodes(node);
PlaceHolder childrenPlaceHolder = new PlaceHolder();
foreach (SiteMapNode childrenNode in nodes)
{
RenderNode(childrenPlaceHolder, childrenNode, level + 1);
}
if (childrenPlaceHolder.Controls.Count > 0)
{
String subListCssClass = String.Empty;
placeHolder.Controls.Add(new LiteralControl(ListOpenHtml));
placeHolder.Controls.Add(childrenPlaceHolder);
placeHolder.Controls.Add(new LiteralControl(ListCloseHtml));
}
else
{
childrenPlaceHolder.Dispose();
}
}
// render any closing elements for the 0 level section or the child list item
if (level == 0)
{
placeHolder.Controls.Add(new LiteralControl(SectionCloseHTML));
}
else
{
placeHolder.Controls.Add(new LiteralControl(ListItemCloseHtml));
}
}
protected void Page_Load(object sender, EventArgs e)
{
outputUpdatePanel.Attributes["class"] = "updateNotifierParent";
ScheduleUpdatePanel.Attributes["class"] = "ScheduleUpdatePanel";
if (Membership.GetUser() != null)
{
MySqlCommand apparaatquery = new MySqlCommand("SELECT DISTINCT h.APPARAATID, a.naam, atype.`Type` FROM heefttoegangtot AS h INNER JOIN apparaat AS a ON h.APPARAATID = a.APPARAATID INNER JOIN apparaattype AS atype ON atype.TypeID = a.TypeID WHERE h.GROUPID IN( SELECT `GROUPID` FROM neemtdeelaan WHERE `userid` IN ( SELECT `id` FROM users WHERE `username` = :gbnaam))");
apparaatquery.Parameters.Add("gbnaam", Membership.GetUser().UserName);
List <List <string> > result = global.ExecuteReader(apparaatquery, out string apparaatError);
if (apparaatError != "")
{
/* do something with the error */
global.generic_QueryErrorHandler(apparaatquery, apparaatError);
}
else
{
Dictionary <string, string> tableQueryComb = new Dictionary <string, string>()
{
{ "kantemp", "`min`, `max`" }, { "kanstand", "`stand`" }
};
List <string> apparaatIDSmetOverlayList = new List <string>();
MySqlCommand apparatIDSMetOverlay = new MySqlCommand("SELECT DISTINCT kantemp.TYPEID, kanstand.TYPEID FROM kantemp, kanstand WHERE kantemp.TYPEID = kanstand.TYPEID");
List <List <string> > apparaatIDSmetOverlayResult = global.ExecuteReader(apparatIDSMetOverlay, out string IDError);
if (IDError != "")
{
/* do something with the error */
global.generic_QueryErrorHandler(apparatIDSMetOverlay, IDError);
}
else
{
foreach (List <string> row in apparaatIDSmetOverlayResult)
{
apparaatIDSmetOverlayList.Add(row[0]);
}
}
foreach (List <string> row in result)
{
if (apparaatIDSmetOverlayList.Contains(row[0]))
{
// get multiple values
MySqlCommand overlayQuery = new MySqlCommand("SELECT `min`, `max`, `stand` " +
"FROM kanstand " +
"INNER JOIN kantemp ON kanstand.TYPEID = kantemp.TYPEID " +
"INNER JOIN apparaattype ON apparaattype.TypeID = kantemp.TYPEID " +
"INNER JOIN apparaat ON apparaat.TYPEID = apparaattype.TypeID " +
"WHERE APPARAATID = :appID");
overlayQuery.Parameters.Add("appID", row[0]);
List <List <string> > overlayQueryResult = global.ExecuteReader(overlayQuery, out string overlayQueryError);
if (overlayQueryError != "")
{
/* do something with the error */
global.generic_QueryErrorHandler(overlayQuery, overlayQueryError);
}
else
{
// create the widget
Widget widget = (Widget)LoadControl("~/UserControls/Widget.ascx");
widget.ID = row[1];
widget.name = row[1];
if (!global.dingenDieGeenDatumInputMogen.Contains(row[2]))
{
widget.timeField = true;
}
widget.submittable = true;
// create the <Input> place holder
PlaceHolder InputPlaceHolder = new PlaceHolder();
// horizontal slider InputFields Usercontrol for in the Input place holder
InputFields slider = (InputFields)LoadControl("~/UserControls/InputFields.ascx");
slider.in_type = "ver_slider";
slider.minvalue = int.Parse(overlayQueryResult[0][0]);
slider.maxvalue = int.Parse(overlayQueryResult[0][1]);
slider.stanvalue = int.Parse(overlayQueryResult[0][0]);
slider.ID = "ver_slider";
// add the slider to the <Input> place holder
InputPlaceHolder.Controls.Add(slider);
if (overlayQueryResult[0].Contains("toggle"))
{
widget.toggle = true;
widget.input_types = new string[] { "Toggle", "ver_slider" };
}
else
{
widget.input_types = new string[] { "ver_slider", "DropDownList", "number" };
// dropdown list Inputfields usercontrol for in the input place holder
InputFields dropdownlist = (InputFields)LoadControl("~/UserControls/InputFields.ascx");
dropdownlist.in_type = "DropDownList";
dropdownlist.ID = "DropDownList";
// create the <__DropList> place holder
PlaceHolder ddlPH = new PlaceHolder();
// create the drop down list
DropDownList DDlist = new DropDownList();
// add the items for on the dropdown list
foreach (List <string> ddlRow in overlayQueryResult)
{
// add a way to set the currently active state in database as selected
DDlist.Items.Add(ddlRow[2]);
}
// set the dropdown list class ( this is to counter conflicting styling )
DDlist.CssClass = "dropDownMulti";
DDlist.ID = "DropDownListInput";
// add the dropdownlist to the <__DropList> place holder
ddlPH.Controls.Add(DDlist);
// set the dropdownlist <__DropList> place holder to previously created one
dropdownlist.__DropList = ddlPH;
// add the dropdownlist
InputPlaceHolder.Controls.Add(dropdownlist);
}
if (global.dingenDieEenTimerHebben.Contains(row[2]))
{
InputFields num = (InputFields)LoadControl("~/UserControls/InputFields.ascx");
num.in_type = "number";
num.minvalue = 0;
num.maxvalue = 60;
num.ID = "number";
TextBox numb = (TextBox)num.FindControl("NumberInput");
numb.Attributes["onchange"] = "fixValue(this)";
numb.Attributes["class"] = "inputTimer";
InputPlaceHolder.Controls.Add(num);
}
// set the <Input> place holder from the widget to the created place holder
widget.Input = InputPlaceHolder;
// add the widget to the grid
grid_parent.Controls.Add(widget);
}
}
else
{
MySqlCommand InputTypeQuery = new MySqlCommand("SELECT apparaatID, InputType, TypeWaarde FROM apparaattype AS appType INNER JOIN apparaat AS app ON appType.TypeID = app.TypeID WHERE app.apparaatid = :appID");
InputTypeQuery.Parameters.Add("appID", row[0]);
List <List <string> > inputTypeQueryResult = global.ExecuteReader(InputTypeQuery, out string InputQueryError);
if (InputQueryError != "")
{
/* do something with the error */
global.generic_QueryErrorHandler(InputTypeQuery, InputQueryError);
}
else
{
List <string> input_type = inputTypeQueryResult[0];
// create a toggable widget instead of special input widget
if (input_type[1] == "Toggle")
{
// create widget
Widget widget = (Widget)LoadControl("~/UserControls/Widget.ascx");
if (!global.dingenDieGeenDatumInputMogen.Contains(row[2]))
{
widget.timeField = true;
}
widget.name = row[1];
widget.ID = row[1];
widget.toggle = true;
widget.submittable = true;
widget.input_types = new string[] { input_type[1] };
// add the widget to the grid
grid_parent.Controls.Add(widget);
}
// create a widget with a special input type
else
{
// create widget
Widget widget = (Widget)LoadControl("~/UserControls/Widget.ascx");
if (!global.dingenDieGeenDatumInputMogen.Contains(row[2]))
{
widget.timeField = true;
}
widget.submittable = true;
widget.name = row[1];
widget.ID = row[1];
widget.input_types = new string[] { input_type[1] };
// create <Input> placeholder tag
PlaceHolder inputPH = new PlaceHolder();
// create InputFields user control
InputFields input = (InputFields)LoadControl("~/UserControls/InputFields.ascx");
input.ID = input_type[1];
int type; // the type index from the dictionary
// throw an error if the input type from the database does not exist
if (!global.listTypes.TryGetValue(input_type[1], out type))
{
throw new inputTypeException(string.Format("Given Input type does not exist! from apparaat: {0}", row[0]));
}
else
{
// get the device specs such as "min/max" or "stand"
MySqlCommand getAppSpec = new MySqlCommand();
if (input_type[2] == "kantemp")
{
getAppSpec.CommandText = "SELECT `min`, `max` " +
"FROM kantemp " +
"INNER JOIN apparaattype ON apparaattype.TypeID = kantemp.TYPEID " +
"INNER JOIN apparaat ON apparaat.TYPEID = apparaattype.TypeID " +
"WHERE APPARAATID = :apparaatid";
}
else
{
getAppSpec.CommandText = "SELECT `stand` " +
"FROM kanstand " +
"INNER JOIN apparaattype ON apparaattype.TypeID = kanstand.TYPEID " +
"INNER JOIN apparaat ON apparaat.TYPEID = apparaattype.TypeID " +
"WHERE APPARAATID = :apparaatid";
}
getAppSpec.Parameters.Add("apparaatid", input_type[0]);
// get the apparaat specs
List <List <string> > appSpec = global.ExecuteReader(getAppSpec, out string appSpecError);
if (appSpecError != "")
{
/* do something with the error */
global.generic_QueryErrorHandler(getAppSpec, appSpecError);
}
else
{
// create the <__radio> or <__DropList> placeholder
PlaceHolder ListPH = new PlaceHolder();
// set the special input parameters of the widget
switch (type)
{
case 1:
// horizontal slider
input.minvalue = int.Parse(appSpec[0][0]);
input.maxvalue = int.Parse(appSpec[0][1]);
input.stanvalue = int.Parse(appSpec[0][0]);
ListPH.Dispose(); // delete the ListPH placeholder if it is not used
break;
case 2:
// vertical slider
input.minvalue = int.Parse(appSpec[0][0]);
input.maxvalue = int.Parse(appSpec[0][1]);
input.stanvalue = int.Parse(appSpec[0][0]);
ListPH.Dispose(); // delete the ListPH placeholder if it is not used
break;
case 3:
// text
ListPH.Dispose(); // delete the ListPH placeholder if it is not used
break;
case 4:
// number
ListPH.Dispose(); // delete the ListPH placeholder if it is not used
break;
case 5:
// radio
RadioButtonList RBlist = new RadioButtonList(); // create a radio
RBlist.ID = "RadioButtonListInput";
foreach (List <string> specrow in appSpec)
{
RBlist.Items.Add(specrow[0]);
}
ListPH.Controls.Add(RBlist);
input.__Radio = ListPH;
break;
case 6:
// checkbox
CheckBoxList CKlist = new CheckBoxList();
CKlist.ID = "CheckboxListInput";
input_type[1] = "radio";
foreach (List <string> specrow in appSpec)
{
CKlist.Items.Add(specrow[0]);
}
ListPH.Controls.Add(CKlist);
input.__Radio = ListPH;
break;
case 7:
// dropdownlist
DropDownList DPlist = new DropDownList();
DPlist.ID = "DropDownListInput";
foreach (List <string> specrow in appSpec)
{
DPlist.Items.Add(specrow[0]);
}
ListPH.Controls.Add(DPlist);
input.__DropList = ListPH;
break;
default:
ListPH.Dispose(); // delete the ListPH placeholder if it is not used
break;
}
// set the in_type of the input control
input.in_type = input_type[1];
}
}
// add the input control to the <input> placeholder
inputPH.Controls.Add(input);
// set the widget <input> placeholder to inputPH
widget.Input = inputPH;
// add the widget to the grid
grid_parent.Controls.Add(widget);
}
}
}
}
}
}
ScheduleDisplayer.RowDataBound += hide_hidden;
ScheduleDisplayer.RowDeleting += Schedule_delete;
DataTable dt = global.GetScheduleTable();
if (dt.Rows.Count == 0)
{
DataRow emp_dr = dt.NewRow();
emp_dr["apparaat"] = "Currently";
emp_dr["tijd"] = "No";
emp_dr["stand"] = "Devices";
emp_dr["temp"] = "Scheduled";
emp_dr["hidden"] = DateTime.Now;
dt.Rows.Add(emp_dr);
global.show_delete_btn = false;
}
else
{
global.show_delete_btn = true;
}
ScheduleDisplayer.DataSource = dt;
ScheduleDisplayer.DataBind();
}