public void onSelected(object sender, SelectedItemChangedEventArgs e)
{
GroupChatInfo selectedItem = (GroupChatInfo)e.SelectedItem;
if (selectedItem == null)
{
return;
}
Navigation.PushModalAsync(new GroupChatPage(selectedItem));
((ListView)sender).SelectedItem = null;
}
public static IList <GroupChatInfo> GetSqlGroups(string userID)
{
List <GroupChatInfo> sonuc = new List <GroupChatInfo>();
try
{
string query = @"SELECT T1.ID,T1.Name, T1.ImageUrl, T1.Adminid
FROM[dbo].[Groups] AS T1
INNER JOIN GroupAndUsers AS T2
ON T1.ID = T2.groupID and T2.userID = @userid";
using (SqlConnection connection = new SqlConnection(conBuilder.ConnectionString))
{
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@userid", userID);
connection.Open();
using (SqlDataReader oku = command.ExecuteReader())
{
while (oku.Read())
{
GroupChatInfo gc = new GroupChatInfo();
gc.ID = oku[0].ToString();
gc.Title = oku[1].ToString();
gc.ImageUrl = oku[2].ToString();
gc.AdminID = oku[3].ToString();
sonuc.Add(gc);
}
oku.Close();
}
}
}
catch
{
}
return(sonuc);
}
