private void EditUser()
{
int curRowIdx = dgvUser.CurrentRow.Index;
DataRow editRow = dataTableUser.Rows[curRowIdx];
editRow["FullName"] = txtFullName.Text;
editRow["UserName"] = txtUserName.Text;
editRow["PassWord"] = MyUtils.MD5Hash(txtPassWord.Text);
sqlHelper.Update(dataTableUser);
}
private void AddUser()
{
DataRow newRow = dataTableUser.NewRow();
newRow["FullName"] = txtFullName.Text;
newRow["UserName"] = txtUserName.Text;
newRow["PassWord"] = MyUtils.MD5Hash(txtPassWord.Text);
dataTableUser.Rows.Add(newRow);
sqlHelper.Update(dataTableUser);
GetDataGridView();
}
/// <summary>
/// Cập nhật thông tin người dùng
/// </summary>
/// <param name="userID"></param>
/// <param name="fullName"></param>
/// <param name="passWord"></param>
/// <returns>
/// Return true nếu thành công
/// </returns>
public static bool UpdateUser(int userID, string fullName, string passWord)
{
string cmd = "dbo.UpdateUser";
int res = SqlHelper.ExecuteNonQuery(
SqlHelper.defaultConnStr,
cmd,
CommandType.StoredProcedure,
UserIDParam(userID),
FullNameParam(fullName),
PassWordParam(MyUtils.MD5Hash(passWord))
);
return(res == 1);
}
/// <summary>
/// Đăng nhập
/// </summary>
/// <param name="userName">Tên tài khoản</param>
/// <param name="passWord">Mật khẩu</param>
/// <returns>
/// Trả về UserID nếu thành công, ngược lại trả về -1
/// </returns>
public static int Login(string userName, string passWord)
{
string cmd = "dbo.Login";
SqlDataReader reader = SqlHelper.ExecuteReader(
SqlHelper.defaultConnStr,
cmd,
CommandType.StoredProcedure,
UserNameParam(userName), PassWordParam(MyUtils.MD5Hash(passWord))
);
if (reader.HasRows)
{
reader.Read();
return(Convert.ToInt32(reader["UserID"].ToString()));
}
return(-1);
}
