private void insertBtn_Click(object sender, EventArgs e)
{
var sql = "INSERT INTO Calls (Fname, Mint, Lname, Address, Reason_for_call) " +
"VALUES (@firstName, @middleInt, @lastName, @address, @reason);";
string connectionString = Emergancy_Room_Database.Properties.Settings.Default.ERDatabaseConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (var cmd = new SqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@firstName", fNameTB.Text);
cmd.Parameters.AddWithValue("@middleInt", MITB.Text);
cmd.Parameters.AddWithValue("@lastName", lNameTB.Text);
cmd.Parameters.AddWithValue("@address", addressTB.Text);
cmd.Parameters.AddWithValue("@reason", reasonTB.Text);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayCallsTable displayCallsTable = new displayCallsTable();
displayCallsTable.ShowDialog();
this.Close();
}
private void updateBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(IDlbl.Text);
var sql = "UPDATE Calls SET Fname = @firstName, Mint = @middleInt, Lname = @lastName, Address = @address, Reason_for_call = @reason WHERE Call_Id = @id";
string connectionString = Emergancy_Room_Database.Properties.Settings.Default.ERDatabaseConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (var cmd = new SqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@firstName", fNameTB.Text);
cmd.Parameters.AddWithValue("@middleInt", MITB.Text);
cmd.Parameters.AddWithValue("@lastName", lNameTB.Text);
cmd.Parameters.AddWithValue("@address", addressTB.Text);
cmd.Parameters.AddWithValue("@reason", reasonForCallTB.Text);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayCallsTable displayCallsTable = new displayCallsTable();
displayCallsTable.ShowDialog();
this.Close();
}
private void displayCallsBtn_Click(object sender, EventArgs e)
{
this.Hide();
displayCallsTable displayCallsTable = new displayCallsTable();
displayCallsTable.ShowDialog();
this.Close();
}
private void enterBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(idChoiceTb.Text);
var sql = "DELETE FROM Calls WHERE Call_Id = @id";
string connectionString = Emergancy_Room_Database.Properties.Settings.Default.ERDatabaseConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (var cmd = new SqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayCallsTable displayCallsTable = new displayCallsTable();
displayCallsTable.ShowDialog();
this.Close();
}