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; }