public StudentCabinet()
{
InitializeComponent();
DataContext = new StudentCabinetViewModel();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["connList"].ConnectionString;
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select l.F_Name, l.L_Name, s.Photo, l.Id from Libing l join Students s on (l.Id = s.Id) where s.login = '******'";
cmd.Connection = con;
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
NameOfPerson.Text = da.GetValue(0).ToString();
NameOfPerson.Text += " " + da.GetValue(1).ToString();
StatusOfPerson.Text = da.GetValue(3).ToString();
if (da.GetValue(2).GetType().ToString() == "System.DBNull")
{
return;
}
else
{
byte[] img = (byte[])da.GetValue(2);
using (var ms = new MemoryStream(img))
{
userImg.ImageSource = BitmapFrame.Create(ms, BitmapCreateOptions.None, BitmapCacheOption.OnLoad);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
public UpdateViewCommand(StudentCabinetViewModel viewModel)
{
this.studviewModel = viewModel;
}
