public override ACUser LoadUserInfo(int pUserId)
{
ACUser result = null;
using (ConnectionWrapper cnn = ((DBManager)_dbManager).GetConnection())
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "mlac_sp_usr_LoadUserInfo";
cmd.Parameters.Add(new SqlParameter("@pUserId", pUserId));
cnn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
result = new ACUser()
{
Id = pUserId,
LoginName = reader.GetString(0),
FirstName = reader.GetString(1),
LastName = reader.GetString(2),
Email = reader.GetString(3)
};
}
}
}
}
return(result);
}
public override ACUser LoadUserInfo(int pUserId)
{
ACUser result = null;
using (ConnectionWrapper cnn = ((DBManager)_dbManager).GetConnection())
{
using (SQLiteCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "SELECT [login_name],[first_name],[last_name],[email] FROM [mlac_tbl_users] WHERE [id]=@pUserId;";
cmd.Parameters.Add(new SQLiteParameter("@pUserId", pUserId));
cnn.Open();
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
result = new ACUser()
{
Id = pUserId,
LoginName = reader.GetString(0),
FirstName = reader.GetString(1),
LastName = reader.GetString(2),
Email = reader.GetString(3)
};
}
}
}
}
return(result);
}
private void btnLoadUserInfo_Click(object sender, EventArgs e)
{
ACUser user = BLL.Users.LoadUserInfo(int.Parse(tbUserId.Text));
Result.Text = "";
if (user != null)
{
Result.Text += String.Format("Id: {0}, Name: {1} {2}, Email: {3}\r\n", user.Id, user.FirstName, user.LastName, user.Email);
}
else
{
Result.Text += "User record not found\r\n";
}
}
