public ServerPointAccountsHelper GetServerPointAccounts(string user)
{
ServerPointAccountsHelper account = null;
try
{
using (var reader = _Connection.QueryReader("SELECT * FROM serverpointaccounts WHERE name = @0", user))
{
if (reader.Read())
{
account = new ServerPointAccountsHelper()
{
ID = reader.Get <int>("ID"),
Name = reader.Get <string>("name"),
Amount = reader.Get <int>("amount")
};
}
}
}
catch (Exception ex)
{
ExtendedLog.Current.Log(ex.ToString());
}
return(account);
}
public ServerPointAccountsHelper GetServerPointAccounts(string user)
{
ServerPointAccountsHelper account = null;
try
{
using (var reader = _Connection.QueryReader("SELECT * FROM serverpointaccounts WHERE name = @0", user))
{
if (reader.Read())
{
account = new ServerPointAccountsHelper()
{
ID = reader.Get<int>("ID"),
Name = reader.Get<string>("name"),
Amount = reader.Get<int>("amount")
};
}
}
}
catch (Exception ex)
{
ExtendedLog.Current.Log(ex.ToString());
}
return account;
}