public PostGroupUserPushNotificationSetting[] getSubscribedPostGroupsSettings(long userID)
{
List <PostGroupUserPushNotificationSetting> subscribedIDs = new List <PostGroupUserPushNotificationSetting>();
using (StreamReader sr = new StreamReader(file_subscribedPostGroups))
{
string currentLine = null;
while ((currentLine = sr.ReadLine()) != null)
{
string[] args = currentLine.Split(";");
long foundedUser = Convert.ToInt64(args[0]);
if (foundedUser == userID)
{
PostGroupUserPushNotificationSetting setting = convertLineTOItem(currentLine);
if (subscribedIDs.SingleOrDefault(x => x.PostGroupID == setting.PostGroupID) == null)
{
subscribedIDs.Add(setting);
}
}
}
}
return(subscribedIDs.Distinct().ToArray());
}
public PostGroupUserPushNotificationSetting[] getSubscribedPostGroupsSettings(long userID)
{
sqlConnection = null;
sqlConnection = TimeTableDatabase.getConnection();
try
{
using (sqlConnection)
{
PostGroupUserPushNotificationSetting SQLItem = new PostGroupUserPushNotificationSetting();
List <PostGroupUserPushNotificationSetting> list = new List <PostGroupUserPushNotificationSetting>();
string SQL = "SELECT[newsgroupid],[active] FROM subscribe WHERE userid='" + userID.ToString() + "';";
sqlConnection.Open();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand(SQL, sqlConnection);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
SQLItem.PostGroupID = Convert.ToInt32(myReader["newsgroupid"].ToString());
SQLItem.PostGroupActive = Convert.ToBoolean(myReader["active"].ToString());
list.Add(SQLItem);
SQLItem = new PostGroupUserPushNotificationSetting();
}
sqlConnection.Close();
sqlConnection = null;
return(list.ToArray());
}
}
catch (System.Exception)
{
sqlConnection.Close();
sqlConnection = null;
return(null);
}
}
private string convertItemToLine(PostGroupUserPushNotificationSetting item)
{
return($"{item.PostGroupID};{item.PostGroupActive};{item.Type}");
}
