/// <summary>
/// Trae los bancos de la empresa
/// </summary>
/// <param name="Lista"></param>
/// <param name="commandText"></param>
/// <param name="Parametros"></param>
/// <param name="ConGenericos"></param>
public static void ExecuteSP(out List<Banco> Lista, String commandText, SqlParameter[] Parametros, bool ConGenericos)
{
SqlConnection dc = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["EbuyConexion"].ConnectionString); //"Database=EplaceDb;Server=10.20.20.200;User Id=executor;Password=executor;");
try
{
List<Banco> list = new List<Banco>();
Banco item = new Banco();
SqlCommand command = new SqlCommand();
command = getEbuy(commandText, Parametros, ConGenericos);
command.Connection = dc;
dc.Open();
IDataReader lector = command.ExecuteReader();
while (lector.Read())
{
list.Add(item.castDR(lector));
}
lector.Close();
Lista = list;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
