protected void submitBTN_Click(object sender, EventArgs e)
{
Label output = (Label)Parent.FindControl("output");
string[] UserInput = new string[3];
output.Text = "";
int Timer = 999;
for (int i = 0; i < input_types.Length; i++)
{
if (input_types[i] == "Toggle")
{
UserInput[i] = Toggle_Checkbox.Checked.ToString();
}
else
{
if (Input.FindControl(input_types[i]) != null)
{
InputFields InputField = (InputFields)Input.FindControl(input_types[i]);
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_types[i], out type))
{
throw new inputTypeException(string.Format("Given Input type does not exist! from widget: {0}", ID));
}
else
{
switch (type)
{
case 1:
// horizontal slider
TextBox H_R_Input = (TextBox)InputField.FindControl("Range_Input");
UserInput[i] = H_R_Input.Text;
break;
case 2:
// vertical slider
TextBox V_R_Input = (TextBox)InputField.FindControl("Range_Input_Vert");
UserInput[i] = V_R_Input.Text;
break;
case 3:
// text
TextBox Text = (TextBox)InputField.FindControl("TextInput");
UserInput[i] = Text.Text;
break;
case 4:
// number
TextBox num = (TextBox)InputField.FindControl("NumberInput");
if (i == 2)
{
// the timer input
Timer = int.Parse(num.Text);
}
else
{
UserInput[i] = num.Text;
}
break;
case 5:
// radio
RadioButtonList RBList = (RadioButtonList)InputField.__DropList.FindControl("RadioButtonListInput");
UserInput[i] = RBList.SelectedValue;
break;
case 6:
// checkbox
CheckBoxList CKList = (CheckBoxList)InputField.__DropList.FindControl("CheckboxListInput");
UserInput[i] = CKList.SelectedValue;
break;
case 7:
// dropdownlist
DropDownList DDList = (DropDownList)InputField.__DropList.FindControl("DropDownListInput");
UserInput[i] = DDList.SelectedValue;
break;
default:
// nothing
break;
}
}
}
}
}
int subtractor = 2;
if ((timeInput.Text.Length % 2) != 0)
{
subtractor = 1;
}
DateTime schedule;
DateTime Month;
if (timeInput.Text == "")
{
schedule = DateTime.Now;
}
else
{
if (int.Parse(timeInput.Text.Substring(timeInput.Text.Length - subtractor, subtractor)) < DateTime.Now.Day)
{
Month = DateTime.Now.AddMonths(1);
}
else
{
Month = DateTime.Now;
}
schedule = new DateTime(DateTime.Now.Year, Month.Month, int.Parse(timeInput.Text.Substring(timeInput.Text.Length - subtractor, subtractor)), int.Parse(timeInput.Text.Substring(0, 2)), int.Parse(timeInput.Text.Substring(3, 2)), DateTime.Now.Second);
}
global.updateDevices(UserInput, schedule, Timer, name, out string error);
if (error != "")
{
/* do something with the error */
throw new QueryErrorException(error);
}
else
{
string time = schedule.ToShortDateString() + " " + schedule.ToShortTimeString();
if (schedule.DayOfYear > DateTime.Now.DayOfYear)
{
if (schedule.DayOfYear - DateTime.Now.DayOfYear > 1)
{
time = string.Format("voor {0}-{1}", schedule.Day, schedule.Month);
}
else
{
time = string.Format("voor morgen");
}
time += string.Format(" om {0}", schedule.ToShortTimeString());
}
else
{
time = string.Format("voor {0} vandaag", schedule.ToShortTimeString());
}
output.Text = string.Format("{0} toegevoegd {1}", name, time);
if (Timer != 999)
{
output.Text += " voor " + Timer.ToString() + " Minuten";
}
}
output.DataBind();
GridView ScheduleDisplayer = (GridView)Parent.FindControl("ScheduleDisplayer");
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();
}
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();
}
