private void CreateNewRecord(object sender, EventArgs e)
{
Messages msg = new Messages();
AdminMainForm amf = new AdminMainForm();
if (CBCity.Text == "")
{
msg.DataError("Выберите город!");
CBCity.Focus();
}
else if (CBCountry.Text == "")
{
msg.DataError("Выберите страну!");
CBCountry.Focus();
}
else if (CBRegion.Text == "")
{
msg.DataError("Выберите регион!");
CBRegion.Focus();
}
else if (CBSetClinic.Text == "")
{
msg.DataError("Выберите поликлинику!");
CBSetClinic.Focus();
}
else
{
conn.Open();
sql = "SELECT ID_CLINIC FROM CLINIC WHERE CLINIC_NAME = '" + CBSetClinic.Text + "'";
MySqlCommand clinicid = new MySqlCommand(sql, conn);
cid = Convert.ToInt32(clinicid.ExecuteScalar());
switch (sw)
{
case 0:
sql = "SELECT COUNT(*) " +
"FROM CLINIC_HAS_PERSON " +
"WHERE PERSON_PERSON_IIN = '" + TextIIN.Text + "' AND " +
"CLINIC_ID_CLINIC = " + cid + "";
MySqlCommand pcheck = new MySqlCommand(sql, conn);
COUNT = Convert.ToInt32(pcheck.ExecuteScalar());
if (COUNT == 0)
{
sql = "INSERT INTO CLINIC_HAS_PERSON " +
"(PERSON_PERSON_IIN, CLINIC_ID_CLINIC) " +
"VALUES ('" + TextIIN.Text + "'," + cid + ")";
MySqlCommand pins = new MySqlCommand(sql, conn);
if (pins.ExecuteNonQuery() == 1)
{
msg.WriteSuccess();
this.Close();
amf.Show();
conn.Close();
}
else
{
msg.WriteError();
conn.Close();
}
}
else
{
msg.DataError("Запись уже существует в базе данных!");
conn.Close();
}
break;
case 1:
sql = "SELECT ID_DOCTOR FROM DOCTOR WHERE DOC_IIN = '" + TextIIN.Text + "'";
MySqlCommand dociin = new MySqlCommand(sql, conn);
did = Convert.ToInt32(dociin.ExecuteScalar());
sql = "SELECT COUNT(*) " +
"FROM CLINIC_HAS_DOCTOR " +
"WHERE DOCTOR_ID_DOCTOR = " + did + " AND " +
"CLINIC_ID_CLINIC = " + cid + "";
MySqlCommand dcheck = new MySqlCommand(sql, conn);
COUNT = Convert.ToInt32(dcheck.ExecuteScalar());
if (COUNT == 0)
{
sql = "INSERT INTO CLINIC_HAS_DOCTOR " +
"(DOCTOR_ID_DOCTOR, CLINIC_ID_CLINIC) " +
"VALUES (" + did + " ," + cid + ")";
MySqlCommand dins = new MySqlCommand(sql, conn);
if (dins.ExecuteNonQuery() == 1)
{
msg.WriteSuccess();
this.Close();
amf.Show();
conn.Close();
}
else
{
msg.WriteError();
conn.Close();
}
}
else
{
msg.DataError("Запись уже существует в базе данных!");
conn.Close();
}
break;
}
}
}
private void AddNewRecord(object sender, EventArgs e)
{
Messages msg = new Messages();
if (CBSetClinic.Text == "")
{
msg.DataError("Выберите поликлинику!");
CBSetClinic.Focus();
}
else if (TextIIN.Text == "")
{
msg.DataError("Введите ИИН!");
TextIIN.Focus();
}
else
{
conn.Open();
sql = "SELECT COUNT(*) " +
"FROM PERSON WHERE PERSON_IIN = '" + TextIIN.Text + "' ";
MySqlCommand check = new MySqlCommand(sql, conn);
COUNT = Convert.ToInt32(check.ExecuteScalar());
if (COUNT == 0)
{
msg.DataError("Пациент не найден в базе данных!");
conn.Close();
}
else
{
sql = "SELECT COUNT(*) " +
"FROM PERSON_HAS_DOCTOR " +
"WHERE PERSON_PERSON_IIN = '" + TextIIN.Text + "' " +
"AND CLINIC_ID_CLINIC = " + cid + " " +
"AND DOCTOR_ID_DOCTOR = " + did + "";
MySqlCommand checkpc = new MySqlCommand(sql, conn);
COUNT = Convert.ToInt32(checkpc.ExecuteScalar());
if (COUNT == 0)
{
sql = "INSERT INTO PERSON_HAS_DOCTOR (PERSON_PERSON_IIN, CLINIC_ID_CLINIC, DOCTOR_ID_DOCTOR) " +
"VALUES ('" + TextIIN.Text + "'," + cid + ", " + did + ")";
MySqlCommand ins = new MySqlCommand(sql, conn);
if (ins.ExecuteNonQuery() == 1)
{
msg.WriteSuccess();
this.Close();
conn.Close();
DoctorMode doctorMode = new DoctorMode(did);
doctorMode.Show();
}
else
{
msg.WriteError();
conn.Close();
}
}
else
{
msg.DataError("Запись уже существует в базе данных!");
conn.Close();
}
}
}
}
