private void button_DeleteEntry_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Sure?", "Delete DB Entry", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { TypeSendDBUpdate instruc = new TypeSendDBUpdate(); instruc.WhereIDIs = Convert.ToInt32(textBox_ID.Text); instruc.deleteFromDB = true; TypeReturnDBChanged answer = SqlAndWeb.httpPostWithErrorCheckAndPassword <TypeReturnDBChanged>(instruc, textBox_ServerAddress.Text, _Password); MessageBox.Show("Lines Affected=" + answer.linesAffected, "DB Change Info"); } }
private void button_SaveChanges_Click(object sender, EventArgs e) { TypeSendDBUpdate instruc = new TypeSendDBUpdate(); instruc.WhereIDIs = Convert.ToInt32(textBox_ID.Text); instruc.newVoorNaam = textBox_Voornaam.Text; instruc.newAchterNaam = textBox_Achternaam.Text; if (_TheImage != null) { instruc.newBase64ProfileImage = Conversion.imageToBase64String(_TheImage); } else { instruc.newBase64ProfileImage = "GeenPlaatje"; } TypeReturnDBChanged answer = SqlAndWeb.httpPostWithErrorCheckAndPassword <TypeReturnDBChanged>(instruc, textBox_ServerAddress.Text, _Password); MessageBox.Show("Lines Affected=" + answer.linesAffected, "DB Change Info"); button_CancelChanges_Click(null, null); // disable buttons }
//Ok 10-40MS /// <summary> /// update DB return affected lines ( ja dat is handig ) /// </summary> /// <param name="_inObject"></param> /// <returns></returns> public static string editDataFromDB(object _inObject) { try { string wertkWel = JsonConvert.SerializeObject(_inObject); TypeSendDBUpdate inObject = JsonConvert.DeserializeObject <TypeSendDBUpdate>(wertkWel); SqlCommand command = new SqlCommand(); command.Parameters.AddWithValue("@whereID", inObject.WhereIDIs); if (inObject.deleteFromDB) { command.CommandText = ("DELETE FROM " + settings.studentBDTableName + " WHERE id = @whereID"); } else { command.Parameters.AddWithValue("@voorNaam", inObject.newVoorNaam); command.Parameters.AddWithValue("@achterNaam", inObject.newAchterNaam); command.Parameters.AddWithValue("@profileImage", inObject.newBase64ProfileImage); if (inObject.updateFingerprintTemplate) { command.Parameters.AddWithValue("@fingerprintTemplate", inObject.newBase64FingerprintTemplate); command.CommandText = "UPDATE " + settings.studentBDTableName + " SET voorNaam=@voorNaam, achterNaam=@achterNaam, profileImage=@profileImage, fingerprintTemplate=@fingerprintTemplate WHERE ID=@whereID"; } else { command.CommandText = "UPDATE " + settings.studentBDTableName + " SET voorNaam=@voorNaam, achterNaam=@achterNaam, profileImage=@profileImage WHERE ID=@whereID"; } } TypeReturnDBChanged response = new TypeReturnDBChanged(); response.linesAffected = SqlAndWeb.SQLNonQuery(settings.connectionString, command); return(JsonConvert.SerializeObject(response)); } catch (Exception ex) { TypeReturnError typeForError = new TypeReturnError(); typeForError.why = "(editDataFromDB)" + ex.Message; return(JsonConvert.SerializeObject(typeForError)); } }