public void Register(UserData objUser) {
string strQuery =
"INSERT INTO Users (Login, Password, Email) VALUES ('" + objUser.Login + "', '" + objUser.Password + "', '" +
objUser.Email + "' );";
DbConnection.Open();
SqlCommand objCommand = DbConnection.CreateCommand();
objCommand.CommandText = strQuery;
objCommand.ExecuteNonQuery();
strQuery = "SELECT Id FROM users WHERE Login='******';";
objCommand.CommandText = strQuery;
var varDataReader = objCommand.ExecuteReader();
string strUserId = String.Empty;
if(varDataReader.Read() != false) {
strUserId = varDataReader["Id"].ToString();
}
varDataReader.Close();
if(strUserId != String.Empty) {
strQuery = "INSERT INTO UsersInfo (LastName, FirstName, UserId) VALUES ('" +
objUser.LastName + "', '" + objUser.FirstName + "'," + strUserId.ToString() + " );";
objCommand.CommandText = strQuery;
objCommand.ExecuteNonQuery();
}
DbConnection.Close();
}
public string LogIn(UserData objUser) {
DbConnection.Open();
string strQuery =
"SELECT * FROM Users WHERE Login='******' AND Password='******';";
SqlCommand objCommand = DbConnection.CreateCommand();
objCommand.CommandText = strQuery;
SqlDataReader objDataReader = objCommand.ExecuteReader();
string strUserId = String.Empty;
if(objDataReader.Read() != false) {
strUserId=objDataReader["id"].ToString();
}
DbConnection.Close();
return strUserId;
}
private void button1_Click(object sender, EventArgs e) {
try {
if(textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") {
MessageBox.Show("Fill all fields");
return;
}
if(textBox2.Text != textBox3.Text) {
MessageBox.Show("Passwords must match");
}
var objUser = new UserData();
objUser.Password = textBox2.Text;
objUser.Email = textBox1.Text;
Program.ObjConnector.ChangePassword(objUser);
MessageBox.Show("Password changed!");
this.Close();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e) {
try {
label1.Text = "Searching...";
label1.Refresh();
progressBar1.Value = progressBar1.Minimum;
for(int i = progressBar1.Minimum; i < progressBar1.Maximum; ++i) {
progressBar1.Value = i;
progressBar1.Refresh();
Thread.Sleep(30);
}
progressBar1.Value = progressBar1.Minimum;
var objUser = new UserData();
objUser.Login = textBox1.Text;
objUser.Password = textBox2.Text;
string strUserId=Program.ObjConnector.LogIn(objUser);
if (strUserId != String.Empty)
{
this.Hide();
Form3 objForm3 = new Form3(Program.ObjConnector.GetUserInfo(strUserId));
objForm3.ShowDialog();
this.Show();
return;
}
label1.ForeColor = Color.Red;
label1.Text = "User not found";
label1.Refresh();
}
catch(Exception ex) {
MessageBox.Show(ex.Message);
}
}
public void ChangePassword(UserData objUser) {
DbConnection.Open();
string strQuery =
"UPDATE Users SET Password='******' WHERE Email='" + objUser.Email + "';";
SqlCommand objCommand = DbConnection.CreateCommand();
objCommand.CommandText = strQuery;
objCommand.ExecuteNonQuery();
DbConnection.Close();
}