private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUsername.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a valid username.");
txtUsername.Focus();
return;
}
else if (txtPassword.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a valid password.");
txtPassword.Focus();
return;
}
else
{
int UserID = 0;
DB db = new DB();
try
{
db.AddParam("@Username", txtUsername.Text.Trim());
db.AddParam("@Password", BMan_Encryption.EncryptPassword(txtPassword.Text.Trim(), ConfigurationManager.AppSettings["EncKey"]));
DataTable dtUser = db.SQLResults("usp_Login");
if (dtUser.Rows.Count > 0)
{
UserID = Convert.ToInt32(dtUser.Rows[0]["UserID"]);
}
}
catch (Exception ex)
{
Common.LogError(ex, "Login.btnLogin_Click");
}
finally
{
db.CleanUp();
}
if (UserID > 0)
{
Menu m = new Menu(UserID);
m.Show();
this.Hide();
}
else
{
MessageBox.Show("Login or Password invalid. Please try again.");
txtPassword.Text = "";
txtPassword.Focus();
return;
}
}
}
private string GetUserName(int userID)
{
string strUserName = "";
DB db = new DB();
db.AddParam("@UserID", userID);
DataTable dt = db.SQLResults("usp_UserNameGet");
if (dt.Rows.Count >= 1 && dt.Rows[0]["UserName"] != null && dt.Rows[0]["UserName"] != DBNull.Value)
strUserName = dt.Rows[0]["UserName"].ToString();
db.CleanUp();
return strUserName;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtFirstName.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a first name.");
txtFirstName.Focus();
return;
}
else if (txtLastName.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a last name.");
txtLastName.Focus();
return;
}
else if (txtUsername.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a username.");
txtUsername.Focus();
return;
}
else if (txtPassword.Text.Trim().Length <= 0)
{
MessageBox.Show("Please enter a password.");
txtPassword.Focus();
return;
}
else if (txtPasswordConfirm.Text.Trim().Length <= 0)
{
MessageBox.Show("Please confirm your password.");
txtPasswordConfirm.Focus();
return;
}
else if (txtPassword.Text.Trim() != txtPasswordConfirm.Text.Trim())
{
MessageBox.Show("Passwords do not match. Please try again.");
txtPassword.Text = "";
txtPasswordConfirm.Text = "";
txtPassword.Focus();
return;
}
else if (cboUserType.SelectedIndex < 0)
{
MessageBox.Show("Please select a user type.");
cboUserType.Focus();
return;
}
else
{
UserID = 0;
DB db = new DB();
try
{
db.AddParam("@FirstName", txtFirstName.Text.Trim());
db.AddParam("@LastName", txtLastName.Text.Trim());
db.AddParam("@Username", txtUsername.Text.Trim());
db.AddParam("@Password", BMan_Encryption.EncryptPassword(txtPassword.Text.Trim(), ConfigurationManager.AppSettings["EncKey"]));
db.AddParam("@UserTypeID", cboUserType.SelectedValue);
DataTable dtUser = db.SQLResults("usp_UserAdd");
if (dtUser.Rows.Count > 0)
{
UserID = Convert.ToInt32(dtUser.Rows[0]["UserID"]);
}
}
catch (Exception ex)
{
Common.LogError(ex, "UserMaintenance.btnSave_Click");
UserID = 0;
}
finally
{
db.CleanUp();
}
if (UserID > 0)
{
Menu m = new Menu(UserID);
m.Show();
this.Hide();
}
else if (UserID == -1)
{
MessageBox.Show("Username already exists. Please enter a different one.");
txtUsername.Focus();
return;
}
else
{
MessageBox.Show("Error adding user. Please try again.");
return;
}
}
}
private void UserMaintenance_Load(object sender, EventArgs e)
{
DB db = new DB();
DataTable dtUT = db.SQLResults("usp_UserTypeList");
cboUserType.DataSource = dtUT;
cboUserType.DisplayMember = "Description";
cboUserType.ValueMember = "UserTypeID";
db.CleanUp();
}
