public IEnumerable <ListaOrden> GetOrdenPaginada(int page, int rows)
{
var parameters = new DynamicParameters();
parameters.Add("@page", page);
parameters.Add("@rows", rows);
using var connection = new SqlConnection(_connectionString);
var reader = connection.QueryMultiple("dbo.Orden_paginada", parameters, commandType: System.Data.CommandType.StoredProcedure);
var orderList = reader.Read <ListaOrden>().ToList();
var orderItemList = reader.Read <ListaOrdenItem>().ToList();
foreach (ListaOrden item in orderList)
{
item.SetDetails(orderItemList);
}
return(orderList);
}
public ListaOrden GetOrdenById(int OrdenId)
{
var parameters = new DynamicParameters();
parameters.Add("@OrdenId", OrdenId);
using (var connection = new SqlConnection(_connectionString))
{
var reader = connection.QueryMultiple("dbo.Orden_by_id", parameters, commandType: System.Data.CommandType.StoredProcedure);
var ListaOrden = reader.Read <ListaOrden>().ToList();
var ListaItemsOrden = reader.Read <ListaOrdenItem>().ToList();
foreach (ListaOrden item in ListaOrden)
{
item.SetDetails(ListaItemsOrden);
}
return(ListaOrden.FirstOrDefault());
}
}
public List <T> ExecuteMultiQuery <T, U>(string foreignKey)
{
using (var connection = new SqlConnection(_connectionString))
{
var sql = @$ "select * from {typeof(T)}
select * from {typeof(U)} ";
using (var multi = connection.QueryMultiple(sql))
{
//var skillCategories = multi.Read<T>().ToDictionary(g => g., g=>g);
//skillCategories.ForEach((item) => {
// item[""] = multi.Read<U>().Where(i => i.).ToList();
//});
}
return(new List <T>());
}
}
public OrderList GetOrderById(int orderId)
{
var parameters = new DynamicParameters();
parameters.Add("@orderId", orderId);
using (var connection = new SqlConnection(_connectionString))
{
var reader = connection.QueryMultiple("dbo.get_orders_by_id",
parameters,
commandType: System.Data.CommandType.StoredProcedure);
var orderList = reader.Read <OrderList>().ToList();
var orderItemList = reader.Read <OrderItemList>().ToList();
foreach (var item in orderList)
{
item.SetDetails(orderItemList);
}
return(orderList.FirstOrDefault());
}
}
public IEnumerable <OrderList> getPaginatedOrder(int page, int rows)
{
var parameters = new DynamicParameters();
parameters.Add("@page", page);
parameters.Add("@rows", rows);
using (var connection = new SqlConnection(_connectionString))
{
var reader = connection.QueryMultiple("dbo.get_paginated_orders",
parameters,
commandType: System.Data.CommandType.StoredProcedure);
var orderList = reader.Read <OrderList>().ToList();
var orderItemList = reader.Read <OrderItemList>().ToList();
foreach (var item in orderList)
{
item.SetDetails(orderItemList);
}
return(orderList);
}
}