//get one item by name public List <FormOfPaymentTypeJSON> GetFormOfPaymentTypeByName(string formOfPaymentTypeDescription) { FormOfPaymentTypeRepository formOfPaymentTypeRepository = new FormOfPaymentTypeRepository(); var result = from n in formOfPaymentTypeRepository.GetAllFormOfPaymentTypes() where n.FormOfPaymentTypeDescription.Trim().Equals(formOfPaymentTypeDescription) select new FormOfPaymentTypeJSON { FormOfPaymentTypeId = n.FormOfPaymentTypeId, FormOfPaymentTypeDescription = n.FormOfPaymentTypeDescription }; return(result.ToList()); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(FormOfPaymentAdviceMessageGroupItem formOfPaymentAdviceMessageGroupItem) { //Supplier / Product if (formOfPaymentAdviceMessageGroupItem.SupplierCode != null && formOfPaymentAdviceMessageGroupItem.ProductId > 0) { SupplierRepository supplierRepository = new SupplierRepository(); Supplier supplier = supplierRepository.GetSupplier(formOfPaymentAdviceMessageGroupItem.SupplierCode, formOfPaymentAdviceMessageGroupItem.ProductId); if (supplier != null) { formOfPaymentAdviceMessageGroupItem.SupplierName = supplier.SupplierName; } ProductRepository productRepository = new ProductRepository(); Product product = productRepository.GetProduct(formOfPaymentAdviceMessageGroupItem.ProductId); if (product != null) { formOfPaymentAdviceMessageGroupItem.ProductName = product.ProductName; } } //CountryName CountryRepository countryRepository = new CountryRepository(); Country country = countryRepository.GetCountry(formOfPaymentAdviceMessageGroupItem.CountryCode); if (country != null) { formOfPaymentAdviceMessageGroupItem.CountryName = country.CountryName; } //FormOfPaymentTypeDescription FormOfPaymentTypeRepository formOfPaymentTypeRepository = new FormOfPaymentTypeRepository(); FormOfPaymentType formOfPaymentType = formOfPaymentTypeRepository.GetFormOfPaymentType(formOfPaymentAdviceMessageGroupItem.FormofPaymentTypeID); if (formOfPaymentType != null) { formOfPaymentAdviceMessageGroupItem.FormOfPaymentTypeDescription = formOfPaymentType.FormOfPaymentTypeDescription; } //Set LanguageName to en-gb LanguageRepository languageRepository = new LanguageRepository(); Language language = languageRepository.GetLanguage("en-GB"); if (language != null) { formOfPaymentAdviceMessageGroupItem.LanguageCode = language.LanguageCode; formOfPaymentAdviceMessageGroupItem.LanguageName = language.LanguageName; } }
//Add Data From Linked Tables for Display public void EditForDisplay(ClientDetailSubProductFormOfPaymentType subProductFormOfPaymentType) { FormOfPaymentTypeRepository formOfPaymentTypeRepository = new FormOfPaymentTypeRepository(); FormOfPaymentType formOfPaymentType = new FormOfPaymentType(); formOfPaymentType = formOfPaymentTypeRepository.GetFormOfPaymentType(subProductFormOfPaymentType.FormOfPaymentTypeId); if (formOfPaymentType != null) { subProductFormOfPaymentType.FormOfPaymentTypeDescription = formOfPaymentType.FormOfPaymentTypeDescription; } SubProductRepository subProductRepository = new SubProductRepository(); SubProduct subProduct = new SubProduct(); subProduct = subProductRepository.GetSubProduct(subProductFormOfPaymentType.SubProductId); if (subProduct != null) { subProductFormOfPaymentType.SubProductName = subProduct.SubProductName; } }