public Cabinet()
{
InitializeComponent();
DataContext = new cabinetViewModel();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["connList"].ConnectionString;
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select F_Name, M_Name, Photo, Vacancy from Admin where login = '******'";
cmd.Connection = con;
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
NameOfPerson.Text = da.GetValue(0).ToString();
NameOfPerson.Text += " " + da.GetValue(1).ToString();
byte[] img = (byte[])da.GetValue(2);
using (var ms = new MemoryStream(img))
{
userImg.ImageSource = BitmapFrame.Create(ms, BitmapCreateOptions.None, BitmapCacheOption.OnLoad);
}
StatusOfPerson.Text = da.GetValue(3).ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public UpdateViewCommand(cabinetViewModel viewModel)
{
this.viewModel = viewModel;
}
