private void btnOK_Click(object sender, EventArgs e)
{
if (Internet.EmailIsValid(txtEmail.Text) == false)
{
lblRequired.Text = MMUtils.GetString("newuserDlg.wrongemail.text"); //wrong email format
}
else if (txtEmail.Text == "" || txtLogin.Text == "" || txtName.Text == "" || txtPassword.Text == "")
{
lblRequired.Text = MMUtils.GetString("newuserDlg.allfieldsrequired.text");
}
else
{
aLogin = txtLogin.Text;
aPassword = txtPassword.Text; //TODO crypt password?
lblRequired.Text = "";
using (UsersDB dbUsers = new UsersDB())
{
DataTable _dt = dbUsers.ExecuteQuery("select * from USERS");
foreach (DataRow _row in _dt.Rows)
{
if (_row["LOGIN"].ToString() == txtLogin.Text) //this login already exists!
{
lblRequired.Text = MMUtils.GetString("newuserDlg.loginexists.text");
break;
}
else if (_row["EMAIL"].ToString() == txtEmail.Text) //this email already exists!
{
lblRequired.Text = MMUtils.GetString("newuserDlg.emailexists.text");
break;
}
}
}
if (lblRequired.Text == "")
{
string _role = "";
if (rbtnAdmin.Checked)
{
_role = "Admin";
}
else if (rbtnAdmin.Checked)
{
_role = "DAdmin";
}
else
{
_role = "Member";
}
using (UsersDB _db = new UsersDB())
{
_db.ExecuteNonQuery("INSERT INTO USERS VALUES(" +
"`" + txtName.Text + "`," +
"`" + txtEmail.Text + "`," +
"`" + aLogin + "`," +
"`" + aPassword + "`," +
"`" + _role + "`, ``, ``, 0, 0)");
}
//TODO может отправить письмо?
this.DialogResult = DialogResult.OK;
}
}
}