public static SellerModel BuscaPorEmailSeller(string email) { var ret = new SellerModel(); using (var comando = new SqlCommand()) { comando.Connection = Conexao.connection; comando.CommandText = string.Format( "select * from UserSys where email = '{0}'", email); Conexao.Conectar(); var reader = comando.ExecuteReader(); while (reader.Read()) { ret.Id = (int)reader["Id"]; ret.Name = (string)reader["Login"]; ret.UserRoleId = (int)reader["UserRoleId"]; } Conexao.Desconectar(); } return(ret); }
public static List <SellerModel> BuscaSeller(string email) { var ret = new List <SellerModel>(); SellerModel Seller = BuscaPorEmailSeller(email); using (var comando = new SqlCommand()) { comando.Connection = Conexao.connection; if (Seller.UserRoleId == 1) { comando.CommandText = string.Format( "select * from UserSys "); } else { comando.CommandText = string.Format( "select * from UserSys where id = '{0}'", Seller.Id); } Conexao.Conectar(); var reader = comando.ExecuteReader(); while (reader.Read()) { ret.Add(new SellerModel { Id = (int)reader["Id"], Name = (string)reader["Login"] }); } Conexao.Desconectar(); } return(ret); }