public void ExecuteProcedure(SqlOperation sqlOperation)
{
using (var conn = new SqlConnection(CONNECTION_STRING))
using (var command = new SqlCommand(sqlOperation.ProcedureName, conn)
{
CommandType = CommandType.StoredProcedure
})
{
foreach (var param in sqlOperation.Parameters)
{
command.Parameters.Add(param);
}
conn.Open();
command.ExecuteNonQuery();
}
}
public List <Dictionary <string, object> > ExecuteQueryProcedure(SqlOperation sqlOperation)
{
var lstResult = new List <Dictionary <string, object> >();
using (var conn = new SqlConnection(CONNECTION_STRING))
using (var command = new SqlCommand(sqlOperation.ProcedureName, conn)
{
CommandType = CommandType.StoredProcedure
})
{
foreach (var param in sqlOperation.Parameters)
{
command.Parameters.Add(param);
}
try
{
conn.Open();
}
catch (Exception ex)
{
throw new SystemException("El servidor no se encuentra disponible en estos momentos, por favor intente más tarde");
}
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var dict = new Dictionary <string, object>();
for (var lp = 0; lp < reader.FieldCount; lp++)
{
dict.Add(reader.GetName(lp), reader.GetValue(lp));
}
lstResult.Add(dict);
}
}
}
return(lstResult);
}
