private void button1_Click(object sender, EventArgs e)
{
if (TxtUserName.Text.Trim().Length < 4)
{
MessageBox.Show("Invalid User Name. User Name should be minimum 4 Characters", "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUserName.Focus();
return;
}
if (TxtPwd.Text.Trim().Length < 4)
{
MessageBox.Show("Invalid Password. Password should be minimum 4 characters", "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtPwd.Focus();
return;
}
DataSet ds;
if (LblPK.Text.Trim().Length <= 0)
{
ds = db.GetTableData("select * from mas_adm_user where user_name='" + TxtUserName.Text.Trim() + "'");
}
else
{
ds = db.GetTableData("select * from mas_adm_user where user_name='" + TxtUserName.Text.Trim() + "' and user_id<>" + LblPK.Text);
}
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("This User Name already Exists", "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Error);
TxtUserName.Focus();
return;
}
string[] res;
if (LblPK.Text.Trim().Length <= 0)
{
res = db.ExecuteQueries("Insert into mas_adm_user values (" + db.GetNewID("mas_adm_user", "user_id") + ",'" + TxtUserName.Text.Trim() + "','" + TxtPwd.Text.Trim() + "','" + CmbStatus.Text.Substring(0, 1) + "',null,'" + GlobalClass.UserName + "',sysdate, null, null, 'I')").Split(',');
}
else
{
res = db.ExecuteQueries("Update mas_adm_user set user_name='" + TxtUserName.Text.Trim() + "', Pwd='" + TxtPwd.Text.Trim() + "', status='" + CmbStatus.Text.Substring(0, 1) + "', modified_by='" + GlobalClass.UserName + "', modified_date=sysdate where user_id=" + LblPK.Text.Trim()).Split(',');
}
if (res[0].ToString() != "0")
{
MessageBox.Show("Failure...\n" + res[1].ToString(), "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
MessageBox.Show("Successfully Saved", "Hindudharmam Magazine", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtPwd.Text = "";
TxtUserName.Text = "";
TxtUserName.Focus();
LblPK.Text = "";
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
string unm = TxtName.Text;
string pwd = TxtPwd.Text;
int flag = 0;
con.Open();
cmd = new SqlCommand("Select * From Admin Where Username='******'", con);
dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
dr.Read();
Session["uname"] = unm;
if (dr["Pwd"].ToString().CompareTo(pwd) != 0)
{
flag = 2;
}
}
else
{
flag = 1;
}
dr.Close();
con.Close();
if (flag == 0)
{
if (Session["uname"] == null)
{
TxtName.Text = "";
TxtPwd.Text = "";
Response.Redirect("Login.aspx");
}
else
{
TxtName.Text = "";
//LblValid.Visible = true;
// LblValid.Text = "Welcome " + unm + " !!";
}
Response.Redirect("Default2.aspx");
}
else if (flag == 1)
{
LblValid.Visible = true;
LblValid.Text = "Invalid User Name";
TxtName.Focus();
}
else
{
LblValid.Visible = true;
LblValid.Text = "Invalid Password";
TxtPwd.Focus();
}
Session.Remove("uid");
}
private void BtnReset_Click(object sender, EventArgs e)
{
GrdResult.DataSource = null;
CmbSort.SelectedIndex = 0;
TxtCard.Clear();
TxtName.Clear();
TxtPwd.Clear();
CmbPage.Items.Clear();
}
private void BtnEye_HidePassword(object sender, RoutedEventArgs e)
{
TxtPwd.Visibility = Visibility.Visible;
txtVisiblePasswordbox.Visibility = Visibility.Hidden;
TxtPwd.Password = txtVisiblePasswordbox.Text;
TxtPwd.Focus();
BtnEye_Hide.Visibility = Visibility.Hidden;
}
private void BtnCancel_Click(object sender, EventArgs e)
{
TxtNickName.Text = string.Empty;
TxtPwd.Text = string.Empty;
TxtPwdConfirm.Text = string.Empty;
TxtMailAddress.Text = string.Empty;
CmbPwdQuestion.Text = string.Empty;
TxtPwdAnswer.Text = string.Empty;
TxtPwd.Focus();
}
/// <summary>
/// Initialize form with information found on user connection configuration file
/// </summary>
private void FillFormWithConnectionInfo()
{
CheckRememberMe.Checked = mUserConnexionInfo_O.mSaveInfoOnLogin_b;
TxtUserName.Text = mUserConnexionInfo_O.mUserName_st;
if (String.IsNullOrEmpty(TxtUserName.Text))
{
TxtUserName.Select();
}
else
{
TxtPwd.Select();
}
}
private void FormReUserPwd_Load(object sender, EventArgs e)
{
TxtPwd.Focus();
DataSet ds = new DataSet();
SQLExecute excute = new SQLExecute();
ds = excute.GetUserInfo(TxtID.Text.Trim());
TxtNickName.Text = ds.Tables[0].Rows[0][0].ToString();
TxtMailAddress.Text = ds.Tables[0].Rows[0][1].ToString();
CmbPwdQuestion.Text = ds.Tables[0].Rows[0][2].ToString();
TxtPwdAnswer.Text = ds.Tables[0].Rows[0][3].ToString();
}
private void BtnRegister_Click(object sender, EventArgs e)
{
if (PicAvatar.Image == null)
{
DialogResult DRret;
DRret = MessageBox.Show("要上传头像吗", "提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (DRret == DialogResult.Yes)
{
return;
}
else
{
}
}
else
{
}
int ret = 0;
DialogResult retDR;
User user = new User()
{
ID = TxtID.Text.Trim(),
Nickname = TxtNickName.Text.Trim(),
Mailaddress = TxtMailAddress.Text.Trim(),
PwdQuestion = CmbPwdQuestion.Text.Trim(),
PwdAnswer = TxtPwdAnswer.Text.Trim(),
FileNameOfAvatar = strAvatarFileName,
};
if (TxtPwd.Text.Trim().Equals(TxtPwdConfirm.Text.Trim()) != true)
{
MessageBox.Show("您输入的密码前后不一样!", "警告",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtPwd.Text = string.Empty;
TxtPwdConfirm.Text = string.Empty;
TxtPwd.Focus();
return;
}
if (user.ID.Equals(string.Empty) || TxtPwd.Text.Trim().Equals(string.Empty) || user.Mailaddress.Equals(string.Empty) || TxtPwdConfirm.Text.Trim().Equals(string.Empty) || user.PwdQuestion.Equals(string.Empty) || user.PwdAnswer.Equals(string.Empty))
{
MessageBox.Show("您有选项没有输入!", "警告",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (TxtVerticationCode.Text.Trim().Equals(strVttCode) == false || TxtVerticationCode.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("验证码不正确!\n或不能为空", "警告",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//将image转为byte[]保存到数据库MEDIUMBLOB里面
byte[] bytesAvatar = null;
ImageConverter imgconv = new ImageConverter();
bytesAvatar = (byte[])imgconv.ConvertTo(PicAvatar.Image, typeof(byte[]));
user.Avatar = bytesAvatar;
//将密码转为hash保存到数据库
user.Password = PasswordStorage.CreateHash(TxtPwd.Text.Trim());
retDR = MessageBox.Show("您确定注册?", "询问",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (retDR == DialogResult.Yes)
{
try
{
SQLExecute Excute = new SQLExecute();
ret = Excute.InsertUserInfo(user);
if (ret > 0)
{
MessageBox.Show("注册成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
MessageBox.Show("请登录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtID.Text = string.Empty;
TxtID.Focus();
}
}
else
{
//用户选择了不注册, 就什么都不干
}
}
private void BtnRePwd_Click(object sender, EventArgs e)
{
User user = new User();
if (TxtID.Text.Trim().Equals(string.Empty) != true)
{
user.ID = TxtID.Text.Trim();
}
if (TxtNickName.Text.Trim().Equals(string.Empty) != true)
{
user.Nickname = TxtNickName.Text.Trim();
}
if (TxtPwd.Text.Trim().Equals(string.Empty) != true)
{
user.Password = TxtPwd.Text.Trim();
}
if (TxtMailAddress.Text.Trim().Equals(string.Empty) != true)
{
user.Mailaddress = TxtMailAddress.Text.Trim();
}
if (CmbPwdQuestion.Text.Trim().Equals(string.Empty) != true)
{
user.PwdQuestion = CmbPwdQuestion.Text.Trim();
}
if (TxtPwdAnswer.Text.Trim().Equals(string.Empty) != true)
{
user.PwdAnswer = TxtPwdAnswer.Text.Trim();
}
int ret = 0;
string strPwdConfirm = TxtPwdConfirm.Text.Trim();
DialogResult DRret;
if (user.Password.Equals(strPwdConfirm) != true)
{
MessageBox.Show("您输入的密码前后不一样!", "警告",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
TxtPwd.Text = string.Empty;
TxtPwdConfirm.Text = string.Empty;
TxtPwd.Focus();
return;
}
if (user.Password.Equals(string.Empty) || strPwdConfirm.Equals(string.Empty))
{
MessageBox.Show("密码和密码确认不可空缺!", "警告",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DRret = MessageBox.Show("确定重置?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (DRret == DialogResult.Yes)
{
SQLExecute excute = new SQLExecute();
ret = excute.UpdateUserInfo(user);
if (ret == 1)
{
MessageBox.Show("重置成功!\n请重新登录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
FormLogin FrmLogin = new FormLogin();
FrmLogin.TxtID.Text = TxtID.Text.Trim();
FrmLogin.Show();
Close();
}
else
{
MessageBox.Show("失败", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
}
}
