コード例 #1
0
        // Discount Selling Order Stocks Count From Portofolio
        public void TransferSellingFromStocks(SellingInvoiceModel sellingInvoiceModel)
        {
            var PortofolioStocks = unitOfWork.PortfolioTransactionsRepository.Get(filter: m => m.PortfolioID == sellingInvoiceModel.PortfolioID);
            var Details          = sellingInvoiceModel.DetailsModels;

            foreach (var detail in Details)
            {
                foreach (var item in PortofolioStocks)
                {
                    if (detail.PartnerID == item.PartnerID)
                    {
                        item.CurrentStocksCount = item.CurrentStocksCount - detail.StockCount;
                        unitOfWork.PortfolioTransactionsRepository.Update(item);
                    }
                }
            }
        }
コード例 #2
0
        //Check Stocks Count Allowed For Selling Invoice  on selling Order
        public bool CheckStockCountForSellingInvoice(SellingInvoiceModel sellingInvoiceModel)
        {
            var PortofolioStocks = unitOfWork.SellingOrderDetailRepository.Get(filter: m => m.SellingOrder.PortfolioID == sellingInvoiceModel.PortfolioID);
            var Details          = sellingInvoiceModel.DetailsModels;

            foreach (var detail in Details)
            {
                if (PortofolioStocks.Any(m => m.PartnerID == detail.PartnerID && detail.StockCount <= m.StockCount))
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            return(true);
        }
コード例 #3
0
        // Calculate EntryDetails using Models Case Update
        public static List <EntryDetailModel> UpdateCalculateEntries(int portofolioaccount, int EntryID, SellingInvoiceModel sellingInvoiceModel = null,
                                                                     PurchaseInvoiceModel purchaseInvoiceModel = null, ReceiptExchangeModel receiptExchangeModel = null,
                                                                     NoticeModel noticeModel = null)
        {
            #region Definitions
            decimal TotalNet = 0, TotalBankCommision = 0, TotalTaxOnCommision = 0, TotalSTocksSales = 0, TotalSTocksPurchase = 0;
            List <EntryDetailModel> DetailListModel = new List <EntryDetailModel>();
            int        AccBankCommision = 0, AccTaxonCommision = 0, AccSalesStocks = 0, AccPuchaseStocks = 0;
            EntryModel Entrymodel = new EntryModel();

            #endregion
            #region SellingInvoice
            if (sellingInvoiceModel != null)
            {
                var SettingAccsell = sellingInvoiceModel.SettingModel.SettingAccs;
                var SellDetails    = sellingInvoiceModel.DetailsModels;
                //Get EntryDetail Accounts From Setting
                #region SettingAccounts
                foreach (var Accs in SettingAccsell)
                {
                    if (Accs.AccountType == 1)
                    {
                        AccBankCommision = Accs.AccountID;
                    }
                    else if (Accs.AccountType == 2)
                    {
                        AccTaxonCommision = Accs.AccountID;
                    }
                    else
                    {
                        AccSalesStocks = Accs.AccountID;
                    }
                }
                #endregion

                #region Calculate EntryDetailsValues
                if (SellDetails != null)
                {
                    foreach (var item in SellDetails)
                    {
                        TotalNet            += item.NetAmmount;
                        TotalBankCommision  += item.BankCommission;
                        TotalTaxOnCommision += item.TaxOnCommission;
                        TotalSTocksSales    += item.SelingValue;
                    }
                }
                #endregion


                #region EntryDetails
                //Add Debit Accounts with values
                #region Debit
                EntryDetailModel DetailModel1 = new EntryDetailModel();
                DetailModel1.Debit     = TotalNet;
                DetailModel1.AccountID = portofolioaccount;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel1);
                EntryDetailModel DetailModel2 = new EntryDetailModel();
                DetailModel2.Debit     = TotalBankCommision;
                DetailModel2.AccountID = AccBankCommision;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel2);
                EntryDetailModel DetailModel3 = new EntryDetailModel();
                DetailModel3.Debit     = TotalTaxOnCommision;
                DetailModel3.AccountID = AccTaxonCommision;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel3);
                #endregion

                //Add Credit Accounts with values
                #region Credit
                EntryDetailModel DetailModel4 = new EntryDetailModel();
                DetailModel4.Credit    = TotalSTocksSales;
                DetailModel4.AccountID = AccSalesStocks;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel4);
                #endregion

                #endregion
            }
            #endregion
            #region PurchaseInvoice
            if (purchaseInvoiceModel != null)
            {
                var SettingAccpurchase = purchaseInvoiceModel.SettingModel.SettingAccs;
                var PurchaseDetails    = purchaseInvoiceModel.DetailsModels;
                //Get EntryDetail Accounts From Setting
                #region SettingAccounts
                foreach (var Accs in SettingAccpurchase)
                {
                    if (Accs.AccountType == 1)
                    {
                        AccPuchaseStocks = Accs.AccountID;
                    }
                    else if (Accs.AccountType == 2)
                    {
                        AccBankCommision = Accs.AccountID;
                    }
                    else
                    {
                        AccTaxonCommision = Accs.AccountID;
                    }
                }
                #endregion

                #region Calculate EntryDetailsValues
                if (PurchaseDetails != null)
                {
                    foreach (var item in PurchaseDetails)
                    {
                        TotalNet            += item.NetAmmount;
                        TotalBankCommision  += item.BankCommission;
                        TotalTaxOnCommision += item.TaxOnCommission;
                        TotalSTocksPurchase += item.PurchaseValue;
                    }
                }
                #endregion



                #region EntryDetails
                //Add Debit Accounts with values
                #region Debit
                EntryDetailModel DetailModel1 = new EntryDetailModel();
                DetailModel1.Debit     = TotalNet;
                DetailModel1.AccountID = AccPuchaseStocks;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel1);
                EntryDetailModel DetailModel2 = new EntryDetailModel();
                DetailModel2.Debit     = TotalBankCommision;
                DetailModel2.AccountID = AccBankCommision;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel2);
                EntryDetailModel DetailModel3 = new EntryDetailModel();
                DetailModel3.Debit     = TotalTaxOnCommision;
                DetailModel3.AccountID = AccTaxonCommision;
                DetailModel1.EntryID   = EntryID;
                DetailListModel.Add(DetailModel3);
                #endregion

                //Add Credit Accounts with values
                #region Credit

                EntryDetailModel DetailModel4 = new EntryDetailModel();
                DetailModel4.Credit    = TotalSTocksPurchase;
                DetailModel4.AccountID = portofolioaccount;
                DetailModel4.EntryID   = EntryID;
                DetailListModel.Add(DetailModel4);
                #endregion

                #endregion
            }
            #endregion
            #region ReceiptExchange
            if (receiptExchangeModel != null)
            {
                #region ReceiptExchange


                var ReceiptExchangeDetails = receiptExchangeModel.RecExcDetails;


                #region EntryDetails
                if (ReceiptExchangeDetails != null)
                {
                    foreach (var item in ReceiptExchangeDetails)
                    {
                        if (item.Debit != null)
                        {
                            //Add Debit Accounts with values
                            #region Debit
                            EntryDetailModel DetailModel = new EntryDetailModel();
                            DetailModel.Debit     = item.Debit;
                            DetailModel.AccountID = item.AccountID;
                            DetailModel.EntryID   = EntryID;
                            DetailListModel.Add(DetailModel);
                            #endregion
                        }
                        if (item.Credit != null)
                        {
                            //Add Credit Accounts with values
                            #region Credit
                            EntryDetailModel DetailModel = new EntryDetailModel();
                            DetailModel.Credit    = item.Credit;
                            DetailModel.AccountID = item.AccountID;
                            DetailModel.EntryID   = EntryID;
                            DetailListModel.Add(DetailModel);
                            #endregion
                        }
                    }
                }

                #endregion

                #endregion
            }
            #endregion
            #region NoticeDebitCredit
            if (noticeModel != null)
            {
                #region DebitCredit


                var NoticeDetails = noticeModel.NoticeModelDetails;


                #region EntryDetails
                if (NoticeDetails != null)
                {
                    foreach (var item in NoticeDetails)
                    {
                        if (item.Debit != null || item.StocksDebit != null)
                        {
                            //Add Debit Accounts with values
                            #region Debit
                            EntryDetailModel DetailModel = new EntryDetailModel();
                            DetailModel.Debit = item.Debit;
                            if (item.StocksDebit != null)
                            {
                                DetailModel.StocksDebit = item.StocksDebit;
                            }
                            DetailModel.AccountID = item.AccountID;
                            DetailModel.EntryID   = EntryID;
                            DetailListModel.Add(DetailModel);
                            #endregion
                        }
                        if (item.Credit != null || item.StocksCredit != null)
                        {
                            //Add Credit Accounts with values
                            #region Credit
                            EntryDetailModel DetailModel = new EntryDetailModel();
                            DetailModel.Credit = item.Credit;
                            if (item.StocksCredit != null)
                            {
                                DetailModel.StocksCredit = item.StocksCredit;
                            }
                            DetailModel.AccountID = item.AccountID;
                            DetailModel.EntryID   = EntryID;
                            DetailListModel.Add(DetailModel);
                            #endregion
                        }
                    }
                }

                #endregion

                #endregion
            }
            #endregion
            return(DetailListModel);
        }
コード例 #4
0
        public IActionResult Search(int TableNum, string Code)
        {
            switch (TableNum)
            {
                #region Purchase Invoice
            case 1:
                var PurchaseInvoiceEntitylist = unitOfWork.PurchaseInvoiceRepository.Get(filter: a => a.Code == Code).SingleOrDefault();
                if (PurchaseInvoiceEntitylist != null)
                {
                    PurchaseInvoiceModel purchaseInvoiceModel = new PurchaseInvoiceModel();
                    purchaseInvoiceModel.Code         = PurchaseInvoiceEntitylist.Code;
                    purchaseInvoiceModel.PurchaseDate = PurchaseInvoiceEntitylist.Date.Value.ToString("d/M/yyyy");

                    purchaseInvoiceModel.PurchaseDateHijri = DateHelper.GetHijriDate(PurchaseInvoiceEntitylist.Date);

                    //var EmplyeeEntity = unitOfWork.EmployeeRepository.Get(filter: e => e.EmployeeID == purchaseInvoiceModel.EmployeeID).SingleOrDefault();
                    //purchaseInvoiceModel.EmpCode = EmplyeeEntity.Code;
                    //purchaseInvoiceModel.EmpNameAR = EmplyeeEntity.NameAR;
                    //purchaseInvoiceModel.EmpNameEN = EmplyeeEntity.NameEN;
                    purchaseInvoiceModel.EmployeeID = PurchaseInvoiceEntitylist.EmployeeID;
                    purchaseInvoiceModel.EmpNameAR  = PurchaseInvoiceEntitylist.Employee.NameAR;
                    purchaseInvoiceModel.EmpCode    = PurchaseInvoiceEntitylist.Employee.Code;


                    var id = unitOfWork.PurchaseOrderRepository.GetEntity(filter: a => a.PurchaseOrderID == PurchaseInvoiceEntitylist.PurchaseOrderID).PortfolioID;
                    var PortfolioEntity = unitOfWork.PortfolioRepository.GetEntity(filter: p => p.PortfolioID == id);
                    purchaseInvoiceModel.PortfolioCode   = PortfolioEntity.Code;
                    purchaseInvoiceModel.PortfolioNameAR = PortfolioEntity.NameAR;
                    purchaseInvoiceModel.PortfolioNameEN = PortfolioEntity.NameEN;

                    purchaseInvoiceModel.PortfolioAccount = unitOfWork.PortfolioAccountRepository.GetEntity(filter: s => s.PortfolioID == id).AccountID;

                    purchaseInvoiceModel.DetailsModels = unitOfWork.PurchaseInvoiceDetailRepository.Get(filter: z => z.PurchaseInvoiceID == PurchaseInvoiceEntitylist.PurchaseInvoiceID).Select(a => new PurchaseInvoiceDetailModel {
                        BankCommission          = a.BankCommission,
                        BankCommissionRate      = a.BankCommissionRate,
                        NetAmmount              = a.NetAmmount,
                        PartnerCode             = a.Partner.Code,
                        PartnerID               = a.PartnerID,
                        PartnerNameAR           = a.Partner.NameAR,
                        PartnerNameEN           = a.Partner.NameEN,
                        PurchaseInvoiceDetailID = a.PurchaseInvoiceDetailID,
                        PurchaseInvoiceID       = a.PurchaseInvoiceID,
                        PurchasePrice           = a.PurchasePrice,
                        PurchaseValue           = a.PurchaseValue,
                        StockCount              = a.StockCount,
                        TaxOnCommission         = a.TaxOnCommission,
                        TaxRateOnCommission     = a.TaxRateOnCommission,
                    });
                    decimal?oldNetAmmount = 0.0m;
                    foreach (var item in purchaseInvoiceModel.DetailsModels)
                    {
                        oldNetAmmount += item.NetAmmount;
                    }

                    purchaseInvoiceModel.newRialBalance  = _stocksHelper.RialBalancUpdate(PurchaseInvoiceEntitylist.PurchaseOrder.PortfolioID, oldNetAmmount);
                    purchaseInvoiceModel.PurchaseOrderID = PurchaseInvoiceEntitylist.PurchaseOrderID;


                    purchaseInvoiceModel.SettingModel = GetSetting(2);

                    var EntryPurchaseInvoiceEntitylist = unitOfWork.EntryRepository.Get(filter: a => a.PurchaseInvoiceID == purchaseInvoiceModel.PurchaseInvoiceID);
                    purchaseInvoiceModel.EntryModel = _mapper.Map <EntryModel>(EntryPurchaseInvoiceEntitylist.SingleOrDefault());
                    if (EntryPurchaseInvoiceEntitylist.Count() > 0)
                    {
                        var EntryDitailsPurchaseInvoiceEntitylist = unitOfWork.EntryDetailRepository.Get(filter: d => d.EntryID == purchaseInvoiceModel.EntryModel.EntryID);
                        purchaseInvoiceModel.EntryModel.EntryDetailModel = _mapper.Map <IEnumerable <EntryDetailModel> >(EntryDitailsPurchaseInvoiceEntitylist);
                    }

                    return(Ok(purchaseInvoiceModel));
                }
                else
                {
                    return(Ok(0));
                }


                #endregion

                #region selling Invoice
            case 2:
                var SellingInvoiceEntitylist = unitOfWork.SellingInvoiceReposetory.Get(NoTrack: "NoTrack", filter: a => a.Code == Code).SingleOrDefault();
                if (SellingInvoiceEntitylist.Code != null)
                {
                    SellingInvoiceModel SellingInvoiceModel = new SellingInvoiceModel();
                    SellingInvoiceModel = _mapper.Map <SellingInvoiceModel>(SellingInvoiceEntitylist);

                    SellingInvoiceModel.SellDate      = SellingInvoiceEntitylist.Date.Value.ToString("d/M/yyyy");
                    SellingInvoiceModel.SellDateHijri = DateHelper.GetHijriDate(SellingInvoiceEntitylist.Date);

                    var EmplyeeEntity = unitOfWork.EmployeeRepository.Get(filter: e => e.EmployeeID == SellingInvoiceModel.EmployeeID).SingleOrDefault();
                    SellingInvoiceModel.EmpCode   = EmplyeeEntity.Code;
                    SellingInvoiceModel.EmpNameAR = EmplyeeEntity.NameAR;
                    SellingInvoiceModel.EmpCode   = EmplyeeEntity.NameEN;
                    var id = unitOfWork.SellingOrderRepository.GetEntity(filter: x => x.SellingOrderID == SellingInvoiceEntitylist.SellingOrderID).PortfolioID;
                    var PortfolioEntity = unitOfWork.PortfolioRepository.Get(filter: p => p.PortfolioID == id).SingleOrDefault();
                    SellingInvoiceModel.PortfolioCode   = PortfolioEntity.Code;
                    SellingInvoiceModel.PortfolioNameAR = PortfolioEntity.NameAR;
                    SellingInvoiceModel.PortfolioNameEN = PortfolioEntity.NameEN;

                    SellingInvoiceModel.PortfolioAccount = unitOfWork.PortfolioAccountRepository.GetEntity(filter: s => s.PortfolioID == id).AccountID;

                    SellingInvoiceModel.DetailsModels = unitOfWork.SellingInvoiceDetailRepository.Get(filter: z => z.SellingInvoiceID == SellingInvoiceEntitylist.SellingInvoiceID).Select(a => new SellingInvoiceDetailsModel {
                        BankCommission         = a.BankCommission,
                        BankCommissionRate     = a.BankCommissionRate,
                        NetAmmount             = a.NetAmmount,
                        PartnerCode            = a.Partner.Code,
                        PartnerID              = a.PartnerID,
                        PartnerNameAR          = a.Partner.NameAR,
                        PartnerNameEN          = a.Partner.NameEN,
                        SelingValue            = a.SelingValue,
                        SellingInvoiceDetailID = a.SellInvoiceDetailID,
                        SellingInvoiceID       = a.SellingInvoiceID,
                        SellingPrice           = a.SellingPrice,
                        StockCount             = a.StockCount,
                        StocksCount            = a.StockCount,
                        TaxRateOnCommission    = a.TaxRateOnCommission,
                        TaxOnCommission        = a.TaxOnCommission,
                    });


                    SellingInvoiceModel.SettingModel = GetSetting(1);


                    var EntrySellingInvoiceEntitylist = unitOfWork.EntryRepository.Get(filter: a => a.SellingInvoiceID == SellingInvoiceModel.SellingInvoiceID);
                    SellingInvoiceModel.EntryModel = _mapper.Map <EntryModel>(EntrySellingInvoiceEntitylist.SingleOrDefault());
                    if (EntrySellingInvoiceEntitylist.Count() > 0)
                    {
                        var EntryDitailsSellingInvoiceEntitylist = unitOfWork.EntryDetailRepository.Get(filter: d => d.EntryID == SellingInvoiceModel.EntryModel.EntryID);
                        SellingInvoiceModel.EntryModel.EntryDetailModel = _mapper.Map <IEnumerable <EntryDetailModel> >(EntryDitailsSellingInvoiceEntitylist);
                    }
                    return(Ok(SellingInvoiceModel));
                }
                else
                {
                    return(Ok(0));
                }
                #endregion



                #region Notice Creditor
            case 3:
                var NoticeCreditorEntityList = unitOfWork.NoticeRepository.Get(filter: a => a.Code == Code && a.Type == false);
                if (NoticeCreditorEntityList.Count() > 0)
                {
                    NoticeModel noticeModel = new NoticeModel();
                    noticeModel = GetNotice(NoticeCreditorEntityList.SingleOrDefault(), false);
                    return(Ok(noticeModel));
                }
                else
                {
                    return(Ok(0));
                }
                #endregion

                #region Notice Debitor
            case 4:
                var NoticeDebitorEntityList = unitOfWork.NoticeRepository.Get(filter: a => a.Code == Code && a.Type == true);
                if (NoticeDebitorEntityList.Count() > 0)
                {
                    NoticeModel noticeModel = new NoticeModel();
                    noticeModel = GetNotice(NoticeDebitorEntityList.SingleOrDefault(), true);
                    return(Ok(noticeModel));
                }
                else
                {
                    return(Ok(0));
                }
                #endregion

                #region  Receipt voucher Ryal
            case 5:
            {
                var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.GetEntity(filter: x => x.Code == Code && x.Type == false && x.ReceiptExchangeType == true);
                if (ReceiptExchangeEntitylist != null)
                {
                    ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
                    receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 5);
                    return(Ok(receiptExchangeModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion

                #region  Receipt voucher chique
            case 6:
            {
                var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.Get(filter: x => x.Code == Code && x.Type == false && x.ReceiptExchangeType == false).FirstOrDefault();
                if (ReceiptExchangeEntitylist != null)
                {
                    ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
                    receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 5);
                    return(Ok(receiptExchangeModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion


                #region  Exchange voucher Ryal
            case 7:
            {
                var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.Get(filter: x => x.Code == Code && x.ReceiptExchangeType == true && x.Type == true);
                if (ReceiptExchangeEntitylist.Count() > 0)
                {
                    ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
                    receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist.SingleOrDefault(), 6);
                    return(Ok(receiptExchangeModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion

                #region  Exchange voucher chique
            case 8:
            {
                var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.GetEntity(filter: x => x.Code == Code && x.Type == true && x.ReceiptExchangeType == false);
                if (ReceiptExchangeEntitylist != null)
                {
                    ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
                    receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 6);
                    return(Ok(receiptExchangeModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion

                #region Country
            case 9:
            {
                var CountryEntityList = unitOfWork.CountryRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
                if (CountryEntityList.Count() > 0)
                {
                    CountryModel countryModel = _mapper.Map <CountryModel>(CountryEntityList.SingleOrDefault());
                    return(Ok(countryModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion


                #region Account
            case 10:
            {
                var AccountEntityList = unitOfWork.AccountRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
                if (AccountEntityList.Count() > 0)
                {
                    AccountModel AccountModel = _mapper.Map <AccountModel>(AccountEntityList.SingleOrDefault());
                    return(Ok(AccountModel));
                }
                else
                {
                    return(Ok(0));
                }
            }

                #endregion
                #region Employee
            case 11:
            {
                var EmployeeEntityList = unitOfWork.EmployeeRepository.GetEntity(filter: x => x.Code == Code);
                if (EmployeeEntityList != null)
                {
                    string        date          = EmployeeEntityList.BirthDate.Value.ToString("d/M/yyyy");
                    EmployeeModel EmployeeModel = _mapper.Map <EmployeeModel>(EmployeeEntityList);
                    EmployeeModel.BirthDate = date;
                    var EmployCardsEntityList = unitOfWork.EmployeeCardRepository.Get(filter: x => x.EmployeeID == EmployeeModel.EmployeeID);
                    EmployeeModel.emplCards = _mapper.Map <IEnumerable <EmployeeCardModel> >(EmployCardsEntityList);
                    return(Ok(EmployeeModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion

                #region Partner
            case 12:
            {
                var PartnerEntityList = unitOfWork.PartnerRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
                if (PartnerEntityList != null)
                {
                    string        date         = PartnerEntityList.Date.ToString("d/M/yyyy");
                    string        IssueDate    = PartnerEntityList.IssueDate.Value.ToString("d/M/yyyy");
                    PartenerModel partnerModel = _mapper.Map <PartenerModel>(PartnerEntityList);
                    partnerModel.Date      = date;
                    partnerModel.IssueDate = IssueDate;
                    var Countries = unitOfWork.CountryRepository.Get(filter: x => x.CountryID == partnerModel.CountryID);
                    partnerModel.Countries = _mapper.Map <IEnumerable <CountryModel> >(Countries);
                    IEnumerable <PortfolioTransaction> StocksCountList = unitOfWork.PortfolioTransactionsRepository.Get(filter: x => x.PartnerID == partnerModel.PartnerID);
                    partnerModel.StocksCount = 0;
                    for (int ii = 0; ii < StocksCountList.Count(); ii++)
                    {
                        partnerModel.StocksCount += StocksCountList.ElementAt(ii).CurrentStocksCount;
                    }

                    return(Ok(partnerModel));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion

                #region portfolio
            case 13:
            {
                var PortfolioEntityList = unitOfWork.PortfolioRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
                if (PortfolioEntityList.Count() > 0)
                {
                    return(Ok(GetPortfolio(PortfolioEntityList.SingleOrDefault())));
                }
                else
                {
                    return(Ok(0));
                }
            }
                #endregion


                #region selling Order


            case 14:
            {
                var sellingorder = unitOfWork.SellingOrderRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
                var model        = _mapper.Map <SellingOrderModel>(sellingorder);
                if (sellingorder != null)
                {
                    #region Date part
                    if (sellingorder.OrderDate != null)
                    {
                        model.OrderDateGorg  = sellingorder.OrderDate.ToString("d/M/yyyy");
                        model.OrderDateHigri = DateHelper.GetHijriDate(sellingorder.OrderDate);
                    }



                    #endregion

                    #region  Details
                    var Details = unitOfWork.SellingOrderDetailRepository

                                  .Get(filter: m => m.SellingOrderID == sellingorder.SellingOrderID)
                                  .Select(m => new SellingOrderDetailModel
                        {
                            PartnerID         = m.PartnerID,
                            PartnerNameAr     = m.Partner.NameAR,
                            PriceType         = m.PriceType,
                            SellingOrderID    = m.SellingOrderID,
                            SellOrderDetailID = m.SellOrderDetailID,
                            StockCount        = m.StockCount,
                            TradingValue      = m.TradingValue,
                            PartnerCode       = m.Partner.Code
                        });



                    if (Details != null)
                    {
                        model.sellingOrderDetailModels = Details;
                    }

                    #endregion
                    model.Count         = unitOfWork.SellingOrderRepository.Count();
                    model.Portfoliocode = unitOfWork.PortfolioRepository.GetEntity(filter: a => a.PortfolioID == sellingorder.PortfolioID).Code;

                    return(Ok(model));
                }
                else
                {
                    return(Ok(0));
                }
            }



                #endregion

                #region  Order


            case 15:
            {
                var Purchaseorder = unitOfWork.PurchaseOrderRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
                var model         = _mapper.Map <PurchaseOrderModel>(Purchaseorder);

                #region Date part
                if (Purchaseorder.OrderDate != null)
                {
                    model.OrderDate      = Purchaseorder.OrderDate.ToString("d/M/yyyy");
                    model.OrderDateHijri = DateHelper.GetHijriDate(Purchaseorder.OrderDate);
                }



                #endregion

                #region  Details
                var Details = unitOfWork.PurchaseOrderDetailRepository

                              .Get(filter: m => m.PurchaseOrderID == Purchaseorder.PurchaseOrderID)
                              .Select(m => new PurchaseOrderDetailModel
                    {
                        PartnerID             = m.PartnerID,
                        PartnerNameAr         = m.Partner.NameAR,
                        PriceType             = m.PriceType,
                        PurchaseOrderID       = m.PurchaseOrderID,
                        PurchaseOrderDetailID = m.PurchaseOrderDetailID,
                        StockCount            = m.StockCount,
                        TradingValue          = m.TradingValue,
                        PartnerCode           = m.Partner.Code
                    });



                if (Details != null)
                {
                    model.purchaseordersDetailsModels = Details;
                }

                #endregion
                model.Count         = unitOfWork.PurchaseOrderRepository.Count();
                model.Portfoliocode = unitOfWork.PortfolioRepository.GetEntity(filter: a => a.PortfolioID == Purchaseorder.PortfolioID).Code;

                return(Ok(model));
            }



                #endregion
            }
            return(Ok("Error Table Number"));
        }