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); }