public async Task <IEnumerable <FulfillmentCollectionViewModel> > GetOrderFromCollectionById(string id)
{
List <FulfillmentCollectionViewModel> result = new List <FulfillmentCollectionViewModel>();
string cmd = $@"SELECT sp.*, co.*,fu.*, spi.*, p.*, u.*
FROM `cf_shipping` sp
LEFT JOIN `collection` co ON co.id = sp.collection_id AND co.is_used = 1 AND co.is_deleted = 0
LEFT JOIN `fulfillment` fu ON fu.id = sp.fulfillment_id AND fu.is_used = 1 AND fu.is_deleted = 0
LEFT JOIN `cf_shipping_item` spi ON sp.id = spi.cf_shipping_id AND sp.is_deleted = 0
LEFT JOIN `product` p ON p.id = spi.product_id AND p.is_used = 1 AND p.is_deleted = 0
LEFT JOIN `uom` u ON u.id = spi.uom_id AND u.is_used = 1 AND u.is_deleted = 0
WHERE sp.collection_id = '{id} AND sp.status_id = 3";
DbConnection = DbConnection ?? DALHelper.GetConnection();
var rd = await DbConnection.QueryMultipleAsync(cmd, transaction : DbTransaction);
rd.Read <FulfillmentCollection, Collection, Fulfillment, FulfillmentCollectionItem, Product, UoM, FulfillmentCollectionViewModel>(
(fc, col, fu, fci, pro, Uom) =>
{
FulfillmentCollectionViewModel vm = result.FirstOrDefault(x => x.ID == fc.ID);
if (vm == null)
{
vm = CommonHelper.Mapper <FulfillmentCollection, FulfillmentCollectionViewModel>(fc);
result.Add(vm);
}
if (vm.Collection == null)
{
vm.Collection = col;
}
if (vm.Fulfillment == null)
{
vm.Fulfillment = fu;
}
var item = vm.Items.FirstOrDefault(i => i.Id == fci.Id);
if (item == null && fci != null)
{
item = CommonHelper.Mapper <FulfillmentCollectionItem, FulfillmentCollectionItemViewModel>(fci);
vm.Items.Add(item);
}
if (item != null)
{
item.Product = pro;
item.UoM = Uom;
}
return(vm);
}
);
return(result);
}
public AddFcCommand(FulfillmentCollectionViewModel fulfillmentCollection)
{
this.FulfillmentCollection = fulfillmentCollection;
}
public FulfillmentCollectionCommand(FulfillmentCollectionViewModel fulfillment)
{
Fulfillment = fulfillment;
}
