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 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]");
}
}
public void Clear()
{
Filtered.Clear();
}