public static void GetDoctorsProcedures()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string queryString = "SELECT * FROM DoctorsProcedures";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DoctorsProcedure doctorProcedure = new DoctorsProcedure();
doctorProcedure.doctorName = (!reader.IsDBNull(reader.GetOrdinal("doctorName"))) ? reader.GetString(0) : "null";
doctorProcedure.doctorID = (!reader.IsDBNull(reader.GetOrdinal("doctorID"))) ? reader.GetString(1) : "null";
doctorProcedure.gloveSize = reader.GetDecimal(2);
doctorProcedure.procedureName = (!reader.IsDBNull(reader.GetOrdinal("procedureName"))) ? reader.GetString(3) : "null";
doctorProcedure.modality = (!reader.IsDBNull(reader.GetOrdinal("modality"))) ? reader.GetString(4) : "null";
doctorProcedure.patientOrientation = (!reader.IsDBNull(reader.GetOrdinal("patientOrientation"))) ? reader.GetString(5) : "null";
doctorProcedure.ifBilateral = (!reader.IsDBNull(reader.GetOrdinal("ifBilateral"))) ? reader.GetString(6) : "null";
doctorProcedure.syringes1mL = (!reader.IsDBNull(reader.GetOrdinal("syringes1mL"))) ? reader.GetDecimal(7) : 0;
doctorProcedure.syringes3mL = (!reader.IsDBNull(reader.GetOrdinal("syringes3mL"))) ? reader.GetDecimal(8) : 0;
doctorProcedure.syringes5mL = (!reader.IsDBNull(reader.GetOrdinal("syringes5mL"))) ? reader.GetDecimal(9) : 0;
doctorProcedure.syringes10mL = (!reader.IsDBNull(reader.GetOrdinal("syringes10mL"))) ? reader.GetDecimal(10) : 0;
doctorProcedure.needleDrawingUp = (!reader.IsDBNull(reader.GetOrdinal("needleDrawingUp"))) ? reader.GetDecimal(11) : 0;
doctorProcedure.needle25g = (!reader.IsDBNull(reader.GetOrdinal("needle25g"))) ? reader.GetDecimal(12) : 0;
doctorProcedure.needle19g = (!reader.IsDBNull(reader.GetOrdinal("needle19g"))) ? reader.GetDecimal(13) : 0;
doctorProcedure.needle22g50mm = (!reader.IsDBNull(reader.GetOrdinal("needle22g50mm"))) ? reader.GetDecimal(14) : 0;
doctorProcedure.needle22g90mm = (!reader.IsDBNull(reader.GetOrdinal("needle22g90mm"))) ? reader.GetDecimal(15) : 0;
doctorProcedure.contrast = (!reader.IsDBNull(reader.GetOrdinal("contrast"))) ? reader.GetString(16) : "null";
doctorProcedure.lignocaine = (!reader.IsDBNull(reader.GetOrdinal("lignocaine"))) ? reader.GetDecimal(17) : 0;
doctorProcedure.bupivacaine = (!reader.IsDBNull(reader.GetOrdinal("bupivacaine"))) ? reader.GetDecimal(18) : 0;
doctorProcedure.steroidType = (!reader.IsDBNull(reader.GetOrdinal("steroidType"))) ? reader.GetString(19) : "null";
doctorProcedure.steroidAmount = (!reader.IsDBNull(reader.GetOrdinal("steroidAmount"))) ? reader.GetDecimal(20) : 0;
doctorProcedure.otherEquipment = (!reader.IsDBNull(reader.GetOrdinal("otherEquipment"))) ? reader.GetString(21) : "null";
doctorProcedure.comments = (!reader.IsDBNull(reader.GetOrdinal("comments"))) ? reader.GetString(22) : "null";
DoctorProceduresList.Add(doctorProcedure);
}
}
}
}
}
public static void GetDoctorsProcedures()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string queryString = "SELECT * FROM DoctorsProcedures";
using (SqlCommand command = new SqlCommand(queryString, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
DoctorsProcedure doctorProcedure = new DoctorsProcedure();
doctorProcedure.doctorName = (!reader.IsDBNull(reader.GetOrdinal("doctorName"))) ? reader.GetString(0) : "null";
doctorProcedure.doctorID = (!reader.IsDBNull(reader.GetOrdinal("doctorID"))) ? reader.GetString(1) : "null";
doctorProcedure.gloveSize = reader.GetDecimal(2);
doctorProcedure.procedureName = (!reader.IsDBNull(reader.GetOrdinal("procedureName"))) ? reader.GetString(3) : "null";
doctorProcedure.modality = (!reader.IsDBNull(reader.GetOrdinal("modality"))) ? reader.GetString(4) : "null";
doctorProcedure.patientOrientation = (!reader.IsDBNull(reader.GetOrdinal("patientOrientation"))) ? reader.GetString(5) : "null";
doctorProcedure.ifBilateral = (!reader.IsDBNull(reader.GetOrdinal("ifBilateral"))) ? reader.GetString(6) : "null";
doctorProcedure.syringes1mL = (!reader.IsDBNull(reader.GetOrdinal("syringes1mL"))) ? reader.GetDecimal(7) : 0;
doctorProcedure.syringes3mL = (!reader.IsDBNull(reader.GetOrdinal("syringes3mL"))) ? reader.GetDecimal(8) : 0;
doctorProcedure.syringes5mL = (!reader.IsDBNull(reader.GetOrdinal("syringes5mL"))) ? reader.GetDecimal(9) : 0;
doctorProcedure.syringes10mL = (!reader.IsDBNull(reader.GetOrdinal("syringes10mL"))) ? reader.GetDecimal(10) : 0;
doctorProcedure.needleDrawingUp = (!reader.IsDBNull(reader.GetOrdinal("needleDrawingUp"))) ? reader.GetDecimal(11) : 0;
doctorProcedure.needle25g = (!reader.IsDBNull(reader.GetOrdinal("needle25g"))) ? reader.GetDecimal(12) : 0;
doctorProcedure.needle19g = (!reader.IsDBNull(reader.GetOrdinal("needle19g"))) ? reader.GetDecimal(13) : 0;
doctorProcedure.needle22g50mm = (!reader.IsDBNull(reader.GetOrdinal("needle22g50mm"))) ? reader.GetDecimal(14) : 0;
doctorProcedure.needle22g90mm = (!reader.IsDBNull(reader.GetOrdinal("needle22g90mm"))) ? reader.GetDecimal(15) : 0;
doctorProcedure.contrast = (!reader.IsDBNull(reader.GetOrdinal("contrast"))) ? reader.GetString(16) : "null";
doctorProcedure.lignocaine = (!reader.IsDBNull(reader.GetOrdinal("lignocaine"))) ? reader.GetDecimal(17) : 0;
doctorProcedure.bupivacaine = (!reader.IsDBNull(reader.GetOrdinal("bupivacaine"))) ? reader.GetDecimal(18) : 0;
doctorProcedure.steroidType = (!reader.IsDBNull(reader.GetOrdinal("steroidType"))) ? reader.GetString(19) : "null";
doctorProcedure.steroidAmount = (!reader.IsDBNull(reader.GetOrdinal("steroidAmount"))) ? reader.GetDecimal(20) : 0;
doctorProcedure.otherEquipment = (!reader.IsDBNull(reader.GetOrdinal("otherEquipment"))) ? reader.GetString(21) : "null";
doctorProcedure.comments = (!reader.IsDBNull(reader.GetOrdinal("comments"))) ? reader.GetString(22) : "null";
DoctorProceduresList.Add(doctorProcedure);
}
}
}
}
}
private void submitButton_Click(object sender, EventArgs e)
{
DoctorProcedureClassDataContext setupContext = new DoctorProcedureClassDataContext();
DataClasses1DataContext doctorContext = new DataClasses1DataContext();
try
{
var checkDB = (from setupCheck in setupContext.DoctorsProcedures
where setupCheck.doctorName == doctorBox.Text &&
setupCheck.procedureName == procedureBox.Text
select setupCheck).Any();
var doctor = (from initials in doctorContext.Doctors
where initials.doctorName == doctorBox.Text
select initials).First();
if (checkDB == true)
{
var doctorSetup = (from setupCheck in setupContext.DoctorsProcedures
where setupCheck.doctorName == doctorBox.Text &&
setupCheck.procedureName == procedureBox.Text
select setupCheck).First();
doctorSetup.doctorName = doctorBox.Text;
doctorSetup.doctorID = doctor.doctorID;
doctorSetup.gloveSize = doctor.gloveSize;
doctorSetup.procedureName = procedureBox.Text;
doctorSetup.modality = modalityBox.Text;
doctorSetup.patientOrientation = patientOrientationBox.Text;
doctorSetup.ifBilateral = ifBilateralBox.Text;
doctorSetup.syringes1mL = Decimal.Parse(syringes1mLBox.Text);
doctorSetup.syringes3mL = Decimal.Parse(syringes3mLBox.Text);
doctorSetup.syringes5mL = Decimal.Parse(syringes5mLBox.Text);
doctorSetup.syringes10mL = Decimal.Parse(syringes10mLBox.Text);
doctorSetup.needleDrawingUp = Decimal.Parse(needleDrawingUpBox.Text);
doctorSetup.needle25g = Decimal.Parse(needle25gBox.Text);
doctorSetup.needle19g = Decimal.Parse(needle19gBox.Text);
doctorSetup.needle22g50mm = Decimal.Parse(needle22g50mmBox.Text);
doctorSetup.needle22g90mm = Decimal.Parse(needle22g90mmBox.Text);
doctorSetup.contrast = contrastBox.Text;
doctorSetup.lignocaine = Decimal.Parse(lignocaineBox.Text);
doctorSetup.bupivacaine = Decimal.Parse(bupivacaineBox.Text);
doctorSetup.steroidType = steroidTypeBox.Text;
doctorSetup.steroidAmount = Decimal.Parse(steroidAmountBox.Text);
doctorSetup.otherEquipment = otherEquipmentBox.Text;
doctorSetup.comments = commentsBox.Text;
setupContext.SubmitChanges();
Form1.DoctorProceduresList.Clear();
Form1.GetDoctorsProcedures();
MessageBox.Show("Updated", "Setup",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DoctorsProcedure setup = new DoctorsProcedure();
try
{
setup.doctorName = doctorBox.Text;
setup.doctorID = doctor.doctorID;
setup.gloveSize = doctor.gloveSize;
setup.procedureName = procedureBox.Text;
setup.modality = modalityBox.Text;
setup.patientOrientation = patientOrientationBox.Text;
setup.ifBilateral = ifBilateralBox.Text;
setup.syringes1mL = Decimal.Parse(syringes1mLBox.Text);
setup.syringes3mL = Decimal.Parse(syringes3mLBox.Text);
setup.syringes5mL = Decimal.Parse(syringes5mLBox.Text);
setup.syringes10mL = Decimal.Parse(syringes10mLBox.Text);
setup.needleDrawingUp = Decimal.Parse(needleDrawingUpBox.Text);
setup.needle25g = Decimal.Parse(needle25gBox.Text);
setup.needle19g = Decimal.Parse(needle19gBox.Text);
setup.needle22g50mm = Decimal.Parse(needle22g50mmBox.Text);
setup.needle22g90mm = Decimal.Parse(needle22g90mmBox.Text);
setup.contrast = contrastBox.Text;
setup.lignocaine = Decimal.Parse(lignocaineBox.Text);
setup.bupivacaine = Decimal.Parse(bupivacaineBox.Text);
setup.steroidType = steroidTypeBox.Text;
setup.steroidAmount = Decimal.Parse(steroidAmountBox.Text);
setup.otherEquipment = otherEquipmentBox.Text;
setup.comments = commentsBox.Text;
setupContext.DoctorsProcedures.InsertOnSubmit(setup);
setupContext.SubmitChanges();
Form1.DoctorProceduresList.Clear();
Form1.GetDoctorsProcedures();
MessageBox.Show("Added", "Setup",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Please make sure all fields are filled out correctly...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Please select a doctor and procedure...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void submitButton_Click(object sender, EventArgs e)
{
DoctorProcedureClassDataContext setupContext = new DoctorProcedureClassDataContext();
DataClasses1DataContext doctorContext = new DataClasses1DataContext();
try
{
var checkDB = (from setupCheck in setupContext.DoctorsProcedures
where setupCheck.doctorName == doctorBox.Text &&
setupCheck.procedureName == procedureBox.Text
select setupCheck).Any();
var doctor = (from initials in doctorContext.Doctors
where initials.doctorName == doctorBox.Text
select initials).First();
if (checkDB == true)
{
var doctorSetup = (from setupCheck in setupContext.DoctorsProcedures
where setupCheck.doctorName == doctorBox.Text &&
setupCheck.procedureName == procedureBox.Text
select setupCheck).First();
doctorSetup.doctorName = doctorBox.Text;
doctorSetup.doctorID = doctor.doctorID;
doctorSetup.gloveSize = doctor.gloveSize;
doctorSetup.procedureName = procedureBox.Text;
doctorSetup.modality = modalityBox.Text;
doctorSetup.patientOrientation = patientOrientationBox.Text;
doctorSetup.ifBilateral = ifBilateralBox.Text;
doctorSetup.syringes1mL = Decimal.Parse(syringes1mLBox.Text);
doctorSetup.syringes3mL = Decimal.Parse(syringes3mLBox.Text);
doctorSetup.syringes5mL = Decimal.Parse(syringes5mLBox.Text);
doctorSetup.syringes10mL = Decimal.Parse(syringes10mLBox.Text);
doctorSetup.needleDrawingUp = Decimal.Parse(needleDrawingUpBox.Text);
doctorSetup.needle25g = Decimal.Parse(needle25gBox.Text);
doctorSetup.needle19g = Decimal.Parse(needle19gBox.Text);
doctorSetup.needle22g50mm = Decimal.Parse(needle22g50mmBox.Text);
doctorSetup.needle22g90mm = Decimal.Parse(needle22g90mmBox.Text);
doctorSetup.contrast = contrastBox.Text;
doctorSetup.lignocaine = Decimal.Parse(lignocaineBox.Text);
doctorSetup.bupivacaine = Decimal.Parse(bupivacaineBox.Text);
doctorSetup.steroidType = steroidTypeBox.Text;
doctorSetup.steroidAmount = Decimal.Parse(steroidAmountBox.Text);
doctorSetup.otherEquipment = otherEquipmentBox.Text;
doctorSetup.comments = commentsBox.Text;
setupContext.SubmitChanges();
Form1.DoctorProceduresList.Clear();
Form1.GetDoctorsProcedures();
MessageBox.Show("Updated", "Setup",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DoctorsProcedure setup = new DoctorsProcedure();
try
{
setup.doctorName = doctorBox.Text;
setup.doctorID = doctor.doctorID;
setup.gloveSize = doctor.gloveSize;
setup.procedureName = procedureBox.Text;
setup.modality = modalityBox.Text;
setup.patientOrientation = patientOrientationBox.Text;
setup.ifBilateral = ifBilateralBox.Text;
setup.syringes1mL = Decimal.Parse(syringes1mLBox.Text);
setup.syringes3mL = Decimal.Parse(syringes3mLBox.Text);
setup.syringes5mL = Decimal.Parse(syringes5mLBox.Text);
setup.syringes10mL = Decimal.Parse(syringes10mLBox.Text);
setup.needleDrawingUp = Decimal.Parse(needleDrawingUpBox.Text);
setup.needle25g = Decimal.Parse(needle25gBox.Text);
setup.needle19g = Decimal.Parse(needle19gBox.Text);
setup.needle22g50mm = Decimal.Parse(needle22g50mmBox.Text);
setup.needle22g90mm = Decimal.Parse(needle22g90mmBox.Text);
setup.contrast = contrastBox.Text;
setup.lignocaine = Decimal.Parse(lignocaineBox.Text);
setup.bupivacaine = Decimal.Parse(bupivacaineBox.Text);
setup.steroidType = steroidTypeBox.Text;
setup.steroidAmount = Decimal.Parse(steroidAmountBox.Text);
setup.otherEquipment = otherEquipmentBox.Text;
setup.comments = commentsBox.Text;
setupContext.DoctorsProcedures.InsertOnSubmit(setup);
setupContext.SubmitChanges();
Form1.DoctorProceduresList.Clear();
Form1.GetDoctorsProcedures();
MessageBox.Show("Added", "Setup",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Please make sure all fields are filled out correctly...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Please select a doctor and procedure...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
partial void DeleteDoctorsProcedure(DoctorsProcedure instance);
partial void UpdateDoctorsProcedure(DoctorsProcedure instance);
partial void InsertDoctorsProcedure(DoctorsProcedure instance);
partial void DeleteDoctorsProcedure(DoctorsProcedure instance);
partial void UpdateDoctorsProcedure(DoctorsProcedure instance);
partial void InsertDoctorsProcedure(DoctorsProcedure instance);