/
avtoriz.cs
121 lines (102 loc) · 4.11 KB
/
avtoriz.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Microsoft.Win32;
using System.Data.SqlClient;
namespace Zara
{
public partial class avtoriz : Form
{
podklclss _CC;
string id_sotr;
public avtoriz()
{
InitializeComponent();
}
private void button3_Click(object sender, EventArgs e)
{
glav_menu examp = new glav_menu();
examp.Show();
}
private void maskedTextBox1_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
if (maskedTextBox1.Text == " -" || maskedTextBox2.Text == "")
{
MessageBox.Show("Не все поля заполнены!");
}
else
{
_CC = new podklclss();
_CC.Set_Connection();
_CC.conection.Open();
SqlCommand newCMD = new SqlCommand("Select * from [dbo].[sotrud] where [login] ='" + maskedTextBox1.Text + "' and [parol] = '" + maskedTextBox2.Text + "'", _CC.conection);
SqlDataAdapter sda = new SqlDataAdapter(newCMD);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
Program.user_login = maskedTextBox1.Text;
MessageBox.Show("Вы успешно вошли в систему." , "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information);
glav_menu glav_menu = new glav_menu();
this.Hide();
glav_menu.Show();
}
else
{
MessageBox.Show("Неправильный логин или пароль." + "\n" + "Повторите попытку входа!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void avtoriz_FormClosed(object sender, FormClosedEventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
panel2.Visible = true;
}
private void label5_Click(object sender, EventArgs e)
{
}
private void button3_Click_1(object sender, EventArgs e)
{
if (maskedTextBox5.Text == " -" || maskedTextBox4.Text == "")
{
MessageBox.Show("Не все поля заполнены!");
}
else
{
_CC = new podklclss();
_CC.Set_Connection();
_CC.conection.Open();
SqlCommand newCMD = new SqlCommand("Select * from [dbo].[sotrud] where [login] ='" + maskedTextBox5.Text + "' and [slovo] = '" + maskedTextBox4.Text + "'", _CC.conection);
SqlDataAdapter sda = new SqlDataAdapter(newCMD);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
panel1.Visible = true;
_CC = new podklclss();
_CC.Set_Connection();
_CC.conection.Open();
SqlCommand cmd = new SqlCommand("Select * from [dbo].[sotrud](parol) where [login] ='" + maskedTextBox5.Text + _CC.conection);
int result = ((int)cmd.ExecuteScalar());
_CC.conection.Close();
maskedTextBox3.Text = Convert.ToString(result);
}
else
{
MessageBox.Show("Неверные данные");
}
}
}
}
}