public List <DepartmentEntity> GetDepartments(string connectionString)
{
List <DepartmentEntity> listDepartment = new List <DepartmentEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.Departments.ToList().OrderBy(x => x.Grade);
foreach (var result in categories)
{
var department = new DepartmentEntity();
department.DepartmentId = result.DepartmentID.ToString();
department.DepartmentCode = result.DepartmentCode;
department.DepartmentName = result.DepartmentName;
department.ParentId = result.ParentID.ToString();
department.Grade = result.Grade;
department.IsParent = result.IsParent;
department.Description = result.Description;
department.IsActive = result.Inactive == true ? false : true;
listDepartment.Add(department);
}
}
return(listDepartment);
}
public List <BudgetItemEntity> GetBudgetItem(string connectionString)
{
List <BudgetItemEntity> listBudgetItem = new List <BudgetItemEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstBudgetItem = context.BudgetItems.ToList().OrderBy(x => x.Grade);
foreach (var result in lstBudgetItem)
{
var budgetItem = new BudgetItemEntity();
budgetItem.BudgetItemId = result.BudgetItemID.ToString();
budgetItem.ParentId = result.ParentID.ToString();
budgetItem.BudgetItemType = result.BudgetItemType;
budgetItem.BudgetItemCode = result.BudgetItemCode;
budgetItem.BudgetItemName = result.BudgetItemName;
budgetItem.BudgetGroupItemCode = result.BudgetGroupItemCode;
budgetItem.Grade = result.Grade;
budgetItem.IsParent = result.IsParent;
budgetItem.IsActive = result.Inactive == true ?false:true;
listBudgetItem.Add(budgetItem);
}
}
return(listBudgetItem);
}
public List <BankEntity> GetBank(string connectionString)
{
List <BankEntity> listAccount = new List <BankEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.BankInfoes.ToList();
foreach (var result in categories)
{
var bank = new BankEntity();
bank.BankId = result.BankInfoID.ToString();
bank.BankAccount = result.BankAccount;
bank.BankName = result.BankName;
bank.BankAddress = result.BankAddress;
bank.Description = result.Description;
bank.IsActive = result.Inactive == true?false:true;
bank.IsOpenInBank = result.OpenInBudget == true?false:true;
listAccount.Add(bank);
}
}
return(listAccount);
}
public List <ActivityEntity> GetActivity(string connectionString)
{
List <ActivityEntity> listActivity = new List <ActivityEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.Activities.ToList();
foreach (var result in categories)
{
var activity = new ActivityEntity();
activity.ActivityId = result.ActivityID.ToString();
activity.ActivityCode = result.ActivityCode;
activity.ActivityName = result.ActivityName;
activity.ParentID = result.ParentID.ToString();
activity.Grade = result.Grade;
activity.IsParent = result.IsParent;
activity.IsSystem = result.IsSystem;
activity.IsActive = result.Inactive == true?false:true;
listActivity.Add(activity);
}
}
return(listActivity);
}
public List <AccountTransferEntity> GetAccountsTransfer(string connectionString)
{
List <AccountTransferEntity> listAccount = new List <AccountTransferEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.AccountTransfers.ToList();
foreach (var result in categories)
{
var accountTransfer = new AccountTransferEntity();
accountTransfer.AccountTransferId = result.AccountTransferID.ToString();
accountTransfer.BusinessType = (result.BusinessType == 4?2: result.BusinessType) ?? 0;
accountTransfer.AccountTransferCode = result.AccountTransferCode;
accountTransfer.ReferentAccount = result.ReferentAccount;
accountTransfer.TransferOrder = result.TransferOrder ?? 0;
accountTransfer.FromAccount = result.FromAccount;
accountTransfer.ToAccount = result.ToAccount;
accountTransfer.TransferSide = result.TransferSide ?? 0;
accountTransfer.BudgetSourceId = result.BudgetSourceID.ToString();
accountTransfer.Description = result.Description;
accountTransfer.IsSystem = result.IsSystem;
accountTransfer.IsActive = result.Inactive == true ? false:true;
listAccount.Add(accountTransfer);
}
}
return(listAccount);
}
public List <BudgetKindItemEntity> GetBudgetKindItem(string connectionString)
{
List <BudgetKindItemEntity> listBudgetKindItem = new List <BudgetKindItemEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstBudgetKindItem = context.BudgetKindItems.ToList();
foreach (var result in lstBudgetKindItem)
{
var budgetKindItem = new BudgetKindItemEntity();
budgetKindItem.BudgetKindItemId = result.BudgetKinditemID.ToString();
budgetKindItem.ParentId = result.ParentID.ToString();
budgetKindItem.BudgetKindItemCode = result.BudgetKindItemCode;
budgetKindItem.BudgetKindItemName = result.BudgetKindItemName;
budgetKindItem.Grade = result.Grade;
budgetKindItem.IsParent = result.IsParent;
budgetKindItem.IsActive = result.Active;
listBudgetKindItem.Add(budgetKindItem);
}
}
return(listBudgetKindItem);
}
public List <InventoryItemCategoryEntity> GetInventoryItemsCategory(string connectionString)
{
List <InventoryItemCategoryEntity> listInventoryCategory = new List <InventoryItemCategoryEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.InventoryItemCategories.ToList().OrderBy(x => x.Grade);
foreach (var result in categories)
{
var inventoryItemCategory = new InventoryItemCategoryEntity();
inventoryItemCategory.InventoryItemCategoryId = result.InventoryCategoryID.ToString();
inventoryItemCategory.InventoryItemCategoryCode = result.InventoryCategoryCode;
inventoryItemCategory.InventoryItemCategoryName = result.InventoryCategoryName;
inventoryItemCategory.ParentId = result.ParentID.ToString();
inventoryItemCategory.Grade = result.Grade;
inventoryItemCategory.IsParent = result.IsParent;
inventoryItemCategory.IsTool = result.IsTool;
inventoryItemCategory.IsSystem = result.IsSystem;
inventoryItemCategory.IsActive = result.Inactive == true ?false:true;
listInventoryCategory.Add(inventoryItemCategory);
}
}
return(listInventoryCategory);
}
public List <FundStructureEntity> GetFundStructure(string connectionString)
{
List <FundStructureEntity> listfFundStructure = new List <FundStructureEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.FundStructures.ToList();
foreach (var result in categories)
{
var fundStructure = new FundStructureEntity();
fundStructure.FundStructureId = result.FundStructureID.ToString();
fundStructure.FundStructureCode = result.FundStructureCode;
fundStructure.FundStructureName = result.FundStructureName;
fundStructure.BUCACodeId = result.MISACodeID;
fundStructure.ParentId = result.ParentID.ToString();
fundStructure.Grade = result.Grade;
fundStructure.IsParent = result.IsParent;
fundStructure.Inactive = result.Inactive == true?false:true;
fundStructure.IsSystem = result.IsSystem;
fundStructure.InvestmentPeriod = result.InvestmentPeriod;
listfFundStructure.Add(fundStructure);
}
}
return(listfFundStructure);
}
//private List<BankInfo> banks;
public List <OpeningFixedAssetEntryEntity> GetOpeningFixedAssetEntrys(string connectionString)
{
List <OpeningFixedAssetEntryEntity> buentity = new List <OpeningFixedAssetEntryEntity>();
using (var context = new MISAEntity(connectionString))
{
//var querry = context.OpeningFixedAssetEntryDetails.ToList();
//var projects = context.Projects.ToList();
//var currencys = context.CCies.ToList();
//var budgetsource = context.BudgetSources.ToList();
//var listitems = context.ListItems.ToList();
//var funds = context.Funds.ToList();
//var fundstructures = context.FundStructures.ToList();
//var budgetproviders = context.BudgetProvidences.ToList();
//var accountingobject = context.AccountingObjects.ToList();
//var projectexpenses = context.ProjectExpenses.ToList();
//var activity = context.Activities.ToList();
//var tasks = context.Tasks.ToList();
//var topics = context.Topics.ToList();
//banks = context.BankInfoes.ToList();
var department = context.Departments.ToList();
var resultcontext = context.OpeningFixedAssetEntries.ToList();
var fixedasset = context.FixedAssets.ToList();
//var inventoryitems = context.InventoryItems.ToList();
//var stocks = context.Stocks.ToList();
//var invoiceformnumber = context.InvoiceFormNumbers.ToList();
foreach (var result in resultcontext)
{
var newresult = new OpeningFixedAssetEntryEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = result.RefType;
newresult.PostedDate = result.PostedDate;
newresult.CurrencyCode = result.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate ?? 0;
newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString();
newresult.DepartmentId = result.DepartmentID.ToString();
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.OrgPriceAccount = result.OrgPriceAccount;
newresult.OrgPriceDebitAmountOC = result.OrgPriceDebitAmountOC ?? 0;
newresult.OrgPriceDebitAmount = result.OrgPriceDebitAmount ?? 0;
newresult.DepreciationAccount = result.DepreciationAccount;
newresult.DepreciationCreditAmountOC = result.DepreciationCreditAmountOC ?? 0;
newresult.DepreciationCreditAmount = result.DepreciationCreditAmount ?? 0;
newresult.CapitalAccount = result.CapitalAccount;
newresult.CapitalCreditAmountOC = result.CapitalCreditAmountOC ?? 0;
newresult.CapitalCreditAmount = result.CapitalCreditAmount ?? 0;
//newresult.e = result.EditVersion;
//newresult.po = result.PostVersion;
newresult.SortOrder = result.SortOrder ?? 0;
newresult.DevaluationCreditAmount = result.DevaluationCreditAmount ?? 0;
buentity.Add(newresult);
}
}
return(buentity);
}
public List <BudgetSourceEntity> GetBudgetSource(string connectionString)
{
List <BudgetSourceEntity> listBudgetSource = new List <BudgetSourceEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstBudgetProperties = context.BudgetSourceProperties.ToList();
var lstBudgetSource = context.BudgetSources.ToList().OrderBy(x => x.Grade);
foreach (var result in lstBudgetSource)
{
var budgetSource = new BudgetSourceEntity();
budgetSource.BudgetSourceId = result.BudgetSourceID.ToString();
budgetSource.BudgetSourceCode = result.BudgetSourceCode;
budgetSource.BudgetSourceName = result.BudgetSourceName;
budgetSource.ParentId = result.ParentID.ToString();
budgetSource.IsParent = result.IsParent;
budgetSource.BudgetSourceCategoryId = "ea7f3053-ed52-4048-9659-027481d03d25";
budgetSource.BudgetSourceProperty = 0;
budgetSource.IsSelfControl = true;
budgetSource.IsActive = result.Inactive == true ? false : true;
budgetSource.Grade = result.Grade;
budgetSource.BudgetCode = result.BudgetDistributionCode;
if (result.BudgetSourceProperty == null)
{
budgetSource.BudgetSourceType = 0;
}
else
{
switch (result.BudgetSourceProperty.GroupPropertyID)
{
case 0:
budgetSource.BudgetSourceType = 2;
break;
case 1:
budgetSource.BudgetSourceType = 0;
break;
case 2:
budgetSource.BudgetSourceType = 1;
break;
}
}
listBudgetSource.Add(budgetSource);
}
}
return(listBudgetSource);
}
public List <AutoBusinessParallelEntity> GetAutoBusinessPararellel(string connectionString)
{
List <AutoBusinessParallelEntity> listAutoBusinessPararell = new List <AutoBusinessParallelEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstAutoBusinessDetail = context.AutoBusinessDetails.ToList();
var lstAutoBusinessParallelDetail = context.AutoBusinessParalellDetails.ToList();
var lstAutoBusiness = context.AutoBusinesses.ToList().OrderBy(o => o.AutoBusinessID);
int i = 0;
foreach (var autoBusiness in lstAutoBusiness)
{
foreach (var autoBusinessDetail in autoBusiness.AutoBusinessDetails)
{
i = i + 1;
foreach (var autoBussinessParallel in autoBusiness.AutoBusinessParalellDetails)
{
var autoBusinessParallelDetail = new AutoBusinessParallelEntity();
autoBusinessParallelDetail.AutoBusinessParallelId = Guid.NewGuid().ToString();
autoBusinessParallelDetail.AutoBusinessCode = i.ToString();
autoBusinessParallelDetail.AutoBusinessName = autoBusiness.AutoBusinessName;
autoBusinessParallelDetail.Description = autoBussinessParallel.Description;
autoBusinessParallelDetail.IsActive = autoBusiness.Inactive == true ? false : true;
autoBusinessParallelDetail.DebitAccount = autoBusinessDetail.DebitAccount;
autoBusinessParallelDetail.CreditAccount = autoBusinessDetail.CreditAccount;
autoBusinessParallelDetail.BudgetSourceId = autoBusinessDetail.BudgetSourceID.ToString();
autoBusinessParallelDetail.BudgetChapterCode = autoBusinessDetail.BudgetChapterCode;
autoBusinessParallelDetail.BudgetKindItemCode = autoBusinessDetail.BudgetKindItemCode;
autoBusinessParallelDetail.BudgetSubKindItemCode = autoBusinessDetail.BudgetSubKindItemCode;
autoBusinessParallelDetail.BudgetItemCode = autoBusinessDetail.BudgetItemCode;
autoBusinessParallelDetail.BudgetSubItemCode = autoBusinessDetail.BudgetSubItemCode;
autoBusinessParallelDetail.MethodDistributeId = autoBusinessDetail.MethodDistributeID;
autoBusinessParallelDetail.CashWithDrawTypeId = autoBusinessDetail.CashWithDrawTypeID;
autoBusinessParallelDetail.DebitAccountParallel = autoBussinessParallel.DebitAccount;
autoBusinessParallelDetail.CreditAccountParallel = autoBussinessParallel.CreditAccount;
autoBusinessParallelDetail.BudgetSourceIdParallel = autoBussinessParallel.BudgetSourceID.ToString();
autoBusinessParallelDetail.BudgetChapterCodeParallel = autoBussinessParallel.BudgetChapterCode;
autoBusinessParallelDetail.BudgetKindItemCodeParallel = autoBussinessParallel.BudgetKindItemCode;
autoBusinessParallelDetail.BudgetSubKindItemCodeParallel = autoBussinessParallel.BudgetSubKindItemCode;
autoBusinessParallelDetail.BudgetItemCodeParallel = autoBussinessParallel.BudgetItemCode;
autoBusinessParallelDetail.BudgetSubItemCodeParallel = autoBussinessParallel.BudgetSubItemCode;
autoBusinessParallelDetail.MethodDistributeIdParallel = autoBussinessParallel.MethodDistributeID;
autoBusinessParallelDetail.CashWithDrawTypeIdParallel = autoBussinessParallel.CashWithDrawTypeID;
autoBusinessParallelDetail.SortOrder = autoBussinessParallel.SortOrder;
listAutoBusinessPararell.Add(autoBusinessParallelDetail);
}
}
}
}
return(listAutoBusinessPararell);
}
public List <BUCommitmentRequestEntity> GetBUCommitmentRequests(string connectionString)
{
List <BUCommitmentRequestEntity> buentity = new List <BUCommitmentRequestEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUCommitmentRequestDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
banks = context.BankInfoes.ToList();
var resultcontext = context.BUCommitmentRequests.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUCommitmentRequestEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.AccountingObjectName = result.AccountingObjectName;
newresult.TABMISCode = result.TABMISCode;
newresult.BankAccount = result.BankAccount;
newresult.BankName = result.BankName;
newresult.ContractNo = result.ContractNo;
newresult.ContractFrameNo = result.ContractFrameNo;
newresult.BudgetSourceKind = result.BudgetSourceKind;
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.IsForeignCurrency = result.IsForeignCurrency;
newresult.Posted = result.Posted;
newresult.EditVersion = result.EditVersion;
newresult.PostVersion = result.PostVersion;
newresult.ProjectInvestmentCode = result.ProjectInvestmentCode;
newresult.ProjectInvestmentName = result.ProjectInvestmentName;
newresult.SignDate = result.SignDate;
newresult.ContractAmount = result.ContractAmount;
newresult.PrevYearCommitmentAmount = result.PrevYearCommitmentAmount ?? 0;
newresult.BUCommitmentRequestDetails = BUCommitmentRequestDetails(result.BUCommitmentRequestDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
public List <BUBudgetReserveEntity> GetBUBudgetReserves(string connectionString)
{
List <BUBudgetReserveEntity> buentity = new List <BUBudgetReserveEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUBudgetReserveDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var funds = context.Funds.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
var topics = context.Topics.ToList();
banks = context.BankInfoes.ToList();
var department = context.Departments.ToList();
var resultcontext = context.BUBudgetReserves.ToList();
var fixedasset = context.FixedAssets.ToList();
var inventoryitems = context.InventoryItems.ToList();
var stocks = context.Stocks.ToList();
var invoiceformnumber = context.InvoiceFormNumbers.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUBudgetReserveEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.BudgetChapterName = result.BudgetChapterName;
newresult.JournalMemo = result.JournalMemo;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate;
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.Posted = result.Posted;
newresult.EditVersion = result.EditVersion;
newresult.PostVersion = result.PostVersion;
newresult.BudgetReserveDetails = result.BUBudgetReserveDetails.Count <= 0 ? null : BUBudgetReserveDetails(result.BUBudgetReserveDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
public List <AccountEntity> GetAccounts(string connectionString)
{
List <AccountEntity> listAccount = new List <AccountEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.Accounts.ToList();
foreach (var result in categories)
{
var account = new AccountEntity();
account.AccountId = result.AccountID.ToString();
account.AccountNumber = result.AccountNumber;
account.AccountCategoryId = result.AccountCategoryID;
account.ParentId = result.ParentID.ToString();
account.AccountName = result.AccountName;
account.AccountForeignName = null;
account.Description = result.Description;
account.AccountCategoryKind = result.AccountCategoryKind ?? 0;
account.DetailByBudgetSource = result.DetailByBudgetSource;
account.DetailByBudgetChapter = result.DetailByBudgetChapter;
account.DetailByBudgetKindItem = result.DetailByBudgetKindItem;
account.DetailByBudgetItem = result.DetailByBudgetItem;
account.DetailByBudgetSubItem = result.DetailByBudgetSubItem;
account.DetailByMethodDistribute = result.DetailByMethodDistribute;
account.DetailByAccountingObject = result.DetailByAccountingObject;
account.DetailByActivity = result.DetailByActivity;
account.DetailByProject = result.DetailByProject;
account.DetailByTask = result.DetailByTask;
account.DetailBySupply = result.DetailBySupply;
account.DetailByInventoryItem = result.DetailByInventoryItem;
account.DetailByFixedAsset = result.DetailByFixedAsset;
account.DetailByFund = result.DetailByFund;
account.DetailByBankAccount = result.DetailByBankAccount;
account.DetailByProjectActivity = result.DetailByProjectActivity;
account.DetailByInvestor = result.DetailByInvestor;
account.Grade = result.Grade;
account.IsParent = result.IsParent;
account.IsActive = result.Inactive == true ? false : true;
account.IsDisplayOnAccountBalanceSheet = true;
account.IsDisplayBalanceOnReport = true;
account.DetailByCurrency = true;
account.DetailByBudgetExpense = true;
listAccount.Add(account);
}
}
return(listAccount);
}
public List <BUPlanWithdrawEntity> GetBUPlanWithdraws(string connectionString)
{
List <BUPlanWithdrawEntity> buplanwithdraws = new List <BUPlanWithdrawEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUPlanWithdrawDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
banks = context.BankInfoes.ToList();
var resultcontext = context.BUPlanWithdraws.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUPlanWithdrawEntity();
newresult.RefId = result.RefID.ToString();
newresult.CashWithDrawType = result.CashWithDrawType;
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.TargetProgramId = result.Project == null? null: result.Project.ProjectID.ToString();
newresult.BankId = result.BankInfo.BankInfoID.ToString();
newresult.AccountingObjectId = result.AccountingObject == null? null: result.AccountingObject.AccountingObjectID.ToString();
newresult.JournalMemo = result.JournalMemo;
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.GeneratedRefId = result.GeneratedRefID.ToString();
newresult.Posted = result.Posted;
newresult.BUCommitmentRequestId = result.BUCommitmentRequestID.ToString();
newresult.AccountingObjectBankId = result.AccountingObjectBankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.AccountingObjectBankAccount).BankInfoID.ToString();
//newresult.CAReceiptRefId = result.id;
//newresult.LinkRefNo = result.l;
//newresult.BeneficiaryAccount = result.BeneficiaryAccount;
//newresult.BeneficiaryBank = result.BeneficiaryBank;
//newresult.BudgetExpenseID = result.BudgetExpenseID;
newresult.BUPlanWithdrawDetails = BuPlanWithDrawDetails(result.BUPlanWithdrawDetails.ToList(), newresult.RefId);
buplanwithdraws.Add(newresult);
}
}
return(buplanwithdraws);
}
//private List<BankInfo> banks;
public List <GLVoucherListEntity> GetGLVoucherLists(string connectionString)
{
List <GLVoucherListEntity> buentity = new List <GLVoucherListEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.GLVoucherListDetails.ToList();
//var projects = context.Projects.ToList();
//var currencys = context.CCies.ToList();
//var budgetsource = context.BudgetSources.ToList();
//var listitems = context.ListItems.ToList();
//var funds = context.Funds.ToList();
//var fundstructures = context.FundStructures.ToList();
//var budgetproviders = context.BudgetProvidences.ToList();
//var accountingobject = context.AccountingObjects.ToList();
//var projectexpenses = context.ProjectExpenses.ToList();
//var activity = context.Activities.ToList();
//var tasks = context.Tasks.ToList();
//var topics = context.Topics.ToList();
//banks = context.BankInfoes.ToList();
//var department = context.Departments.ToList();
var resultcontext = context.GLVoucherLists.ToList();
//var fixedasset = context.FixedAssets.ToList();
//var inventoryitems = context.InventoryItems.ToList();
//var stocks = context.Stocks.ToList();
//Detail
var vouchertype = context.VoucherTypes.ToList();
foreach (var result in resultcontext)
{
var newresult = new GLVoucherListEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.RefNo = result.RefNo;
newresult.VoucherTypeId = result.VoucherType == null ? null : result.VoucherType.VoucherTypeID.ToString();
newresult.SetupType = result.SetupType ?? 0;
newresult.FromDate = result.FromDate ?? result.RefDate;
newresult.ToDate = result.ToDate ?? result.RefDate;
newresult.Description = result.Description;
newresult.TotalAmount = result.TotalAmount;
newresult.EditVersion = result.EditVersion ?? 0;
newresult.GlVoucherListDetails = result.GLVoucherListDetails.Count <= 0 ? null : GLVoucherListDetails(result.GLVoucherListDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
public List <BUVoucherListEntity> GetBUVoucherLists(string connectionString)
{
List <BUVoucherListEntity> buentity = new List <BUVoucherListEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUVoucherListDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var funds = context.Funds.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
var topics = context.Topics.ToList();
banks = context.BankInfoes.ToList();
var parallel = context.BUVoucherListDetailParallels.ToList();
var detailtransfers = context.BUVoucherListDetailTransfers.ToList();
var resultcontext = context.BUVoucherLists.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUVoucherListEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.FromDate = result.FromDate;
newresult.ToDate = result.ToDate;
newresult.JournalMemo = result.JournalMemo;
newresult.Posted = result.Posted;
newresult.TotalAmount = result.TotalAmount;
newresult.PostVersion = result.PostVersion;
newresult.EditVersion = result.EditVersion;
newresult.BUVoucherListDetailEntities = result.BUVoucherListDetails.Count <= 0 ? null : BUVoucherListDetails(result.BUVoucherListDetails.ToList(), result.RefID.ToString());
newresult.BUVoucherListDetailParallelEntities = result.BUVoucherListDetailParallels.Count <= 0 ? null : BuVoucherListDetailParallels(result.BUVoucherListDetailParallels.ToList(), result.RefID.ToString());
newresult.BUVoucherListDetailTransferEntities = result.BUVoucherListDetailTransfers.Count <= 0 ? null : BUVoucherListDetailTransfers(result.BUVoucherListDetailTransfers.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
public List <ProjectEntity> GetProject(string connectionString)
{
List <ProjectEntity> listProject = new List <ProjectEntity>();
using (var context = new MISAEntity(connectionString))
{
var deparrtment = context.Departments.ToList();
var categories = context.Projects.ToList().OrderBy(x => x.Grade);
foreach (var result in categories)
{
var project = new ProjectEntity();
project.ProjectId = result.ProjectID.ToString();
project.ProjectCode = result.ProjectCode;
project.ProjectNumber = result.ProjectNumber;
project.ProjectName = result.ProjectName;
project.ProjectEnglishName = result.ProjectEnglishName;
project.BUCACodeID = result.MISACodeID;
project.StartDate = result.StartDate;
project.FinishDate = result.FinishDate;
project.ExecutionUnit = result.ExecutionUnit;
project.DepartmentID = result.Department == null? null: result.Department.DepartmentID.ToString();
project.TotalAmountApproved = result.TotalAmountApproved;
project.ParentID = result.ParentID.ToString();
project.Grade = result.Grade;
project.IsParent = result.IsParent;
project.IsDetailbyActivityAndExpense = result.IsDetailbyActivityAndExpense;
project.IsSystem = result.IsSystem;
project.IsActive = result.Inactive != true;
project.ObjectType = result.ObjectType;
project.ContractorID = result.ContractorID.ToString();
project.ContractorName = result.ContractorName;
project.ContractorAddress = result.ContractorAddress;
project.Description = result.Description;
project.ProjectSize = result.ProjectSize;
project.BuildLocation = result.BuildLocation;
project.InvestmentClass = result.InvestmentClass;
project.CDCActivityType = result.CDCActivityType;
project.Investment = "";
listProject.Add(project);
}
}
return(listProject);
}
//private List<BankInfo> banks;
public List <SUTransferEntity> GetSUTransfers(string connectionString)
{
List <SUTransferEntity> buentity = new List <SUTransferEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.SUTransferDetails.ToList();
//var projects = context.Projects.ToList();
//var currencys = context.CCies.ToList();
//var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
//var funds = context.Funds.ToList();
//var fundstructures = context.FundStructures.ToList();
//var budgetproviders = context.BudgetProvidences.ToList();
//var accountingobject = context.AccountingObjects.ToList();
//var projectexpenses = context.ProjectExpenses.ToList();
//var activity = context.Activities.ToList();
//var tasks = context.Tasks.ToList();
//var stocks = context.Stocks.ToList();
//var topics = context.Topics.ToList();
//var fixedassets = context.FixedAssets.ToList();
var departments = context.Departments.ToList();
//var purchasepurposes = context.PurchasePurposes.ToList();
var inventoryitems = context.InventoryItems.ToList();
//banks = context.BankInfoes.ToList();
var resultcontext = context.SUTransfers.ToList();
foreach (var result in resultcontext)
{
var newresult = new SUTransferEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.JournalMemo = result.JournalMemo;
newresult.TotalAmount = result.TotalAmount;
newresult.Posted = result.Posted;
newresult.PostVersion = result.PostVersion;
newresult.EditVersion = result.EditVersion;
newresult.SUTransferDetails = result.SUTransferDetails.Count <= 0 ? null : SUTransferDetails(result.SUTransferDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
public List <BUPlanAdjustmentEntity> GetBUPlanAdjustments(string connectionString)
{
List <BUPlanAdjustmentEntity> buplanadjustments = new List <BUPlanAdjustmentEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUPlanAdjustmentDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
banks = context.BankInfoes.ToList();
var resultcontext = context.BUPlanAdjustments.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUPlanAdjustmentEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.DecisionDate = result.DecisionDate;
newresult.DecisionNo = result.DecisionNo;
newresult.JournalMemo = result.JournalMemo;
newresult.Posted = result.Posted;
newresult.TotalPreAdjustmentAmount = result.TotalPreAdjustmentAmount;
newresult.TotalAdjustmentAmount = result.TotalAdjustmentAmount;
newresult.TotalPostAdjustmentAmount = result.TotalPostAdjustmentAmount;
newresult.PostVersion = result.PostVersion ?? 0;
newresult.EditVersion = result.EditVersion ?? 0;
//newresult.ExchangeRate = result.e;
//newresult.TotalAmount = result.TotalAmount;
//newresult.CurrencyCode = result.cc;
newresult.BUPlanAdjustmentDetails = BUPlanAdjustmentDetails(result.BUPlanAdjustmentDetails.ToList(), newresult.RefId);
buplanadjustments.Add(newresult);
}
}
return(buplanadjustments);
}
public List <InventoryItemEntity> GetInventoryItem(string connectionString)
{
List <InventoryItemEntity> listItems = new List <InventoryItemEntity>();
using (var context = new MISAEntity(connectionString))
{
var accountingObject = context.AccountingObjects.ToList();
var categories = context.InventoryItems.ToList();
foreach (var result in categories)
{
var inventory = new InventoryItemEntity();
inventory.InventoryItemId = result.InventoryItemID.ToString();
inventory.InventoryCategoryId = result.InventoryCategoryID.ToString();
inventory.InventoryItemCode = result.InventoryItemCode;
inventory.InventoryItemName = result.InventoryItemName;
inventory.Description = result.Description;
inventory.Unit = result.Unit;
inventory.ConvertUnit = result.ConvertUnit;
inventory.ConvertRate = result.ConvertRate;
inventory.UnitPrice = result.UnitPrice;
inventory.MadeIn = "";
inventory.SalePrice = result.SalePrice;
inventory.DefaultStockId = result.DefaultStockID.ToString();
inventory.DepartmentId = null;
inventory.InventoryAccount = result.InventoryAccount;
inventory.COGSAccount = result.COGSAccount;
inventory.SaleAccount = result.SaleAccount;
inventory.CostMethod = result.CostMethod;
inventory.AccountingObjectId = result.AccountingObject == null ? null: result.AccountingObject.AccountingObjectID.ToString();
inventory.TaxRate = result.TaxRate;
inventory.IsTool = result.IsTool;
inventory.IsService = result.IsService;
inventory.IsActive = result.Inactive == true?false:true;
inventory.IsTaxable = false;
inventory.IsStock = true;
listItems.Add(inventory);
}
}
return(listItems);
}
public List <BudgetChapterEntity> GetBudgetChapters(string connectionString)
{
List <BudgetChapterEntity> listBudgetChapter = new List <BudgetChapterEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstBudgetChapter = context.BudgetChapters.ToList();
foreach (var result in lstBudgetChapter)
{
var budgetChapter = new BudgetChapterEntity();
budgetChapter.BudgetChapterId = result.BudgetChapterID.ToString();
budgetChapter.BudgetChapterCode = result.BudgetChapterCode;
budgetChapter.BudgetChapterName = result.BudgetChapterName;
budgetChapter.IsActive = result.Active;
listBudgetChapter.Add(budgetChapter);
}
}
return(listBudgetChapter);
}
public List <BUPlanReceiptEntity> GetBuPlanReceipts(string connectionString)
{
List <BUPlanReceiptEntity> buplanreceipts = new List <BUPlanReceiptEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUPlanReceiptDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
banks = context.BankInfoes.ToList();
var categories = context.BUPlanReceipts.ToList();
foreach (var result in categories)
{
var buplan = new BUPlanReceiptEntity();
buplan.RefId = result.RefID.ToString();
buplan.RefType = result.RefType;
buplan.RefDate = result.RefDate;
buplan.PostedDate = result.PostedDate;
buplan.RefNo = result.RefNo;
buplan.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
buplan.ExchangeRate = result.ExchangeRate ?? 0;
buplan.ParalellRefNo = result.ParalellRefNo;
buplan.DecisionDate = result.DecisionDate;
buplan.DecisionNo = result.DecisionNo;
buplan.BudgetChapterCode = result.BudgetChapterCode;
buplan.JournalMemo = result.JournalMemo;
buplan.Posted = result.Posted;
buplan.TotalAmount = result.TotalAmount;
buplan.TotalAmountOC = result.TotalAmountOC;
buplan.AllocationConfig = result.AllocationConfig;
buplan.BuPlanReceiptDetails = BuPlanReceiptDetails(result.BUPlanReceiptDetails.ToList(), result.RefID.ToString());
buplanreceipts.Add(buplan);
}
}
return(buplanreceipts);
}
public List <StockEntity> GetStocks(string connectionString)
{
List <StockEntity> listStock = new List <StockEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.Stocks.ToList();
foreach (var result in categories)
{
var stock = new StockEntity();
stock.StockId = result.StockID.ToString();
stock.StockCode = result.StockCode;
stock.StockName = result.StockName;
stock.Description = result.Description;
stock.DefaultAccountNumber = result.DefaultAccountNumber;
stock.IsActive = result.Inactive == true?false:true;
listStock.Add(stock);
}
}
return(listStock);
}
public List <AutoBusinessEntity> GetAutoBusiness(string connectionString)
{
List <AutoBusinessEntity> listAutoBusiness = new List <AutoBusinessEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstAutoBusinessDetail = context.AutoBusinessDetails.ToList();
var lstAutoBusiness = context.AutoBusinesses.ToList().OrderBy(o => o.AutoBusinessID);
int i = 0;
foreach (var autoBusiness in lstAutoBusiness)
{
foreach (var result in autoBusiness.AutoBusinessDetails)
{
i = i + 1;
var autoBusinessDetail = new AutoBusinessEntity();
autoBusinessDetail.AutoBusinessId = result.AutoBusinessDetailID.ToString();
autoBusinessDetail.AutoBusinessCode = i.ToString();
autoBusinessDetail.AutoBusinessName = autoBusiness.AutoBusinessName;
autoBusinessDetail.RefTypeId = autoBusiness.RefTypeID;
autoBusinessDetail.DebitAccount = result.DebitAccount;
autoBusinessDetail.CreditAccount = result.CreditAccount;
autoBusinessDetail.BudgetSourceId = result.BudgetSourceID.ToString();
autoBusinessDetail.BudgetChapterCode = result.BudgetChapterCode;
autoBusinessDetail.BudgetKindItemCode = result.BudgetKindItemCode;
autoBusinessDetail.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
autoBusinessDetail.BudgetItemCode = result.BudgetItemCode;
autoBusinessDetail.BudgetSubItemCode = result.BudgetSubItemCode;
autoBusinessDetail.MethodDistributeId = result.MethodDistributeID;
autoBusinessDetail.CashWithDrawTypeId = result.CashWithDrawTypeID;
autoBusinessDetail.Description = result.Description;
autoBusinessDetail.IsActive = autoBusiness.Inactive == true ? false : true;
listAutoBusiness.Add(autoBusinessDetail);
}
}
}
return(listAutoBusiness);
}
public List <AccountCategoryEntity> GetAccountsCategory(string connectionString)
{
List <AccountCategoryEntity> listAccount = new List <AccountCategoryEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.AccountCategories.ToList();
foreach (var result in categories)
{
var accountCategory = new AccountCategoryEntity();
accountCategory.AccountCategoryId = result.AccountCategoryID;
accountCategory.AccountCategoryKind = result.AccountCategoryKind ?? 0;
accountCategory.DetailByBudgetSource = result.DetailByBudgetSource;
accountCategory.DetailByBudgetChapter = result.DetailByBudgetChapter;
accountCategory.DetailByBudgetKindItem = result.DetailByBudgetKindItem;
accountCategory.DetailByBudgetItem = result.DetailByBudgetItem;
accountCategory.DetailByBudgetSubItem = result.DetailByBudgetSubItem;
accountCategory.DetailByMethodDistribute = result.DetailByMethodDistribute;
accountCategory.DetailByAccountingObject = result.DetailByAccountingObject;
accountCategory.DetailByActivity = result.DetailByActivity;
accountCategory.DetailByProject = result.DetailByProject;
accountCategory.DetailByTask = result.DetailByTask;
accountCategory.DetailBySupply = result.DetailBySupply;
accountCategory.DetailByInventoryItem = result.DetailByInventoryItem;
accountCategory.DetailByFixedAsset = result.DetailByFixedAsset;
accountCategory.DetailByFund = result.DetailByFund;
accountCategory.DetailByBankAccount = result.DetailByBankAccount;
accountCategory.IsActive = result.Inactive == true ? false:true;
accountCategory.AccountCategoryName = result.AccountCategoryName;
listAccount.Add(accountCategory);
}
}
return(listAccount);
}
//private List<BankInfo> banks;
public List <OpeningSupplyEntryEntity> GetOpeningSupplyEntrys(string connectionString)
{
List <OpeningSupplyEntryEntity> buentity = new List <OpeningSupplyEntryEntity>();
using (var context = new MISAEntity(connectionString))
{
var inventoryitems = context.InventoryItems.ToList();
//banks = context.BankInfoes.ToList();
var resultcontext = context.OpeningSupplyEntries.ToList();
foreach (var result in resultcontext)
{
var newresult = new OpeningSupplyEntryEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.PostedDate = result.PostedDate;
newresult.CurrencyCode = result.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate ?? 0;
newresult.AccountNumber = result.AccountNumber;
newresult.InventoryItemId = result.InventoryItem == null ? null : result.InventoryItem.InventoryItemID.ToString();
newresult.InventoryItemCode = result.InventoryItem == null ? null : result.InventoryItem.InventoryItemCode;
newresult.InventoryItemName = result.InventoryItem == null ? null : result.InventoryItem.InventoryItemName;
newresult.DepartmentId = result.DepartmentID.ToString();
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.Quantity = result.Quantity ?? 0;
newresult.UnitPriceOC = result.UnitPriceOC ?? 0;
newresult.UnitPrice = result.UnitPrice ?? 0;
newresult.AmountOC = result.AmountOC ?? 0;
newresult.Amount = result.Amount ?? 0;
newresult.PostVersion = result.PostVersion ?? 0;
newresult.EditVersion = result.EditVersion ?? 0;
newresult.SortOrder = result.SortOrder ?? 0;
//newresult.OpeningAccountEntryDetail = result.CreateDate;
buentity.Add(newresult);
}
}
return(buentity);
}
public List <InvoiceFormNumberEntity> GetInvoiceFormNumber(string connectionString)
{
List <InvoiceFormNumberEntity> listInvoiceFormNumber = new List <InvoiceFormNumberEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.InvoiceFormNumbers.ToList();
foreach (var result in categories)
{
var invoiceFormNumber = new InvoiceFormNumberEntity();
invoiceFormNumber.InvoiceFormNumberId = result.InvoiceFormNumberID.ToString();
invoiceFormNumber.InvoiceFormNumberCode = result.InvoiceFormNumberCode;
invoiceFormNumber.InvoiceFormNumberName = result.InvoiceFormNumberName;
invoiceFormNumber.InvoiceType = result.InvoiceType;
invoiceFormNumber.IsSystem = result.IsSystem;
invoiceFormNumber.IsActive = result.InActive == true?false:true;
listInvoiceFormNumber.Add(invoiceFormNumber);
}
}
return(listInvoiceFormNumber);
}
public List <FixedAssetCategoryEntity> GetFixedAssetCategory(string connectionString)
{
List <FixedAssetCategoryEntity> listFixedAssetCategory = new List <FixedAssetCategoryEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.FixedAssetCategories.ToList().OrderBy(x => x.Grade);
foreach (var result in categories)
{
var fixedAssetCategory = new FixedAssetCategoryEntity();
fixedAssetCategory.FixedAssetCategoryId = result.FixedAssetCategoryID.ToString();
fixedAssetCategory.FixedAssetCategoryCode = result.FixedAssetCategoryCode;
fixedAssetCategory.FixedAssetCategoryName = result.FixedAssetCategoryName;
fixedAssetCategory.Description = result.Description;
fixedAssetCategory.ParentId = result.ParentID.ToString();
fixedAssetCategory.Grade = result.Grade;
fixedAssetCategory.IsParent = result.IsParent;
fixedAssetCategory.LifeTime = result.LifeTime ?? 0;
fixedAssetCategory.DepreciationRate = result.DepreciationRate ?? 0;
fixedAssetCategory.OrgPriceAccount = result.OrgPriceAccount;
fixedAssetCategory.DepreciationAccount = result.DepreciationAccount;
fixedAssetCategory.CapitalAccount = result.CapitalAccount;
fixedAssetCategory.BudgetChapterCode = result.BudgetChapterCode;
fixedAssetCategory.BudgetKindItemCode = result.BudgetKindItemCode;
fixedAssetCategory.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
fixedAssetCategory.BudgetItemCode = result.BudgetItemCode;
fixedAssetCategory.BudgetSubItemCode = result.BudgetSubItemCode;
fixedAssetCategory.IsActive = true;
listFixedAssetCategory.Add(fixedAssetCategory);
}
}
return(listFixedAssetCategory);
}
public List <PurchasePurposeEntity> GetPurchasePurpose(string connectionString)
{
List <PurchasePurposeEntity> listPurchasePurpose = new List <PurchasePurposeEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.PurchasePurposes.ToList();
foreach (var result in categories)
{
var purchasePurpose = new PurchasePurposeEntity();
purchasePurpose.PurchasePurposeId = result.PurchasePurposeID.ToString();
purchasePurpose.PurchasePurposeCode = result.PurchasePurposeCode;
purchasePurpose.PurchasePurposeName = result.PurchasePurposeName;
purchasePurpose.Description = result.Description;
purchasePurpose.IsSystem = result.IsSystem;
purchasePurpose.IsActive = result.Inactive == true?false:true;
listPurchasePurpose.Add(purchasePurpose);
}
}
return(listPurchasePurpose);
}
