// 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); } } } }
//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); }
// 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); }
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")); }