public Account GetAccountByEmail(string Email)
{
string sql = "Select * From Account where Email = @Email";
Dictionary <object, object> parameters = new Dictionary <object, object>();
parameters.Add("Email", Email.ToString());
DataSet results = GetDataSetSql(sql, parameters);
Account fullaccount = null;
if (results != null && results.Tables[0].Rows.Count > 0)
{
fullaccount = DataSetParser.DataSetToAccount(results, 0);
}
return(fullaccount);
}
public Account GetAccountByID(int id)
{
string sql = "Select * From Account where AccountID= @id";
Dictionary <object, object> parameters = new Dictionary <object, object>();
parameters.Add("id", id.ToString());
DataSet results = GetDataSetSql(sql, parameters);
Account a = null;
if (results != null && results.Tables[0].Rows.Count > 0)
{
a = DataSetParser.DataSetToAccount(results, 0);
}
return(a);
}
