private void pictureBox3_Click(object sender, EventArgs e) { Form ort = new Form4(); ort.Show(); }
private void button1_Click(object sender, EventArgs e) { Form4 FormEdit = new Form4(); FormEdit.Show(); }
private void importedReceiptsToolStripMenuItem_Click(object sender, EventArgs e) { Form ImportedData = new Form4(); ImportedData.Show(); }
public void zal_4(object sender, EventArgs e) { var btn = new Form4(); btn.Show(); }
private void button1_Click(object sender, EventArgs e) { int result; if (UserName.TextLength > 3 && UserName.TextLength < 32) { if (FirstName.TextLength > 3 && FirstName.TextLength < 32 && LastName.TextLength > 3 && LastName.TextLength < 32) { if (Password.Text == Password_2.Text && Password.TextLength > 3 && Password.TextLength < 32) { if (Type.Text == "Seller" || Type.Text == "Customer") { if (Control.CheckNameCustomer(UserName.Text) == null && Control.CheckNameSeller(UserName.Text) == null) { if (Type.Text == "Customer") { result = Control.InsertCustomer(UserName.Text, FirstName.Text, LastName.Text, Password.Text); Logged_in = true; int ID = (int)Control.GetIDCustomer(); logincustomer F = new logincustomer(); F.TakeParamaters(ID); F.GetName(FirstName.Text, LastName.Text); Password.Text = ""; Password_2.Text = ""; FirstName.Text = ""; LastName.Text = ""; Type.Text = ""; Phone.Text = ""; UserName.Text = ""; Message.Visible = false; Message.Text = ""; F.Show(); this.Close(); } else if (Type.Text == "Seller") { result = Control.InsertSeller(UserName.Text, FirstName.Text, LastName.Text, Password.Text, Phone.Text); Logged_in = true; //f.Show(); int ID = (int)Control.GetID(); Form4 F = new Form4(); F.GetName(FirstName.Text, LastName.Text); F.TakeParamaters(ID); Password.Text = ""; Password_2.Text = ""; FirstName.Text = ""; LastName.Text = ""; Type.Text = ""; Phone.Text = ""; UserName.Text = ""; Message.Visible = false; Message.Text = ""; F.Show(); this.Close(); } } else { Message.Visible = true; Message.Text = "This username is alredy taken"; } } else { Message.Visible = true; Message.Text = "Select your type"; } } else { if (Password.Text == Password_2.Text) { Message.Visible = true; Message.Text = "The password must be between 5~32 characters"; } else { Message.Visible = true; Message.Text = "The passwords aren't identical"; } } } else { Message.Visible = true; Message.Text = "The FirstName and LastName must be between 4~32 characters"; } } else { Message.Visible = true; Message.Text = "The user name must be between 4~32 characters"; } }
private void настройкиToolStripMenuItem_Click(object sender, EventArgs e) { Form4 newForm4 = new Form4(); newForm4.Show(); }
public void Avt() { SqlConnection connection = new SqlConnection(Properties.Settings.Default.con); string zapros = "select login, password from dbo.users"; connection.Open(); SqlCommand sqlCommand = new SqlCommand(zapros, connection); SqlDataReader reader = sqlCommand.ExecuteReader(); string login = "", password = ""; if (reader.HasRows) { while (reader.Read()) { textBox1.Focus(); login = reader.GetString(0); password = reader.GetString(1); login = login.Trim(' '); password = password.Trim(' '); if (textBox1.Text == login && textBox2.Text == password) { auth = true; break; } } reader.Close(); sqlCommand.Dispose(); string query = "select role from dbo.users where login='******' and password='******'"; sqlCommand.CommandText = query; role = Convert.ToInt32(sqlCommand.ExecuteScalar()); if (auth) { switch (role) { case 1: Form4 form4 = new Form4(); form4.Show(); this.Hide(); break; case 2: Form3 form3 = new Form3(); form3.Show(); this.Hide(); break; case 3: Form2 form2 = new Form2(); form2.Show(); this.Hide(); break; } } else { MessageBox.Show("Неправильный логин или пароль,\nпожалуйста,повторите попытку ", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); textBox1.Clear(); textBox2.Clear(); } } }
private void button1_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(Program.conStr); connection.Open(); Form4 form4 = Program.form4; if (textBox2.Text == "") { MessageBox.Show("房间号不能为空", "提示"); } else if (Convert.ToInt32(textBox2.Text) <= 600 || Convert.ToInt32(textBox2.Text) >= 2008) { MessageBox.Show("没有该房间号", "提示"); } else { //1、判断该用户是否已预约房间 SqlCommand command = new SqlCommand($"select room from db_users where username='******'", connection); SqlDataReader reader = command.ExecuteReader(); object obj = new object(); while (reader.Read()) { obj = reader[0]; } reader.Close(); try { var f = (string)obj; } catch { //2、未预约过房间,判断该房间是否已被人预约 SqlCommand pdyy = new SqlCommand($"select roomOX from db_rooms where room='{textBox2.Text}'", connection); SqlDataReader yyzk = pdyy.ExecuteReader(); object obj1 = new object(); while (yyzk.Read()) { obj1 = yyzk[0]; } yyzk.Close(); if ((string)obj1 == "empty") { //给用户信息数据添加房间信息 var commandText = $"update db_users set room='{textBox2.Text}' where username='******'"; new SqlCommand(commandText, connection).ExecuteNonQuery(); //给房间信息添加已有人预约的信息 var commandText1 = $"update db_rooms set roomOX='using' where room='{textBox2.Text}'"; new SqlCommand(commandText1, connection).ExecuteNonQuery(); //给房间信息添加已预约人的信息 var commandText2 = $"update db_rooms set username='******' where room='{textBox2.Text}'"; new SqlCommand(commandText2, connection).ExecuteNonQuery(); MessageBox.Show("预约成功!!!", "提示"); } else { MessageBox.Show("该房间已被人提前预约", "提示"); } return; } if ((string)obj == "NULL") { SqlCommand pdyy = new SqlCommand($"select roomOX from db_rooms where room='{textBox2.Text}'", connection); SqlDataReader yyzk = pdyy.ExecuteReader(); object obj1 = new object(); while (yyzk.Read()) { obj1 = yyzk[0]; } yyzk.Close(); if ((string)obj1 == "empty") { //给用户信息数据添加房间信息 var commandText = $"update db_users set room='{textBox2.Text}' where username='******'"; new SqlCommand(commandText, connection).ExecuteNonQuery(); //给房间信息添加已有人预约的信息 var commandText1 = $"update db_rooms set roomOX='using' where room='{textBox2.Text}'"; new SqlCommand(commandText1, connection).ExecuteNonQuery(); //给房间信息添加已预约人的信息 var commandText2 = $"update db_rooms set username='******' where room='{textBox2.Text}'"; new SqlCommand(commandText2, connection).ExecuteNonQuery(); MessageBox.Show("预约成功!!!", "提示"); } else { MessageBox.Show("该房间已被人提前预约", "提示"); } } else { MessageBox.Show("该用户已预约过房间", "提示"); } /*2、判断该房间是否已被人预约 * SqlCommand pdyy = new SqlCommand($"select roomOX from db_rooms where room='{textBox2.Text}'", connection); * SqlDataReader yyzk = pdyy.ExecuteReader(); * object obj1 = new object(); * while (yyzk.Read()) * { * obj1 = yyzk[0]; * } * yyzk.Close(); * try * { * var f1 = (string)obj1; * } * catch * { * if ((string)obj1 == "empty") * { * //给用户信息数据添加房间信息 * var commandText = $"update db_users set room='{textBox2.Text}' where username='******'"; * new SqlCommand(commandText, connection).ExecuteNonQuery(); * //给房间信息添加已有人预约的信息 * var commandText1 = $"update db_rooms set roomOX='using' where room='{textBox2.Text}'"; * new SqlCommand(commandText1, connection).ExecuteNonQuery(); * //给房间信息添加已预约人的信息 * var commandText2 = $"update db_rooms set username='******' where room='{textBox2.Text}'"; * new SqlCommand(commandText2, connection).ExecuteNonQuery(); * * MessageBox.Show("预约成功!!!", "提示"); * } * else * { * MessageBox.Show("该房间已被人提前预约", "提示"); * } * return; * } * return;*/ /*2、判断该房间是否已被别人预约obj1 * SqlCommand pdyy = new SqlCommand($"select roomOX from db_rooms where room='{textBox2.Text}'", connection); * SqlDataReader yyzk = pdyy.ExecuteReader(); * object obj1 = new object(); * while (yyzk.Read()) * { * obj1 = yyzk[0]; * } * yyzk.Close(); * try * { * var f = (string)obj; * var f1 = (string)obj1; * } * catch * { * //给用户信息数据添加房间信息 * var commandText = $"update db_users set room='{textBox2.Text}' where username='******'"; * new SqlCommand(commandText, connection).ExecuteNonQuery(); * //给房间信息添加已有人预约的信息 * var commandText1 = $"update db_rooms set roomOX='USING' where room='{textBox2.Text}'"; * new SqlCommand(commandText1, connection).ExecuteNonQuery(); * //给房间信息添加已预约人的信息 * var commandText2 = $"update db_rooms set username='******' where room='{textBox2.Text}'"; * new SqlCommand(commandText2, connection).ExecuteNonQuery(); * * MessageBox.Show("预约成功!!!", "提示"); * return; * } * * MessageBox.Show("该用户已预约房间或该房间已被别人预约!", "提示");*/ } }
private void button3_Click(object sender, EventArgs e) { Form4 form4 = new Form4(); form4.Show(); }
private void умножениеToolStripMenuItem_Click(object sender, EventArgs e) { Form umnoj = new Form4(); umnoj.Show(); }
private void лабораторнаяРабота3ToolStripMenuItem_Click(object sender, EventArgs e) { Form4 Form4 = new Form4(this); Form4.Show(); }