}//Delete
public List <Provider> Listar(string businessName)
{
var conn = new SqlConnection();
var command = new SqlCommand();
var dataBase = new DBConnect();
var Lista = new List <Provider>();
try
{
conn = dataBase.Open();
command.Connection = conn;
command.CommandText = "ListProvider";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@BusinessName", businessName);
var rdr = command.ExecuteReader();
while (rdr != null && rdr.Read())
{
var reg = new Provider();
reg.Id = (int)rdr["Id"];
reg.BusinessName = (string)rdr["BusinessName"];
reg.Telephone = Convert.ToString(rdr["Telephone"] is DBNull ? "" : rdr["Telephone"]);
reg.Address = Convert.ToString(rdr["Address"] is DBNull ? "" : rdr["Address"]);
reg.Mail = Convert.ToString(rdr["Mail"] is DBNull ? "" : rdr["Mail"]);
reg.Observation = Convert.ToString(rdr["Observation"] is DBNull ? "" : rdr["Observation"]);
if (rdr["IdTel"] is DBNull)
{
reg._providerData.IdTel = null;
}
else
{
reg._providerData.IdTel = (int)rdr["IdTel"];
}
if (rdr["IdAddress"] is DBNull)
{
reg._providerData.IdAddress = null;
}
else
{
reg._providerData.IdAddress = (int)rdr["IdAddress"];
}
if (rdr["IdMail"] is DBNull)
{
reg._providerData.IdMail = null;
}
else
{
reg._providerData.IdMail = (int)rdr["IdMail"];
}
Lista.Add(reg);
}//while
}
catch (Exception e)
{
MessageBox.Show(String.Concat(e.Message, e.StackTrace), "");
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
return(Lista);
}//Listar