private void информацияОНедвижимостиToolStripMenuItem_Click(object sender, EventArgs e)
{
property prty = new property();
prty.Show();
this.Close();
}
private void ИнформацияОНедвижимости_Click(object sender, EventArgs e)
{
property prty = new property();
prty.Show();
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
property property = new property();
property.Show();
}
public void loadDataGridView() //пользовательская функция для вывода dataGridView
{
property form2 = new property();
form2.dataGridView1.DataSource = null;
PublicClasses.sql = "select idProperty, concat(type.type, ' ', typeproperty.typeProperty) as 'Тип Недвижимости', cities.city as 'Город', areas.area as 'Область', district.district as 'Район', undergroundstations.undergroundStation as 'ст. Метро', if(property.buyRent=1,'Продажy','Арендy') as 'Выставлен на' " +
"from property " +
"left join type on property.type = type.idType " +
"left join typeproperty on type.idTypeProperty = typeproperty.idTypeProperty " +
"left join cities on property.idCity = cities.idCity " +
"left join areas on property.idArea = areas.idArea " +
"left join district on property.idDistrict = district.idDistrict " +
"left join undergroundstations on property.idUndergroundStation = undergroundstations.idUndergroundStation " +
"where isRemoveBuyRent<>1";
form2.dataGridView1.DataSource = PublicClasses.executeSqlRequest().Tables[0];
form2.dataGridView1.Columns[0].Visible = false;
form2.dataGridView1.Columns[1].HeaderText = "Тип недвижимости";
form2.dataGridView1.Columns[2].HeaderText = "Город";
form2.dataGridView1.Columns[3].HeaderText = "Область";
form2.dataGridView1.Columns[4].HeaderText = "Район";
form2.dataGridView1.Columns[5].HeaderText = "Ст. метро";
form2.dataGridView1.Columns[6].HeaderText = "Выставлен на";
form2.Show();
}
private void button2_Click(object sender, EventArgs e) //вход в ситему
{
bool l = false, l1 = false;
property form2 = new property();
if (string.IsNullOrWhiteSpace(textBox1.Text))
{
errorProvider1.SetError(textBox1, "Поле не должно быть пустым");
}
else
{
l = true;
}
if (string.IsNullOrWhiteSpace(textBox2.Text))
{
errorProvider1.SetError(textBox2, "Поле не должно быть пустым");
}
else
{
l = true;
}
//if (string.IsNullOrWhiteSpace(textBox3.Text)) { errorProvider1.SetError(textBox3, "Введите капчу"); } else { l = true; }
if (l)
{
PublicClasses.sql = "call checkPassword('" + textBox1.Text + "','" + textBox2.Text + "')";
try
{
PublicClasses.executeSqlRequest();
l1 = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Окно предупреждения", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (l1)
{
try
{
PublicClasses.sql = "select * from autorization_datas where login='******' and password='******';";
PublicClasses.idUser = PublicClasses.executeSqlRequest().Tables[0].Rows[0].ItemArray[0].ToString();
PublicClasses.UserLogin = PublicClasses.executeSqlRequest().Tables[0].Rows[0].ItemArray[1].ToString();
if (PublicClasses.executeSqlRequest().Tables[0].Rows.Count == 0 /*|| captcha!=textBox3.Text*/)
{
MessageBox.Show("Ой что-то пошло не так. Попробуйте заполнить поля снова.", "Окно предупреждения", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PublicClasses.sql = "select * from persons where idUser="******"";
if (PublicClasses.executeSqlRequest().Tables[0].Rows.Count != 0)
{
PublicClasses.privelege = 2;
}
else
{
PublicClasses.privelege = 1;
}
if (textBox1.Text == "admin" && textBox2.Text == "admin")
{
PublicClasses.privelege = 3;
}
this.Hide();
form2.Show();
}
PublicClasses.writeToFileUser(checkBox1);
}
catch (Exception ex) { MessageBox.Show("Неправильные пароль или логин.", "Вход в систему", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
}
}