private void insertBtn_Click(object sender, EventArgs e)
{
var sql = "INSERT INTO Patients (Fname, Mint, Lname, Sex, Address, Date_of_birth, Perscription, Diagnosis) " +
"VALUES (@firstName, @middleInt, @lastName, @sex, @address, @dateBirth, @perscription, @diagnosis);";
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("@sex", SexTB.Text);
cmd.Parameters.AddWithValue("@address", addressTB.Text);
cmd.Parameters.AddWithValue("@dateBirth", dateOfBirthTB.Text);
cmd.Parameters.AddWithValue("@perscription", perscriptionTB.Text);
cmd.Parameters.AddWithValue("@diagnosis", diagnosisTB.Text);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayPatientTable displayPatientTable = new displayPatientTable();
displayPatientTable.ShowDialog();
this.Close();
}
private void displayPatientsBtn_Click(object sender, EventArgs e)
{
this.Hide();
displayPatientTable displayPatientTable = new displayPatientTable();
displayPatientTable.ShowDialog();
this.Close();
}
private void enterBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(idChoiceTb.Text);
var sql = "DELETE FROM Patients WHERE Patient_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();
displayPatientTable displayPatientTable = new displayPatientTable();
displayPatientTable.ShowDialog();
this.Close();
}
private void updateBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(IDlbl.Text);
int roomNum = int.Parse(RoomTB.Text);
int bill = int.Parse(billTB.Text);
int call_id = int.Parse(callIDTB.Text);
var sql = "UPDATE Patients SET Fname = @firstName, Mint = @middleInt, Lname = @lastName, Sex = @sex, Address = @address, " +
"Date_of_birth = @dateBirth, Room# = @room, Bill = @bill, Perscription = @pers, Diagnosis = @diag, Call_id = @callId WHERE Patient_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("@sex", RoomTB.Text);
cmd.Parameters.AddWithValue("@address", addressTB.Text);
cmd.Parameters.AddWithValue("@dateBirth", dateOfBirthTB.Text);
cmd.Parameters.AddWithValue("@room", roomNum);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@bill", bill);
cmd.Parameters.AddWithValue("@pers", perscriptionTB.Text);
cmd.Parameters.AddWithValue("@diag", diagnosisTB.Text);
cmd.Parameters.AddWithValue("@callId", call_id);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayPatientTable displayPatientTable = new displayPatientTable();
displayPatientTable.ShowDialog();
this.Close();
}