///<summary>Add a hardware into the database ///with the filled information</summary> ///<remarks>NULL in the database (table) will be overwritten with a empty string ///</remarks> protected void Submit_Click(object sender, EventArgs e) { String strSerialNr = Serialnr.Text.ToString(); String strWarrantyInfo = warrantyInfo.Text.ToString(); String strInternalNr = internalNr.Text.ToString(); String strExtraInfo = extraInfo.Text.ToString(); String mImagePath = Testlocation.Text.ToString(); String mAttPath = TestlocationAtt.Text; String strModel = modelNr.Text; int intSelectedTypeIndex = typeList.SelectedIndex + 1; String strSelectedManufacturer = manufacturerList.SelectedItem.ToString(); String dtePurchaseYear = txtDatepicker.Text.Substring(6); String dtePurchaseDay = txtDatepicker.Text.Substring(0, 2); String dtePurchaseMonth = txtDatepicker.Text.Substring(3, 2); //dtePurchaseDate converts the datepicker to database usable date String dtePurchaseDate = dtePurchaseYear + '-' + dtePurchaseMonth + '-' + dtePurchaseDay; String dteAddedDate = DateTime.Now.ToString("yyyy-MM-dd"); DateTime addedDate = DateTime.Today; DateTime purchaseDate = new DateTime(int.Parse(dtePurchaseYear), int.Parse(dtePurchaseMonth), int.Parse(dtePurchaseDay), 0, 0, 0); int result = DateTime.Compare(purchaseDate, addedDate); if (result > 0) { dtePurchaseDate = dteAddedDate; } try { if (mImagePath == "" || mImagePath == null) { ViewState["pictureLocation"] = ""; } else { ViewState["pictureLocation"] = ViewState["timeStampAddedHardware"] + mImagePath; } if (TestlocationAtt.Text == "" || TestlocationAtt.Text == null) { ViewState["attachmentLocation"] = ""; } else { ViewState["attachmentLocation"] = ViewState["timeStampAddedHardware"] + TestlocationAtt.Text; } txtResultUpload.Text = "Congratulations! The device with a internal nr: " + "<span style=\"color:red\">" + strInternalNr + "</span>" + " and a serial nr: " + "<span style=\"color:red\">" + strSerialNr + "</span>" + " successfully added to the database."; var hardware = new Hardware(dteAddedDate, ViewState["attachmentLocation"].ToString(), strExtraInfo, strInternalNr, strSelectedManufacturer, strModel, ViewState["pictureLocation"].ToString(), dtePurchaseDate, strSerialNr, strWarrantyInfo, typeList.SelectedValue); hardware.AddHardwareIntoDatabase(); viewJustAddedHardware(); } catch (MySqlException ex) { if (ex.Number.ToString() == "1062") { txtResultUpload.Text = "The device with a internal nr: " + "<span style=\"color:red\">" + strInternalNr + "</span>" + " and a serial nr: " + "<span style=\"color:red\">" + strSerialNr + "</span>" + " already exist in de database."; } else { ShowMessage(ex.Message); } } addHardwarePanel.Visible = false; addResultPanel.Visible = true; }