public static ObservableCollection <Account> GetDeletedAccounts()
{
ObservableCollection <Account> result = null;
try
{
var reader = DataConnector.ExecuteQuery(
@"select tk.mataikhoan, tk.email, tk.matkhau, tk.hoten, tk.maphanquyen " +
"from taikhoan tk " +
"where tk.bixoa = 'true'");
if (reader != null)
{
result = new ObservableCollection <Account>();
while (reader.Read())
{
var item = new Account(reader.GetInt32(0));
item.BeginInit();
item.Email = (string)reader.GetValueDefault(1, null);
item.Password = (string)reader.GetValueDefault(2, null);
item.Name = (string)reader.GetValueDefault(3, null);
item.AccessLevel = AccessLevelAdapter.GetAcessLevelById(reader.GetInt32(4));
item.IsDeleted = true;
item.IsDeletedItem = item.IsDeleted;
item.EndInit();
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}
public static Account GetAccount(int id, bool findDeletedToo = false)
{
Account result = null;
try
{
var reader = DataConnector.ExecuteQuery(
string.Format(@"select tk.mataikhoan, tk.email, tk.matkhau, tk.hoten, tk.maphanquyen, tk.bixoa " +
"from taikhoan tk " +
"where tk.mataikhoan = {0} {1} and tk.maphanquyen = pq.maphanquyen", id, findDeletedToo ? "" : "and tk.bixoa = 'false'"));
if (reader != null)
{
while (reader.Read())
{
var item = new Account(reader.GetInt32(0));
item.BeginInit();
item.Email = (string)reader.GetValueDefault(1, null);
item.Password = (string)reader.GetValueDefault(2, null);
item.Name = (string)reader.GetValueDefault(3, null);
item.AccessLevel = AccessLevelAdapter.GetAcessLevelById(reader.GetInt32(4));
item.IsDeleted = (bool)reader.GetValueDefault(5, false);
item.IsDeletedItem = item.IsDeleted;
item.EndInit();
result = item;
break;
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}
public static bool IsExists(string username, string password, out Account result, bool findDeletedToo = false)
{
result = null;
try
{
password = crypto.encodeMD5(crypto.encodeSHA1(password));
var reader = DataConnector.ExecuteQuery(
string.Format(@"select tk.mataikhoan, tk.email, tk.matkhau, tk.hoten, tk.maphanquyen, tk.bixoa " +
"from taikhoan tk " +
"where tk.email = '{0}' and tk.matkhau = '{1}' {2}", username, password, findDeletedToo ? "" : "and tk.bixoa = 'false'"));
if (reader != null)
{
while (reader.Read())
{
var item = new Account(reader.GetInt32(0));
item.BeginInit();
item.Email = (string)reader.GetValueDefault(1, null);
item.Password = (string)reader.GetValueDefault(2, null);
item.Name = (string)reader.GetValueDefault(3, null);
item.AccessLevel = AccessLevelAdapter.GetAcessLevelById(reader.GetInt32(4));
item.IsDeleted = (bool)reader.GetValueDefault(5, false);
item.IsDeletedItem = item.IsDeleted;
item.EndInit();
result = item;
break;
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result != null);
}
