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(); } } } }