public async Task <SalesDoc> Create(SalesDoc model)
        {
            int Created = 0;

            using (var transaction = this.DbContext.Database.BeginTransaction())
            {
                try
                {
                    string code = GenerateCode("sales");
                    model.Code = code;
                    model.FlagForCreate(IdentityService.Username, UserAgent);
                    model.FlagForUpdate(IdentityService.Username, UserAgent);
                    if (model.isReturn != true)
                    {
                        model.isReturn = false;
                    }

                    model.isVoid = false;


                    TransferOutDocViewModel            transferOutDocViewModel      = new TransferOutDocViewModel();
                    List <TransferOutDocItemViewModel> transferOutDocItemViewModels = new List <TransferOutDocItemViewModel>();
                    TransferInDocViewModel             transferInDocView            = new TransferInDocViewModel();
                    List <TransferInDocItemViewModel>  transferInDocItemViews       = new List <TransferInDocItemViewModel>();
                    transferOutDocViewModel.code      = code;
                    transferOutDocViewModel.reference = code;
                    transferOutDocViewModel.source    = new SourceViewModel
                    {
                        _id  = model.StoreStorageId,
                        code = model.StoreStorageCode,
                        name = model.StoreStorageName
                    };
                    transferOutDocViewModel.destination = new DestinationViewModel
                    {
                        _id  = model.StoreStorageId,
                        code = model.StoreStorageCode,
                        name = model.StoreStorageName
                    };
                    transferOutDocViewModel.remark = model.Remark;
                    bool isAnyTransferIn = false;
                    transferInDocView.code      = code;
                    transferInDocView.reference = code;
                    transferInDocView.source    = new SourceViewModel
                    {
                        _id  = model.StoreStorageId,
                        code = model.StoreStorageCode,
                        name = model.StoreStorageName
                    };
                    transferInDocView.destination = new DestinationViewModel
                    {
                        _id  = model.StoreStorageId,
                        code = model.StoreStorageCode,
                        name = model.StoreStorageName
                    };
                    transferInDocView.remark = model.Remark;
                    foreach (var item in model.Details)
                    {
                        if (!item.isReturn)
                        {
                            transferOutDocItemViewModels.Add(new TransferOutDocItemViewModel
                            {
                                articleRealizationOrder = item.ItemArticleRealizationOrder,
                                remark   = model.Remark,
                                quantity = item.Quantity,
                                item     = new ItemViewModels
                                {
                                    articleRealizationOrder = item.ItemArticleRealizationOrder,
                                    code              = item.ItemCode,
                                    domesticCOGS      = item.ItemDomesticCOGS,
                                    domesticRetail    = item.ItemDomesticRetail,
                                    domesticSale      = item.ItemDomesticSale,
                                    domesticWholesale = item.ItemDomesticWholeSale,
                                    name              = item.ItemName,
                                    size              = item.ItemSize,
                                    uom = item.ItemUom,
                                    _id = item.ItemId,
                                }
                            });
                        }
                        else if (item.isReturn)
                        {
                            transferInDocItemViews.Add(new TransferInDocItemViewModel
                            {
                                remark       = model.Remark,
                                sendquantity = item.Quantity,
                                item         = new ItemViewModels
                                {
                                    articleRealizationOrder = item.ItemArticleRealizationOrder,
                                    code              = item.ItemCode,
                                    domesticCOGS      = item.ItemDomesticCOGS,
                                    domesticRetail    = item.ItemDomesticRetail,
                                    domesticSale      = item.ItemDomesticSale,
                                    domesticWholesale = item.ItemDomesticWholeSale,
                                    name              = item.ItemName,
                                    size              = item.ItemSize,
                                    uom = item.ItemUom,
                                    _id = item.ItemId,
                                }
                            });
                            isAnyTransferIn = true;
                        }
                        item.FlagForCreate(IdentityService.Username, UserAgent);
                        item.FlagForUpdate(IdentityService.Username, UserAgent);
                    }
                    transferOutDocViewModel.items = transferOutDocItemViewModels;
                    transferInDocView.items       = transferInDocItemViews;

                    if (isAnyTransferIn)
                    {
                        string warehouseUritransferin = "transfer-in/for-pos";
                        var    httpClienttarnsfer     = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService));
                        var    responsetransfer       = await httpClienttarnsfer.PostAsync($"{APIEndpoint.Warehouse}{warehouseUritransferin}", new StringContent(JsonConvert.SerializeObject(transferInDocView).ToString(), Encoding.UTF8, General.JsonMediaType));

                        responsetransfer.EnsureSuccessStatusCode();
                    }

                    string warehouseUri = "transfer-out/pos";
                    var    httpClient   = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService));
                    var    response     = await httpClient.PostAsync($"{APIEndpoint.Warehouse}{warehouseUri}", new StringContent(JsonConvert.SerializeObject(transferOutDocViewModel).ToString(), Encoding.UTF8, General.JsonMediaType));

                    response.EnsureSuccessStatusCode();

                    model.FlagForCreate(IdentityService.Username, UserAgent);
                    model.FlagForUpdate(IdentityService.Username, UserAgent);

                    DbSet.Add(model);
                    Created = await DbContext.SaveChangesAsync();

                    Created = model.Id;
                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(model);
        }
Ejemplo n.º 2
0
        //public List<SalesDocDetailReturnItem> ReadSalesReturnItem(int id)
        //{
        //    var b = DbSetSales.Where(m => m.SalesDocDetailId == id);
        //    return b.ToList();
        //}

        public async Task <int> Create(SalesDocReturn model, SalesDocReturnViewModel viewModel)
        {
            int Created = 0;

            using (var transaction = this.DbContext.Database.BeginTransaction())
            {
                try
                {
                    string   code  = GenerateCode("sales");
                    SalesDoc sales = new SalesDoc();
                    sales.Remark = viewModel.remark;
                    if (viewModel.salesDetail.bankCard != null)
                    {
                        sales.BankCardCode = viewModel.salesDetail.bankCard.code;
                        sales.BankCardId   = viewModel.salesDetail.bankCard._id;
                        sales.BankCardName = viewModel.salesDetail.bankCard.name;
                    }
                    if (viewModel.salesDetail.bank != null)
                    {
                        sales.BankCode = viewModel.salesDetail.bank.code;
                        sales.BankId   = viewModel.salesDetail.bank._id;
                        sales.BankName = viewModel.salesDetail.bank.name;
                    }
                    sales.CardAmount = viewModel.salesDetail.cardAmount;
                    sales.CardName   = viewModel.salesDetail.cardName;
                    sales.CardNumber = viewModel.salesDetail.cardNumber;
                    if (viewModel.salesDetail.cardType != null)
                    {
                        sales.CardTypeCode = viewModel.salesDetail.cardType.code;
                        sales.CardTypeId   = viewModel.salesDetail.cardType._id;
                        sales.CardTypeName = viewModel.salesDetail.cardType.name;
                    }
                    if (viewModel.salesDetail.voucher != null)
                    {
                        sales.VoucherValue = viewModel.salesDetail.voucher.value;
                    }
                    sales.CashAmount       = viewModel.salesDetail.cashAmount;
                    sales.Date             = viewModel.date;
                    sales.Discount         = 0;
                    sales.Card             = viewModel.salesDetail.card;
                    sales.PaymentType      = viewModel.salesDetail.paymentType;
                    sales.isVoid           = false;
                    sales.Shift            = viewModel.shift;
                    sales.StoreCode        = viewModel.store.Code;
                    sales.StoreId          = viewModel.store.Id;
                    sales.StoreName        = viewModel.store.Name;
                    sales.StoreStorageCode = viewModel.store.Storage.code;
                    sales.StoreStorageId   = viewModel.store.Storage._id;
                    sales.StoreStorageName = viewModel.store.Storage.name;
                    sales.SubTotal         = viewModel.subTotal;
                    sales.TotalProduct     = viewModel.totalProduct;
                    sales.GrandTotal       = viewModel.total;
                    sales.Discount         = viewModel.totalDiscount;



                    List <SalesDocDetail> docDetails = new List <SalesDocDetail>();
                    foreach (var i in viewModel.items)
                    {
                        docDetails.Add(new SalesDocDetail
                        {
                            Discount1                   = i.discount1,
                            Discount2                   = i.discount2,
                            DiscountNominal             = i.discountNominal,
                            isReturn                    = true,
                            ItemArticleRealizationOrder = i.item.item.ArticleRealizationOrder,
                            ItemCode                    = i.item.item.code,
                            ItemDomesticCOGS            = i.item.item.DomesticCOGS,
                            ItemDomesticRetail          = i.item.item.DomesticRetail,
                            ItemDomesticSale            = i.item.item.DomesticSale,
                            ItemDomesticWholeSale       = i.item.item.DomesticWholeSale,
                            ItemId          = i.item.item._id,
                            ItemName        = i.item.item.name,
                            ItemSize        = i.item.item.Size,
                            ItemUom         = i.item.item.Uom,
                            Margin          = i.margin,
                            Price           = i.price,
                            Quantity        = i.quantity,
                            Size            = i.item.item.Size,
                            SpesialDiscount = i.specialDiscount,
                            Total           = i.total
                        });
                        foreach (var retur in i.returnItems)
                        {
                            docDetails.Add(new SalesDocDetail
                            {
                                Discount1                   = retur.discount1,
                                Discount2                   = retur.discount2,
                                DiscountNominal             = retur.discountNominal,
                                isReturn                    = false,
                                ItemArticleRealizationOrder = retur.item.ArticleRealizationOrder,
                                ItemCode                    = retur.item.code,
                                ItemDomesticCOGS            = retur.item.DomesticCOGS,
                                ItemDomesticRetail          = retur.item.DomesticRetail,
                                ItemDomesticSale            = retur.item.DomesticSale,
                                ItemDomesticWholeSale       = retur.item.DomesticWholeSale,
                                ItemId          = retur.item._id,
                                ItemName        = retur.item.name,
                                ItemSize        = retur.item.Size,
                                ItemUom         = retur.item.Uom,
                                Margin          = retur.margin,
                                Price           = retur.price,
                                Quantity        = retur.quantity,
                                Size            = retur.item.Size,
                                SpesialDiscount = retur.specialDiscount,
                                Total           = retur.total
                            });
                        }
                    }
                    //foreach(var i in sales.Details)
                    //{
                    //    if(viewModel.items.Where(x=>x.item.code == i.ItemCode).Count() > 0)
                    //    {
                    //        if(viewModel.items.Single().returnItems.Count() > 0)
                    //        {
                    //            i.isReturn = true;
                    //        }
                    //    }
                    //}
                    sales.Details  = docDetails;
                    sales.isReturn = true;
                    sales.Code     = code;
                    sales.FlagForCreate(IdentityService.Username, UserAgent);
                    sales.FlagForUpdate(IdentityService.Username, UserAgent);

                    sales.isVoid = false;

                    var salesreturn = await AddSales(sales);

                    model.SalesDocReturnCode     = salesreturn.Code;
                    model.SalesDocReturnId       = salesreturn.Id;
                    model.SalesDocReturnIsReturn = sales.isReturn;
                    model.Code = sales.Code;
                    model.FlagForCreate(IdentityService.Username, UserAgent);
                    model.FlagForUpdate(IdentityService.Username, UserAgent);
                    foreach (var item in model.Details)
                    {
                        item.FlagForCreate(IdentityService.Username, UserAgent);
                        item.FlagForUpdate(IdentityService.Username, UserAgent);
                    }

                    DbSet.Add(model);
                    Created = await DbContext.SaveChangesAsync();

                    List <SalesDocDetailReturnItem> docDetail = new List <SalesDocDetailReturnItem>();
                    foreach (var i in viewModel.items)
                    {
                        var t = sales.Details.Where(x => x.ItemCode == i.item.item.code && x.ItemArticleRealizationOrder == i.item.item.ArticleRealizationOrder).Single();
                        foreach (var d in i.returnItems)
                        {
                            docDetail.Add(new SalesDocDetailReturnItem {
                                Discount1                   = d.discount1,
                                Discount2                   = d.discount2,
                                DiscountNominal             = d.discountNominal,
                                isReturn                    = true,
                                ItemArticleRealizationOrder = d.item.ArticleRealizationOrder,
                                ItemCode                    = d.item.code,
                                ItemDomesticCOGS            = d.item.DomesticCOGS,
                                ItemDomesticRetail          = d.item.DomesticRetail,
                                ItemDomesticSale            = d.item.DomesticSale,
                                ItemDomesticWholeSale       = d.item.DomesticWholeSale,
                                ItemId           = d.item._id,
                                ItemName         = d.item.name,
                                ItemSize         = d.item.Size,
                                ItemUom          = d.item.Uom,
                                Margin           = d.margin,
                                Price            = d.price,
                                Quantity         = d.quantity,
                                Size             = d.item.Size,
                                SpesialDiscount  = d.specialDiscount,
                                Total            = d.total,
                                SalesDocDetailId = t.Id,
                            });
                        }
                    }

                    Created += await AddReturnItems(docDetail);

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }
            return(model.Id);
        }