private void ToSignIn()
{
SqlConnection con = null;
SqlCommand com;
SqlDataReader reader = null;
try {
con = new SqlConnection(connectionString);
string encPassword = GetEncodingPassword(Password.Text);
con.Open();
com = new SqlCommand("Select Count(*) From Users Where Name = @Name and Password = @Password", con);
com.Parameters.AddWithValue("@Name", NameP.Text);
com.Parameters.AddWithValue("@Password", encPassword);
int count = (int)com.ExecuteScalar();
byte countTry = 1;
if (count == 0)
{
MessageBox.Show("Введеные неверные данные");
NameP.Clear();
Password.Clear();
countTry++;
return;
}
else
{
MessageBox.Show("Вход выполнен");
ToWriteFile();
com = new SqlCommand("Select ID, Rights From Users Where Name = @Name and Password = @Password", con);
com.Parameters.AddWithValue("@Name", NameP.Text);
com.Parameters.AddWithValue("@Password", encPassword);
reader = com.ExecuteReader();
reader.Read();
object rights = reader.GetString(1);
id = reader.GetValue(0);
EditForm(rights);
ToWriteDataBaseSuccessful(countTry);
reader.Close();
}
if (countTry == 3)
{
ToWriteDataBaseNotSuccessful(countTry);
MessageBox.Show("Мсье, вы не знаете пароля");
Application.Exit();
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { con.Close(); }
}
private void ToWriteFile()
{
FileStream stream = null;
StreamWriter write = null;
try {
stream = new FileStream("date.txt", FileMode.Truncate);
write = new StreamWriter(stream, System.Text.Encoding.Default);
if (!RememberMe.Checked)
{
write.Write("");
NameP.Clear();
Password.Clear();
}
else
{
byte[] nameByte = System.Text.Encoding.Default.GetBytes(NameP.Text);
string strName = "";
for (int i = 0; i < nameByte.Length; i++)
{
if (i == nameByte.Length - 1)
{
strName += nameByte[i].ToString();
}
else
{
strName += nameByte[i].ToString() + ",";
}
}
byte[] pasByte = System.Text.Encoding.Default.GetBytes(Password.Text);
string strPas = "";
for (int i = 0; i < pasByte.Length; i++)
{
if (i == pasByte.Length - 1)
{
strPas += pasByte[i].ToString();
}
else
{
strPas += pasByte[i].ToString() + ",";
}
}
write.WriteLine(strName);
write.WriteLine(strPas);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { write.Close(); stream.Close(); }
}
public void ClearTextBox()
{
NameP.Clear();
Password.Clear();
RememberMe.Checked = false;
}
