private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString());
try
{
sqlConnection.Open();
if (textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "")
{
DateTime date1 = DateTime.Now;
DateTime date2 = date1.AddDays(Convert.ToInt32(textBox4.Text));
String date1s = "";
String date2s = "";
date1s += date1.Year + "-0" + date1.Month + "-" + date1.Day + "T00:00:00.000";
date2s += date2.Year + "-0" + date2.Month + "-0" + date2.Day + "T00:00:00.000";
SqlCommand sqlCommand = new SqlCommand("INSERT INTO [Emploer] (Name_emploer, password_emploer, role_emploer, date_in_System,date_out_System,block_,[count]) VALUES ('" + textBox2.Text + "','" + textBox3.Text + "', 0,'" + date1s + "','" + date2s + "',0,0)", sqlConnection);
sqlCommand.ExecuteReader();
this.Hide();
new Form1().Show();
}
else
{
MessageBox.Show("Заполните данные");
}
sqlConnection.Close();
}
catch (SqlException err)
{
Console.WriteLine(err.ToString(), "Error");
}
}
public static DataTable getTable(string sql)
{
using (SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString()))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, sqlConnection))
{
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
return(dataTable);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString());
sqlConnection.Open();
if (textBox1.Text != "" && textBox2.Text != "")
{
SqlCommand sqlCommand = new SqlCommand("update [Emploer] set [password_emploer]='" + textBox1.Text + "',[LastName_emploer] = '" + textBox2.Text + "' where ID_Emploer =" + User.ID_user + ";", sqlConnection);
sqlCommand.ExecuteNonQuery();
this.Hide();
new Form1().Show();
}
else
{
MessageBox.Show("Заполните данные");
}
}
private void Form3_Load(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString());
sqlConnection.Open();
SqlCommand comand = new SqlCommand("select * from [Emploer] where ID_Emploer =" + User.ID_user + ";", sqlConnection);
SqlDataReader reader;
reader = comand.ExecuteReader();
if (reader.Read())
{
textBox1.Text = reader["password_emploer"].ToString();
textBox2.Text = reader["LastName_emploer"].ToString();
}
else
{
MessageBox.Show("Текущго пользователя не существует");
}
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString());
SqlDataReader reader;
try
{
sqlConnection.Open();
SqlCommand comand = new SqlCommand("select * from [Emploer] where [Name_emploer] = '" + textBox1.Text + "'", sqlConnection);
reader = comand.ExecuteReader();
if (textBox1.Text != "")
{
if (reader.Read())
{
reader.Close();
SqlCommand sqlCommand = new SqlCommand("update [Emploer] set [block_]=0, count=0 where [Name_emploer] = '" + textBox1.Text + "'", sqlConnection);
sqlCommand.ExecuteReader();
this.Hide();
new Form1().Show();
}
else
{
MessageBox.Show("Такого пользователя не существует");
}
}
else
{
MessageBox.Show("Заполните данные");
}
sqlConnection.Close();
}
catch (SqlException err)
{
Console.WriteLine(err.ToString(), "Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(DataSourseString.getString());
SqlDataReader reader;
try
{
sqlConnection.Open();
SqlCommand comand = new SqlCommand("select * from [Emploer] where [Name_emploer] = '" + textBox1.Text + "';", sqlConnection);
reader = comand.ExecuteReader();
if (textBox1.Text != "" && textBox2.Text != "")
{
if (reader.Read())
{
String pas = reader["password_emploer"].ToString();
User.ID_user = Convert.ToInt32(reader["ID_Emploer"].ToString());
if (pas == textBox2.Text)
{
User.role = Convert.ToInt32(reader["role_emploer"]);
if (User.role == 1)
{
this.Hide();
new Form2().Show();
}
else
{
int block = Convert.ToInt32(reader["block_"].ToString());
if (block == 0)
{
DateTime dateIn = Convert.ToDateTime(reader["date_in_System"]);
DateTime dateOut = Convert.ToDateTime(reader["date_out_System"]);
if (DateTime.Now.CompareTo(dateIn) >= 0 && DateTime.Now.CompareTo(dateOut) <= 0)
{
if ((Convert.ToInt32(DateTime.Now.Day) % 2 == 0 && User.ID_user % 2 == 0) || (Convert.ToInt32(DateTime.Now.Day) % 2 == 1 && User.ID_user % 2 == 1))
{
this.Hide();
new Form3().Show();
}
else
{
MessageBox.Show("Error", "Сегодня вы не можете войти");
}
}
else
{
if (DateTime.Now.CompareTo(dateIn) < 0)
{
MessageBox.Show("Error", "Аккаунт еще не доступен");
}
else
{
reader.Close();
SqlCommand sqlCommand = new SqlCommand("update [Emploer] set [block_]=1 where ID_Emploer =" + User.ID_user + ";", sqlConnection);
sqlCommand.ExecuteNonQuery();
MessageBox.Show("Error", "Время действия аккаунта истекло");
}
}
}
else
{
MessageBox.Show("Пользователь заблокирован");
}
}
}
else
{
SqlCommand sqlCommand;
int count = Convert.ToInt32(reader["count"].ToString());
if (count == 2)
{
sqlCommand = new SqlCommand("update [Emploer] set [block_]=1 where ID_Emploer =" + User.ID_user + ";", sqlConnection);
}
else
{
count++;
sqlCommand = new SqlCommand("update [Emploer] set [count]=" + count + " where ID_Emploer =" + User.ID_user + ";", sqlConnection);
}
reader.Close();
//DataReader.Close();
sqlCommand.ExecuteNonQuery();
MessageBox.Show("Неверный пароль");
}
}
else
{
MessageBox.Show("Текущего пользователя не существует");
}
}
else
{
MessageBox.Show("Заполните данные");
}
sqlConnection.Close();
}
catch (SqlException err)
{
Console.WriteLine(err.ToString(), "Error");
}
}