public DicRequestHTTP getData(string query)
{
var listDiccionario = new List <Dictionary <string, object> >();
string sql = query;
connection = new SqlConnection(connetionString);
var req = new DicRequestHTTP();
try
{
connection.Open();
command = new SqlCommand(sql, connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var d = new Dictionary <string, object>();
for (int i = 0; i < dataReader.FieldCount; i++)
{
d.Add(dataReader.GetName(i), dataReader.GetValue(i));
}
listDiccionario.Add(d);
}
dataReader.Close();
command.Dispose();
connection.Close();
req.objeto = listDiccionario;
return(req);
}
catch (Exception e)
{
return(req.falla(e));
}
}
//Pedidos
//usado en modal Pedidos
public DicRequestHTTP getProductos(int empid)
{
inicializarProductos(empid);
JsonResult p = new JsonResult();
p.Data = JsonConvert.SerializeObject(productos);
var req = new DicRequestHTTP();
req.objeto = productos;
return(req);
}
