Esempio n. 1
0
        private void CheckUser(object sender, EventArgs e)
        {
            Messages msg = new Messages();

            if (TextIIN.Text == "")
            {
                msg.DataError("Введите ИИН!");
                TextIIN.Focus();
            }
            conn.Open();
            switch (sw)
            {
            case 0:
                sql = "SELECT COUNT(*) FROM PERSON WHERE PERSON_IIN = '" + TextIIN.Text + "'";
                MySqlCommand checkp = new MySqlCommand(sql, conn);
                COUNT = Convert.ToInt32(checkp.ExecuteScalar());
                break;

            case 1:
                sql = "SELECT COUNT(*) FROM DOCTOR WHERE DOC_IIN = '" + TextIIN.Text + "'";
                MySqlCommand checkd = new MySqlCommand(sql, conn);
                COUNT = Convert.ToInt32(checkd.ExecuteScalar());
                break;
            }
            if (COUNT == 1)
            {
                PanelClinic.Visible = true;
            }
            else
            {
                msg.DataError("Пользователя нет в базе!");
            }
            conn.Close();
        }
Esempio n. 2
0
        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;
                    }
                }
            }
        }
Esempio n. 3
0
        private void CreateNewDoctor(object sender, EventArgs e)
        {
            Messages msg = new Messages();

            if (TextLastName.Text == "")
            {
                msg.DataError("Введите фамилию!");
                TextLastName.Focus();
            }
            else if (TextFirstName.Text == "")
            {
                msg.DataError("Введите имя!");
                TextFirstName.Focus();
            }
            else if (TextIIN.Text.Length != 12)
            {
                msg.DataError("Введите корректный ИИН!");
                TextIIN.Focus();
            }
            else if (TextEmail.Text == "")
            {
                msg.DataError("Введите адрес электронной почты!");
                TextEmail.Focus();
            }
            else if (TextPhone.Text == "")
            {
                msg.DataError("Введите номер телефона!");
                TextPhone.Focus();
            }
            else if (TextPassword.Text == "")
            {
                msg.DataError("Введите пароль!");
                TextPassword.Focus();
            }
            else if (TextPassword.Text != TextRepPassword.Text)
            {
                msg.DataError("Пароли не совпадают!");
                TextPassword.Focus();
            }
            else if (CBSetSpec.Text == "")
            {
                msg.DataError("Выберите специализацию!");
                CBSetSpec.Focus();
            }
            else
            {
                conn.Open();
                sql = "SELECT COUNT(*) FROM DOCTOR WHERE DOC_EMAIL = '" + TextEmail.Text + "'";
                MySqlCommand checkEmail = new MySqlCommand(sql, conn);
                COUNT = Convert.ToInt32(checkEmail.ExecuteScalar());
                if (COUNT == 0)
                {
                    sql = "SELECT COUNT(*) FROM DOCTOR WHERE DOC_IIN = '" + TextIIN.Text + "'";
                    MySqlCommand checkIIN = new MySqlCommand(sql, conn);
                    COUNT = Convert.ToInt32(checkIIN.ExecuteScalar());
                    if (COUNT == 0)
                    {
                        sql = "INSERT INTO DOCTOR (DOC_LASTNAME, " +
                              "DOC_FIRSTNAME, " +
                              "DOC_PATRONYMIC, " +
                              "DOC_IIN, " +
                              "DOC_EMAIL, " +
                              "DOC_PHONE, " +
                              "DOC_PASSWORD, " +
                              "SPECIALISATION_ID_SPEC) " +
                              "VALUES ('" + TextLastName.Text + "', " +
                              "'" + TextFirstName.Text + "', " +
                              "'" + TextPatronymic.Text + "', " +
                              "'" + TextIIN.Text + "', " +
                              "'" + TextEmail.Text + "', " +
                              "'" + TextPhone.Text + "', " +
                              "'" + TextPassword.Text + "', " +
                              "" + idspec + ")";
                        MySqlCommand insdoc = new MySqlCommand(sql, conn);
                        if (insdoc.ExecuteNonQuery() == 1)
                        {
                            msg.WriteSuccess();
                            this.Close();
                            AdminMainForm amf = new AdminMainForm();
                            amf.Show();
                            conn.Close();
                        }
                        else
                        {
                            msg.WriteError();
                            conn.Close();
                        }
                    }
                    else
                    {
                        msg.DataError("ИИН уже существует в системе!");
                        conn.Close();
                    }
                }
                else
                {
                    msg.DataError("Электронный адрес уже существует в системе!");
                    conn.Close();
                }
            }
        }
Esempio n. 4
0
        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();
                    }
                }
            }
        }
Esempio n. 5
0
        private void CreateNewPerson(object sender, EventArgs e)
        {
            Messages msg = new Messages();

            if (TextLastName.Text == "")
            {
                msg.DataError("Введите фамилию!");
                TextLastName.Focus();
            }
            else if (TextFirstName.Text == "")
            {
                msg.DataError("Введите имя!");
                TextFirstName.Focus();
            }
            else if (SexSet.Text == "")
            {
                msg.DataError("Выберите пол!");
                SexSet.Focus();
            }
            else if (TextIIN.Text.Length != 12)
            {
                msg.DataError("Введите корректный ИИН!");
                TextIIN.Focus();
            }
            else if (TextEmail.Text == "")
            {
                msg.DataError("Введите адрес электронной почты!");
                TextEmail.Focus();
            }
            else if (TextPhone.Text == "")
            {
                msg.DataError("Введите номер телефона!");
                TextPhone.Focus();
            }
            else if (TextPassword.Text == "")
            {
                msg.DataError("Введите пароль!");
                TextPassword.Focus();
            }
            else if (TextPassword.Text != TextRepPassword.Text)
            {
                msg.DataError("Пароли не совпадают!");
                TextPassword.Focus();
            }
            else
            {
                conn.Open();
                sqlins = "INSERT INTO PERSON (PERSON_LASTNAME, " +
                         "PERSON_FIRSTNAME, " +
                         "PERSON_PATRONYMIC, " +
                         "PERSON_BIRTHDAY, " +
                         "PERSON_IIN, " +
                         "PERSON_PASSWORD, " +
                         "PERSON_EMAIL, " +
                         "PERSON_SEX, " +
                         "PERSON_PHONE) " +
                         "VALUES ('" + TextLastName.Text + "', " +
                         "'" + TextFirstName.Text + "', " +
                         "'" + TextPatronymic.Text + "', " +
                         "'" + this.BirthdaySet.Text + "', " +
                         "'" + TextIIN.Text + "', " +
                         "'" + TextPassword.Text + "', " +
                         "'" + TextEmail.Text + "', " +
                         "'" + SexSet.Text + "'," +
                         "'" + TextPhone.Text + "')";

                sql = "SELECT COUNT(*) FROM PERSON WHERE PERSON_EMAIL = '" + TextEmail.Text + "'";
                MySqlCommand checkEmail = new MySqlCommand(sql, conn);
                COUNT = Convert.ToInt32(checkEmail.ExecuteScalar());
                if (COUNT == 0)
                {
                    sql = "SELECT COUNT(*) FROM PERSON WHERE PERSON_IIN = '" + TextIIN.Text + "'";
                    MySqlCommand checkIIN = new MySqlCommand(sql, conn);
                    COUNT = Convert.ToInt32(checkIIN.ExecuteScalar());
                    if (COUNT == 0)
                    {
                        MySqlCommand cmd = new MySqlCommand(sqlins, conn);
                        if (cmd.ExecuteNonQuery() == 1)
                        {
                            msg.WriteSuccess();
                            this.Close();
                            AdminMainForm amf = new AdminMainForm();
                            amf.Show();
                            conn.Close();
                        }
                        else
                        {
                            msg.WriteError();
                            conn.Close();
                        }
                    }
                    else
                    {
                        msg.DataError("Номер документа уже существует в системе!");
                        conn.Close();
                        COUNT = 0;
                    }
                }
            }
        }