private void DeleteGroup(object sender, EventArgs e) { Messages msg = new Messages(); conn.Open(); iin = TextIIN.Text; if (TextIIN.Text == "") { msg.DataError("Заполните ИИН!"); } else { sql = "UPDATE PERSON SET SOCIAL_GROUP_ID_SOCIAL_GROUP = NULL WHERE PERSON_IIN = '" + iin + "'"; MySqlCommand upd2 = new MySqlCommand(sql, conn); if (upd2.ExecuteNonQuery() == 1) { msg.DropSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.DropSuccess(); conn.Close(); } } }
private void AddGroupToPerson(object sender, EventArgs e) { Messages msg = new Messages(); iin = TextIIN.Text; if (TextIIN.Text == "" | CBSetGroup.Text == "") { msg.DataError("Заполните данные!"); } else { conn.Open(); sql = "SELECT ID_SOCIAL_GROUP FROM SOCIAL_GROUP WHERE SOCIAL_GROUP = '" + CBSetGroup.Text + "'"; MySqlCommand sgid = new MySqlCommand(sql, conn); sg = Convert.ToInt32(sgid.ExecuteScalar()); sql = "UPDATE EMEDICINE.PERSON SET SOCIAL_GROUP_ID_SOCIAL_GROUP = " + sg + " WHERE PERSON_IIN = '" + iin + "'"; MySqlCommand upd1 = new MySqlCommand(sql, conn); if (upd1.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.WriteError(); conn.Close(); } } }
private void Exit(object sender, EventArgs e) { this.Close(); conn.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); }
private void SetMedicineToPerson(object sender, EventArgs e) { iin = TextIIN.Text; Messages msg = new Messages(); if (CBSetType.Text == "") { msg.DataError("Выберите тип препарата!"); CBSetType.Focus(); } else if (TextIIN.Text.Length != 12) { msg.DataError("Введите корректный ИИН!"); TextIIN.Focus(); } else if (CBSetCategory.Text == "") { msg.DataError("Выберите категорию препарата!"); CBSetCategory.Focus(); } else if (CBSetGroup.Text == "") { msg.DataError("Выберите группу препарата!"); CBSetGroup.Focus(); } else if (CBSetName.Text == "") { msg.DataError("Выберите название препарата!"); CBSetName.Focus(); } else { conn.Open(); sql = "SELECT COUNT(*) " + "FROM PERSON_HAS_DOCTOR " + "WHERE PERSON_HAS_DOCTOR.PERSON_PERSON_IIN = '" + iin + "' " + "AND PERSON_HAS_DOCTOR.DOCTOR_ID_DOCTOR = " + did + ""; MySqlCommand checkperson = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(checkperson.ExecuteScalar()); if (COUNT == 0) { msg.DataError("Невозможно назначить препарат!"); conn.Close(); } else { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName.Text + "' "; MySqlCommand medicineid = new MySqlCommand(sql, conn); mid = Convert.ToInt32(medicineid.ExecuteScalar()); switch (CBSetType.SelectedIndex) { case 0: sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG WHERE MEDICINE_ID_MEDICINE = " + mid + ""; MySqlCommand recmed = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(recmed.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT COUNT(*) FROM RECOMMENDED_DRUG " + "WHERE MEDICINE_ID_MEDICINE = " + mid + " AND PERSON_PERSON_IIN = " + iin + ""; MySqlCommand checkmed = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(checkmed.ExecuteScalar()); if (COUNT == 0) { sql = "INSERT INTO RECOMMENDED_DRUG ( PERSON_PERSON_IIN, MEDICINE_ID_MEDICINE) " + "VALUES ('" + iin + "', " + mid + ")"; MySqlCommand insrecmed = new MySqlCommand(sql, conn); if (insrecmed.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.WriteError(); conn.Close(); } } else { msg.DataError("Запись уже существует!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } break; case 1: sql = "SELECT COUNT(*) FROM RECOMMENDED_DRUG WHERE MEDICINE_ID_MEDICINE = " + mid + ""; MySqlCommand formed = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(formed.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE MEDICINE_ID_MEDICINE = " + mid + " AND PERSON_PERSON_IIN = " + iin + ""; MySqlCommand checkmed = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(checkmed.ExecuteScalar()); if (COUNT == 0) { sql = "INSERT INTO FORBIDDEN_DRUG (MEDICINE_ID_MEDICINE, PERSON_PERSON_IIN) " + "VALUES (" + mid + ",'" + iin + "')"; MySqlCommand insrformed = new MySqlCommand(sql, conn); if (insrformed.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); } else { msg.WriteError(); conn.Close(); } } else { msg.DataError("Запись уже существует!"); 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(); } } } }
private void SetPrescription(object sender, EventArgs e) { Messages msg = new Messages(); iin = TextIIN.Text; conn.Open(); switch (sw) { case 1: if (CBSetName1.Text == "") { msg.DataError("Заполните данные!"); } else { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName1.Text + "'"; MySqlCommand med1 = new MySqlCommand(sql, conn); m1 = Convert.ToInt32(med1.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m1 + ""; MySqlCommand c1 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c1.ExecuteScalar()); if (COUNT == 0) { sql = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m1 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr1 = new MySqlCommand(sql, conn); if (inspr1.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } break; case 2: if (CBSetName1.Text == CBSetName2.Text) { msg.DataError("Данные совпадают!"); } else if (CBSetName1.Text == "" | CBSetName2.Text == "") { msg.DataError("Заполните данные!"); } else { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName1.Text + "'"; MySqlCommand med1 = new MySqlCommand(sql, conn); m1 = Convert.ToInt32(med1.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m1 + ""; MySqlCommand c1 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c1.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName2.Text + "'"; MySqlCommand med2 = new MySqlCommand(sql, conn); m2 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m2 + ""; MySqlCommand c2 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c2.ExecuteScalar()); if (COUNT == 0) { sqlins1 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m1 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr1 = new MySqlCommand(sqlins1, conn); sqlins2 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m2 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr2 = new MySqlCommand(sqlins2, conn); if (inspr1.ExecuteNonQuery() == 1) { if (inspr2.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } break; case 3: if (CBSetName1.Text == CBSetName2.Text | CBSetName1.Text == CBSetName3.Text | CBSetName3.Text == CBSetName2.Text) { msg.DataError("Данные совпадают!"); } else if (CBSetName1.Text == "" | CBSetName2.Text == "" | CBSetName3.Text == "") { msg.DataError("Заполните данные!"); } else { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName1.Text + "'"; MySqlCommand med1 = new MySqlCommand(sql, conn); m1 = Convert.ToInt32(med1.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m1 + ""; MySqlCommand c1 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c1.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName2.Text + "'"; MySqlCommand med2 = new MySqlCommand(sql, conn); m2 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m2 + ""; MySqlCommand c2 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c2.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName3.Text + "'"; MySqlCommand med3 = new MySqlCommand(sql, conn); m3 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m3 + ""; MySqlCommand c3 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c3.ExecuteScalar()); if (COUNT == 0) { sqlins1 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m1 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr1 = new MySqlCommand(sqlins1, conn); sqlins2 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m2 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr2 = new MySqlCommand(sqlins2, conn); sqlins3 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m3 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr3 = new MySqlCommand(sqlins3, conn); if (inspr1.ExecuteNonQuery() == 1) { if (inspr2.ExecuteNonQuery() == 1) { if (inspr3.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } break; case 4: if (CBSetName1.Text == CBSetName2.Text | CBSetName1.Text == CBSetName3.Text | CBSetName1.Text == CBSetName4.Text | CBSetName2.Text == CBSetName3.Text | CBSetName2.Text == CBSetName4.Text | CBSetName3.Text == CBSetName4.Text) { msg.DataError("Данные совпадают!"); } else if (CBSetName1.Text == "" | CBSetName2.Text == "" | CBSetName3.Text == "" | CBSetName4.Text == "") { msg.DataError("Заполните данные!"); } else { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName1.Text + "'"; MySqlCommand med1 = new MySqlCommand(sql, conn); m1 = Convert.ToInt32(med1.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m1 + ""; MySqlCommand c1 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c1.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName2.Text + "'"; MySqlCommand med2 = new MySqlCommand(sql, conn); m2 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m2 + ""; MySqlCommand c2 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c2.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName3.Text + "'"; MySqlCommand med3 = new MySqlCommand(sql, conn); m3 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m3 + ""; MySqlCommand c3 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c3.ExecuteScalar()); if (COUNT == 0) { sql = "SELECT ID_MEDICINE FROM DRUG WHERE DRUG_NAME = '" + CBSetName4.Text + "'"; MySqlCommand med4 = new MySqlCommand(sql, conn); m4 = Convert.ToInt32(med2.ExecuteScalar()); sql = "SELECT COUNT(*) FROM FORBIDDEN_DRUG " + "WHERE PERSON_PERSON_IIN = '" + iin + "' " + "AND MEDICINE_ID_MEDICINE = " + m4 + ""; MySqlCommand c4 = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(c4.ExecuteScalar()); if (COUNT == 0) { sqlins1 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m1 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr1 = new MySqlCommand(sqlins1, conn); sqlins2 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m2 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr2 = new MySqlCommand(sqlins2, conn); sqlins3 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m3 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr3 = new MySqlCommand(sqlins3, conn); sqlins4 = "INSERT INTO PRESCRIPTION (MEDICINE_ID_MEDICINE, PRESCRIPTION_DATE_START, PERSON_PERSON_IIN, DOCTOR_ID_DOCTOR) " + "VALUES (" + m4 + ",'" + date + "', '" + iin + "', " + did + ")"; MySqlCommand inspr4 = new MySqlCommand(sqlins4, conn); if (inspr1.ExecuteNonQuery() == 1) { if (inspr2.ExecuteNonQuery() == 1) { if (inspr3.ExecuteNonQuery() == 1) { if (inspr4.ExecuteNonQuery() == 1) { msg.WriteSuccess(); this.Close(); DoctorMode doctorMode = new DoctorMode(did); doctorMode.Show(); conn.Close(); } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Создание рецепта не удалось!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } else { msg.DataError("Ошибка совместимости!"); conn.Close(); } } break; } }
private void Login(object sender, EventArgs e) { Messages msg = new Messages(); AdminMainForm amf; amf = new AdminMainForm(); MainForm mainForm = new MainForm(); switch (sw) { case 0: sql = "SELECT COUNT(*) FROM INFO WHERE INFO_LOGIN = '******'"; MySqlCommand querycheckadm = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(querycheckadm.ExecuteScalar()); if (COUNT == 0) { msg.DataError("Логин и/или пароль неверный"); } else { sql = "SELECT ID_INFO FROM INFO WHERE INFO_LOGIN = '******'"; MySqlCommand queryidadm = new MySqlCommand(sql, conn); id = (int)queryidadm.ExecuteScalar(); sql = "SELECT INFO_PASSWORD FROM INFO WHERE ID_INFO = '" + id + "'"; MySqlCommand querypasswordadm = new MySqlCommand(sql, conn); password = querypasswordadm.ExecuteScalar().ToString(); if (TextPassword.Text == password) { this.Close(); amf.Show(); TextLogin.Text = ""; TextPassword.Text = ""; conn.Close(); } else { msg.DataError("Логин и/или пароль неверный"); } } break; case 1: sql = "SELECT COUNT(*) FROM PERSON WHERE PERSON_IIN = '" + TextLogin.Text + "'"; MySqlCommand querycheckperson = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(querycheckperson.ExecuteScalar()); if (COUNT == 0) { MessageBox.Show("Логин и/или пароль неверный", "Ошибка входа", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { sql = "SELECT PERSON_PASSWORD FROM PERSON WHERE PERSON_IIN = '" + TextLogin.Text + "'"; MySqlCommand querypasswordperson = new MySqlCommand(sql, conn); password = querypasswordperson.ExecuteScalar().ToString(); if (TextPassword.Text == password) { login = TextLogin.Text; PersonMode person = new PersonMode(login); person.Show(); this.Close(); conn.Close(); } else { msg.DataError("Логин и/или пароль неверный"); } } break; case 2: sql = "SELECT COUNT(*) FROM DOCTOR WHERE DOC_IIN = '" + TextLogin.Text + "'"; MySqlCommand querycheckdoc = new MySqlCommand(sql, conn); COUNT = Convert.ToInt32(querycheckdoc.ExecuteScalar()); if (COUNT == 0) { msg.DataError("Логин и/или пароль неверный"); } else { sql = "SELECT ID_DOCTOR FROM DOCTOR WHERE DOC_IIN = '" + TextLogin.Text + "'"; MySqlCommand queryiddoc = new MySqlCommand(sql, conn); id = (int)queryiddoc.ExecuteScalar(); sql = "SELECT DOC_PASSWORD FROM DOCTOR WHERE ID_DOCTOR = '" + id + "'"; MySqlCommand querypassworddoc = new MySqlCommand(sql, conn); password = querypassworddoc.ExecuteScalar().ToString(); if (TextPassword.Text == password) { DoctorMode doctor = new DoctorMode(id); doctor.Show(); this.Close(); conn.Close(); } else { msg.DataError("Логин и/или пароль неверный"); } } break; } }