private async void ExecuteGetPhotos(object obj)
{
IsEnforce = false;
UserDatum selectedDataum = NameSuggests.FirstOrDefault <UserDatum>(x => x.username == Name);
UserAttributes t;
SetHeaderAttributes(true, String.Format("Собираем фотографии пользователя {0}", Name));
if (selectedDataum != null)
{
t = await _dataService.getUserAttributes(selectedDataum.id);
if (t != null && t.data != null)
{
UserPics.Clear();
foreach (var item in t.data)
{
UserPics.Add(item);
}
IsEnforce = true;
SetHeaderAttributes(false, String.Empty);
IsVisiblePreviousButton = true;
}
}
else
{
IsVisiblePreviousButton = false;
SetHeaderAttributes(false, String.Format("Не удалось загрузить пользователя {0}", Name));
}
}
public UserDatum GetUser(string username)
{
using (var cn = new SqlConnection())
{
cn.ConnectionString = "Server=(localdb)\\Priceredacted;Database=PriceredactedDB";
try
{
cn.Open();
using (var select = new SqlCommand())
{
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand command = new SqlCommand("SELECT Email, Id, Password, Username FROM UserData" +
" WHERE Username = @UN", cn);
command.Parameters.AddWithValue("@UN", username);
da.SelectCommand = command;
DataSet ds = new DataSet();
da.Fill(ds, "UserData");
cn.Close();
da.Dispose();
UserDatum user = new UserDatum()
{
Email = ds.Tables[0].Rows[0]["Email"].ToString(),
Id = Int32.Parse(ds.Tables[0].Rows[0]["Id"].ToString()),
Username = ds.Tables[0].Rows[0]["Username"].ToString(),
Password = ds.Tables[0].Rows[0]["Password"].ToString()
};
return(user);
}
}
catch (SqlException ex)
{
return(null);
}
catch (Exception e)
{
return(null);
}
finally
{
cn.Close();
}
}
}
