private void button_Click(object sender, RoutedEventArgs e)
{
Clients window = new Clients();
window.Show();
this.Hide();
}
private void buttondel_Click(object sender, RoutedEventArgs e)
{
if (!refresh())
{
return;
}
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Are you sure you want to delete this client?", "Delete Confirmation", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
try
{
SqlCommand cmd = new SqlCommand("EXEC DeleteClient " + editing.ID);
cmd.Connection = cn;
cmd.ExecuteNonQuery();
if (goback == "shares")
{
Shares window = new Shares();
window.Show();
this.Hide();
}
else
{
Clients window = new Clients();
window.Show();
this.Hide();
}
} catch (SqlException) { MessageBox.Show("Error deleting client."); }
}
}
private void Users_Click(object sender, RoutedEventArgs e)
{
Clients user = new Clients();
user.Show();
this.Close();
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (mode == "loan")
{
Loans window = new Loans();
window.Show();
this.Hide();
}
else
{
Clients window = new Clients();
window.Show();
this.Hide();
}
}
private void button_Click(object sender, RoutedEventArgs e) //return
{
if (goback == "shares")
{
Shares window = new Shares();
window.Show();
this.Hide();
}
else
{
Clients window = new Clients();
window.Show();
this.Hide();
}
}
private void button1_Click(object sender, RoutedEventArgs e) //save
{
if (!refresh())
{
return;
}
string postal = t3.Text;
string addr = t5.Text;
if (!Regex.IsMatch(postal, "^[^()\\*;+='\\\\/]*$") || !Regex.IsMatch(addr, "^[^()\\*;+='\\\\/]*$") || postal.Contains("--") || addr.Contains("--"))
{
MessageBox.Show("Invalid characters detected.");
return;
}
try
{
SqlCommand cmd = new SqlCommand("UPDATE CLIENTS SET postal='" + postal + "', addr='" + addr + "' WHERE id=" + editing.ID.ToString());
cmd.Connection = cn;
cmd.ExecuteNonQuery();
if (goback == "shares")
{
Shares window = new Shares();
window.Show();
this.Hide();
}
else
{
Clients window = new Clients();
window.Show();
this.Hide();
}
} catch (SqlException) { MessageBox.Show("Error updating database: some fields may contain too much text."); }
}
private void button_Click_1(object sender, RoutedEventArgs e)
{
if (!refresh())
{
return;
}
if (!Regex.IsMatch(textBox.Text, "^[^()\\*;+='\\\\/]*$") || !Regex.IsMatch(textBox2.Text, "^[^()\\*;+='\\\\/]*$") || !Regex.IsMatch(textBox3.Text, "^[^()\\*;+='\\\\/]*$") || textBox.Text.Contains("--") || textBox2.Text.Contains("--") || textBox3.Text.Contains("--"))
{
MessageBox.Show("Invalid characters detected.");
return;
}
//make sure unique IDs are used when creating things
SqlCommand cmd = new SqlCommand("SELECT max(id) FROM CLIENTS");
cmd.Connection = cn;
int newID = (int)cmd.ExecuteScalar() + 1;
string gender;
if (radioButton.IsChecked == true)
{
gender = "Male";
}
else if (radioButton2.IsChecked == true)
{
gender = "Female";
}
else
{
gender = "Other";
}
try
{
int aux = -1;
long aux2 = -1;
if (!int.TryParse(textBoxnif.Text, out aux))
{
MessageBox.Show("Invalid NIF.");
return;
}
if (!long.TryParse(textBox4.Text, out aux2))
{
MessageBox.Show("Invalid Citizen ID.");
return;
}
try
{
cmd = new SqlCommand("INSERT INTO CLIENTS (id, name, addr, postal, citid, gender, nif) VALUES (" + newID + ", '" + textBox.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "', '" + gender + "', " + aux + ")");
cmd.Connection = cn;
cmd.ExecuteNonQuery();
Clients window = new Clients();
window.Show();
this.Hide();
}
catch (SqlException) { MessageBox.Show("Error updating database: the NIF might be too big, or some fields may contain too much text."); }
}
catch (OverflowException) { MessageBox.Show("The number is too big."); }
}
