public List <BELog_Importar> GetImportar_DA() { try { List <BELog_Importar> lstLog_Importar = new List <BELog_Importar>(); BELog_Importar beLog_Importar = new BELog_Importar(); using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_GET_LOG_IMPORTAR")) { using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { int index1 = dataReader.GetOrdinal("descripcion"); object[] values = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(values); beLog_Importar = new BELog_Importar(); beLog_Importar.Resultado = values[index1] == DBNull.Value ? string.Empty : values[index1].ToString(); lstLog_Importar.Add(beLog_Importar); } } return(lstLog_Importar); } } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error al obtener los locales", string.Empty, string.Empty, ex, "GetPeriodos", true, false); return(null); } finally { } }
public void Limpiar_Log() { try { List <BELog_Importar> lstLog_Importar = new List <BELog_Importar>(); BELog_Importar beLog_Importar = new BELog_Importar(); using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_Limpiar_LOG")) { using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd)) { } } } catch (Exception ex) { ExceptionManager.SaveError("Ocurrio un error al obtener los locales", string.Empty, string.Empty, ex, "GetPeriodos", true, false); } finally { } }