public IEnumerable <OrderItemData> GetAll(OrderHeaderData order) { Log.LogInformation("Accessing OrderItemRepo GetAll by InvoiceData function"); var pcol = new List <SqlParameter>() { Mapper.BuildParam("@order_key", order.OrderKey) }; using (entityContext) return(MapRows(entityContext.ExecuteProcedureAsSqlDataReader("usp_order_item_all", pcol))); }
} // Map function closer public List <SqlParameter> MapParamsForUpsert(OrderHeaderData entity) => new List <SqlParameter> { new SqlParameter("@order_key", entity.OrderKey), new SqlParameter("@account_key", entity.AccountKey), new SqlParameter("@account_contact_key", entity.AccountContactKey), new SqlParameter("@order_num", entity.OrderNum), new SqlParameter("@order_entry_date", entity.OrderEntryDate), new SqlParameter("@order_status_key", entity.OrderStatusKey), new SqlParameter("@order_status_date", entity.OrderStatusDate), new SqlParameter("@order_ship_date", entity.OrderShipDate), new SqlParameter("@account_rep_key", entity.AccountRepKey), new SqlParameter("@order_complete_date", entity.OrderCompleteDate), new SqlParameter("@order_value_sum", entity.OrderValueSum), new SqlParameter("@order_item_count", entity.OrderItemCount), new SqlParameter("@deliver_by_date", entity.DeliverByDate), new SqlParameter("@sales_rep_key", entity.SalesRepKey), GetOutParam() };
public List <SqlParameter> MapParamsForDelete(OrderHeaderData entity) => MapParamsForDelete(entity.OrderKey);