public cp_proveedor_microempresa_Info GetInfo(string Ruc) { try { cp_proveedor_microempresa_Info info = new cp_proveedor_microempresa_Info(); using (SqlConnection connection = new SqlConnection(ConexionesERP.GetConnectionString())) { connection.Open(); string query = "select Ruc, Nombre from cp_proveedor_microempresa where Ruc ='" + Ruc + "'"; SqlCommand command = new SqlCommand(query, connection); var ValidateValue = command.ExecuteScalar(); if (ValidateValue == null) { return(null); } SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { info = new cp_proveedor_microempresa_Info { Ruc = reader["Ruc"].ToString(), Nombre = reader["Nombre"].ToString(), }; } reader.Close(); } return(info); } catch (Exception) { throw; } }
public cp_proveedor_microempresa_Info GetInfo(string Ruc) { try { cp_proveedor_microempresa_Info info = new cp_proveedor_microempresa_Info(); string Conexion = ConexionERP.GetConnectionString(); using (SqlConnection connection = new SqlConnection(Conexion)) { connection.Open(); string Query = "SELECT Ruc,Nombre FROM cp_proveedor_microempresa WHERE Ruc = '" + Ruc + "'"; SqlCommand command = new SqlCommand(Query, connection); var returnValue = command.ExecuteScalar(); if (returnValue == null) { return(null); } SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { info.Ruc = reader[0].ToString(); info.Nombre = reader[1].ToString(); } reader.Close(); } return(info); } catch (Exception) { throw; } }