public AdminInfo GetAdmin(string userName)
{
AdminInfo admin = null;
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string cmdText = "select * from AdminInfo where `UserName` = @UserName";
mycmd = new MySqlCommand(cmdText, myconn);
mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
admin = MetaDBAdapter <AdminInfo> .GetAdminInfoListFromDataTable(dt)[0];
dt.Clear();
dt.Dispose();
adapter.Dispose();
return(admin);
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
if (mycmd != null)
{
mycmd.Dispose();
}
}
}
public AdminInfo[] GetAllAdmin()
{
AdminInfo[] listAdmin = null;
MySqlConnection myconn = null;
MySqlCommand mycmd = null;
try
{
DataTable dt = new DataTable();
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
string cmdText = "select * from admininfo";
mycmd = new MySqlCommand(cmdText, myconn);
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(dt);
listAdmin = MetaDBAdapter <AdminInfo> .GetAdminInfoListFromDataTable(dt);
dt.Clear();
dt.Dispose();
adapter.Dispose();
return(listAdmin);
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
if (mycmd != null)
{
mycmd.Dispose();
}
}
}