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();
}
}
}
private void CreateNewClinic(object sender, EventArgs e)
{
Messages msg = new Messages();
if (TextNameClPh.Text == "")
{
msg.DataError("Введите название!");
TextNameClPh.Focus();
}
else if (TextZipClPh.Text == "")
{
msg.DataError("Введите почтовый индекс!");
TextZipClPh.Focus();
}
else 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 (TextStreetClPh.Text == "")
{
msg.DataError("Введите улицу!");
TextStreetClPh.Focus();
}
else if (TextBuildingClPh.Text == "")
{
msg.DataError("Введите номер строения!");
TextBuildingClPh.Focus();
}
else if (TextPhoneClPh.Text == "")
{
msg.DataError("Введите номер телефона!");
TextPhoneClPh.Focus();
}
else
{
conn.Open();
sql = "SELECT ID_CITY FROM CITY WHERE CITY ='" + CBCity.Text + "'";
MySqlCommand cid = new MySqlCommand(sql, conn);
cityid = Convert.ToInt32(cid.ExecuteScalar());
}
sql = "SELECT COUNT(*) FROM CLINIC WHERE CLINIC_NAME = '" + TextNameClPh.Text + "'";
MySqlCommand querycheckcl = new MySqlCommand(sql, conn);
COUNT = Convert.ToInt32(querycheckcl.ExecuteScalar());
if (COUNT == 0)
{
sql = "INSERT INTO CLINIC (CLINIC_NAME, " +
"CITY_ID_CITY, " +
"CLINIC_ZIP_CODE, " +
"CLINIC_STREET, " +
"CLINIC_BUILDING) " +
"VALUES ('" + TextNameClPh.Text + "', " +
"" + cityid + "," +
" '" + TextZipClPh.Text + "'," +
" '" + TextStreetClPh.Text + "'," +
" '" + TextBuildingClPh.Text + "')";
MySqlCommand cmdcl = new MySqlCommand(sql, conn);
if (cmdcl.ExecuteNonQuery() == 1)
{
sql = "SELECT ID_CLINIC FROM CLINIC WHERE CLINIC_NAME = '" + TextNameClPh.Text + "'";
MySqlCommand clquery = new MySqlCommand(sql, conn);
id = (int)clquery.ExecuteScalar();
sql = "INSERT INTO CLINIC_PHONE (CLINIC_PHONE, CLINIC_ID_CLINIC) VALUES ('" + TextPhoneClPh.Text + "', " + id + ")";
MySqlCommand clphone = new MySqlCommand(sql, conn);
if (clphone.ExecuteNonQuery() == 1)
{
msg.WriteSuccess();
this.Close();
AdminMainForm amf = new AdminMainForm();
amf.Show();
conn.Close();
}
else
{
msg.WriteError();
conn.Close();
}
}
else
{
msg.WriteError();
conn.Close();
}
}
else
{
msg.DataError("Такое медицинское учреждение уже существует!");
conn.Close();
}
}
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;
}
}
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;
}
}
}
}