public override void Filter(User i_Friend)
{
if (i_Friend.Location.Name.Equals(m_CityName))
{
Filtered.Add(Current);
}
}
public void Refresh()
{
var tasks = _repository.GetAllExecutors(_isFullInfoRequired);
var filtered = tasks.Select(x => new ExecutorVM(x)).ToList();
Filtered.Clear();
filtered.ForEach(x => Filtered.Add(x));
}
public override void Filter(User i_Friend)
{
Current = i_Friend;
foreach (Page page in i_Friend.LikedPages)
{
if (page.Id.Equals(m_PageID))
{
Filtered.Add(Current);
}
}
}
public void InitAccounts(ListBox list, string sorting)
{
try
{
Accounts.Clear();
Filtered.Clear();
SqlConnection con = new SqlConnection(conStrSQL);
if (!sorting.Equals(""))
{
sorting = String.Format(" ORDER BY {0}", sorting);
}
string comStr = "SELECT * " +
"FROM AccountTable " +
"WHERE username = '******' AND deleted = '0'" + sorting + ";";
using (SqlCommand cmd = new SqlCommand(comStr, con))
{
con.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Account acc = new Account
{
id = Convert.ToInt32(reader["id"]),
Email = reader["email"].ToString(),
Onlineuser = reader["onlineuser"].ToString(),
Password = EncryptionHelper.Encrypt(reader["password"].ToString(), cryptokey),
Title = reader["title"].ToString(),
Url = reader["url"].ToString(),
marked = reader["marked"].ToString().Equals("1")
};
Accounts.Add(acc);
Filtered.Add(acc);
}
}
con.Close();
update(list);
}
catch (SqlException)
{
if (German)
{
throw new Exception("Fehler beim Verbinden zur Datenbank!\n Versuchen Sie es in einer halben Stunde erneut, wenn Sie sich bis dahin noch immer nicht anmelden können, schreiben Sie ein Email an: [email protected]");
}
throw new Exception("An error accured while trying to connect to the database!\n Try to connect again in 30 minutes, if it won't work then contact us at: [email protected]");
}
}
private void Handler(object sender, EventArgs args)
{
var item = (Type)sender;
bool filterApplies = Filter(item);
if (filterApplies)
{
if (!Filtered.Contains(item))
{
var previous = Filtered.LastOrDefault();
if (previous != null)
{
_ignoreSourceChangeEvents = true;
try
{
int idxInsertAfter = Source.IndexOf(previous);
Source.Remove(item);
if (idxInsertAfter < Source.Count)
{
Source.Insert(idxInsertAfter, item);
}
else
{
Source.Add(item);
}
}
finally
{
_ignoreSourceChangeEvents = false;
}
}
Filtered.Add(item);
}
return;
}
else
{
if (Filtered.Contains(item))
{
Filtered.Remove(item);
}
return;
}
}
public void Add(T item)
{
Filtered.Add(item);
}
