private void BtnAddData_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
switch (role)
{
case FormRole.ROLE_ADD:
sb.Append("INSERT INTO person(name,surname,phone,email,age,gender) VALUES(");
sb.Append("'" + TbName.Text.ToString() + "',");
sb.Append("'" + TbSurname.Text.ToString() + "',");
sb.Append("'" + tbPhone.Text.ToString() + "',");
sb.Append("'" + tbEmail.Text.ToString() + "',");
sb.Append("'" + tbAge.Text.ToString() + "',");
sb.Append("'" + comboGender.Text.ToString() + "')");
break;
case FormRole.ROLE_EDIT:
sb.Append("UPDATE person SET ");
sb.Append("name='" + TbName.Text.ToString() + "', ");
sb.Append("surname='" + TbSurname.Text.ToString() + "', ");
sb.Append("phone='" + tbPhone.Text.ToString() + "', ");
sb.Append("email='" + tbEmail.Text.ToString() + "', ");
sb.Append("age='" + tbAge.Text.ToString() + "', ");
sb.Append("gender='" + comboGender.Text.ToString() + "' ");
sb.Append("WHERE id=").Append(editedEntryID).Append(";");
break;
default:
break;
}
SqlCeCommand query = new SqlCeCommand(sb.ToString(), main.SQLconn);
try
{
query.ExecuteNonQuery();
switch (role)
{
case FormRole.ROLE_ADD:
MessageBox.Show(this, "Dodano!", "Informacja", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
case FormRole.ROLE_EDIT:
MessageBox.Show(this, "Zapisano zmiany!", "Informacja", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
}
main.CallRefresh();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(this, "Błąd: " + ex.Message.ToString(), "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
