1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
Adapter.InsertCommand = new SqlCommand("INSERT INTO AdmissionRecords (AdmissionID, PatientID, SurgeryScheduled, AdmitDate, SurgeryDate, DischargeDate) VALUES (@AdmissionID, @PatientID, @SurgeryScheduled, @AdmitDate, @SurgeryDate, @DischargeDate );" +
"INSERT INTO Beds (BedNumber, BedType, Occupied, WardName) VALUES (@BedNumber, @BedType, @Occupied, @WardName)", Connection);
Adapter.InsertCommand.Parameters.Add("@AdmissionID", SqlDbType.NVarChar).Value = txtAdmissionID.Text;
Adapter.InsertCommand.Parameters.Add("@PatientID", SqlDbType.NVarChar).Value = txtPatientID.Text;
Adapter.InsertCommand.Parameters.Add("@SurgeryScheduled", SqlDbType.Bit).Value = checkBoxSurgerySchedule.Checked;
//Adapter.InsertCommand.Parameters.Add("@SurgeryDate", SqlDbType.Date).Value = Convert.ToDateTime(this.maskedtxtDateChirurgie.Text);
Adapter.InsertCommand.Parameters.Add("@AdmitDate", SqlDbType.Date).Value = Convert.ToDateTime(this.maskedtxtDateAdmission.Text);
Adapter.InsertCommand.Parameters.Add("@DischargeDate", SqlDbType.Date).Value = Convert.ToDateTime(this.maskedtxtDateCharge.Text);
Adapter.InsertCommand.Parameters.Add("@BedNumber", SqlDbType.NVarChar).Value = txtNumeroLit.Text;
Adapter.InsertCommand.Parameters.Add("@BedType", SqlDbType.NVarChar).Value = txtBedType.Text;
Adapter.InsertCommand.Parameters.Add("@Occupied", SqlDbType.Bit).Value = checkBoxOccupied.Checked;
Adapter.InsertCommand.Parameters.Add("@WardName", SqlDbType.NVarChar).Value = txtWardName.Text; |
Partager