private void enterBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(IDlbl.Text);
int patID = int.Parse(patientIDTB.Text);
float amount = float.Parse(billAmountTB.Text);
var sql = "UPDATE Bills SET Patient = @patID, Bill_amount = @amount, Bill_payed = @payed, Payment_method = @method WHERE Bill_Id = @billID";
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("@patID", patID);
cmd.Parameters.AddWithValue("@amount", amount);
cmd.Parameters.AddWithValue("@payed", billPayedTB.Text);
cmd.Parameters.AddWithValue("@method", paymentMethodTB.Text);
cmd.Parameters.AddWithValue("@billID", id);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayBillsTable displayBillsTable = new displayBillsTable();
displayBillsTable.ShowDialog();
this.Close();
}
private void insertBtn_Click(object sender, EventArgs e)
{
var sql = "INSERT INTO Bills (Patient, Bill_amount, Bill_payed, Payment_Method) " +
"VALUES (@patient, @bill_amount, @bill_payed, @payment_method);";
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("@patient", patientIDTB.Text);
cmd.Parameters.AddWithValue("@bill_amount", billAmountTB.Text);
cmd.Parameters.AddWithValue("@bill_payed", billPayedTB.Text);
cmd.Parameters.AddWithValue("@payment_method", paymentMethodTB.Text);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayBillsTable displayBillsTable = new displayBillsTable();
displayBillsTable.ShowDialog();
this.Close();
}
private void displayBillsBtn_Click(object sender, EventArgs e)
{
this.Hide();
displayBillsTable displayBillsTable = new displayBillsTable();
displayBillsTable.ShowDialog();
this.Close();
}
private void enterBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(idChoiceTb.Text);
var sql = "DELETE FROM Bills WHERE Bill_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();
displayBillsTable displayBillsTable = new displayBillsTable();
displayBillsTable.ShowDialog();
this.Close();
}