private void HyperlinkLabelControl_Click(object sender, EventArgs e)
{
try
{
Create_Account login = new Create_Account();
if (LabelControl_ID.Text.Trim() == "")
{
XtraMessageBox.Show("Error", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
My_Database dataBase = new My_Database();
SqlCommand command = new SqlCommand(
"SELECT Id, firstname, lastname, username, password, picture, role FROM New_User WHERE Id = @ID", dataBase.GetConnection);
command.Parameters.Add("@ID", SqlDbType.Int).Value = Convert.ToInt32(LabelControl_ID.Text);
dataBase.Openconnection();
Users user = new Users();
DataTable table = user.GetUser(command);
if (table.Rows.Count > 0)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "New_User");
dataBase.Closeconnection();
login.ID_tb.Text = table.Rows[0]["Id"].ToString().Trim();
login.First_tb.Text = table.Rows[0]["firstname"].ToString().Trim();
login.Last_tb.Text = table.Rows[0]["lastname"].ToString().Trim();
login.User_tb.Text = table.Rows[0]["username"].ToString().Trim();
login.Pass_tb.Text = table.Rows[0]["password"].ToString().Trim();
byte[] pic = (byte[])table.Rows[0]["picture"];
login.CheckedComboBox_Role.Text = table.Rows[0]["role"].ToString().Trim();
MemoryStream picture = new MemoryStream(pic);
login.PictureUser.Image = Image.FromStream(picture);
login.ShowDialog();
}
else
{
XtraMessageBox.Show("Error format", "User", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch
{
XtraMessageBox.Show("The format incorrect", "User", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void accountButton_Click(object sender, EventArgs e)
{
Create_Account createAccount = new Create_Account();
createAccount.Show();
}
