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();
}
