private async Task <List <ContractOffer> > GetPendingContracts() { //get all the open contracts (pending) that waits for the regulaotr approval DappAccount account = RegulatorController._regulator; await DappAccountController.RefreshAccountData(account.publicKey); List <AssetInContract> deployedContractsFromDB = new List <AssetInContract>(); deployedContractsFromDB = await _AssetInContractsContext.AssetsInContract.FromSqlRaw("select * from AssetsInContract where Status= 'Pending'").ToListAsync(); List <ContractOffer> deployedContractsFromBlockchain = new List <ContractOffer>(); foreach (AssetInContract assCon in deployedContractsFromDB) { ContractOffer offer = new ContractOffer(); string contractAddress = assCon.ContractAddress; offer.ContractAddress = contractAddress; SmartContractService deployedContract = new SmartContractService(account, contractAddress); Asset assetInContract = await deployedContract.getAssetDestails(); //read from blockchain offer.AssetID = assetInContract.AssetID; offer.Loaction = assetInContract.Loaction; offer.Rooms = assetInContract.Rooms; offer.AreaIn = assetInContract.AreaIn; offer.ImageURL = assetInContract.ImageURL; offer.PriceETH = assetInContract.Price; offer.PriceILS = offer.PriceETH * account.exchangeRateETH_ILS; offer.PriceILS = Math.Truncate(offer.PriceILS * 1000) / 1000; offer.BuyerPublicKey = await deployedContract.getBuyerAddress(); offer.SellerPublicKey = await deployedContract.getOldAssetOwner(); offer.SellerSign = await deployedContract.getSellerSign(); offer.BuyerSign = await deployedContract.getBuyerSign(); offer.RegulatorSign = await deployedContract.getRegulatorSign(); offer.Tax = await deployedContract.getTax(); offer.BuyerID = await GetAddressID(offer.BuyerPublicKey); offer.OwnerID = await GetAddressID(offer.SellerPublicKey); offer.NewOwnerPublicKey = await deployedContract.getNewAssetOwner(); offer.NewOwnerID = await GetAddressID(offer.NewOwnerPublicKey); offer.EtherscanURL = "https://ropsten.etherscan.io/address/" + assCon.ContractAddress; deployedContractsFromBlockchain.Add(offer); } return(deployedContractsFromBlockchain); }
public async Task <IActionResult> ShowHomePage() { //read all closed contracts and show it in page DappAccount account = _regulator; List <AssetInContract> deployedContractsFromDB = new List <AssetInContract>(); deployedContractsFromDB = await _AssetInContractsContext.AssetsInContract.FromSqlRaw("select * from AssetsInContract where Status= 'Approved' or (Status= 'Denied' and DeniedBy = 'Regulator') ").ToListAsync(); List <ContractOffer> deployedContractsFromBlockchain = new List <ContractOffer>(); foreach (AssetInContract assCon in deployedContractsFromDB) { ContractOffer offer = new ContractOffer(); string contractAddress = assCon.ContractAddress; offer.ContractAddress = contractAddress; if (!assCon.Status.Equals("Denied")) //For the non-destroyed contracts, "Denied" => Self Destruction { SmartContractService deployedContract = new SmartContractService(account, contractAddress); Asset assetInContract = await deployedContract.getAssetDestails(); //read from blockchain offer.AssetID = assetInContract.AssetID; offer.Loaction = assetInContract.Loaction; offer.Rooms = assetInContract.Rooms; offer.AreaIn = assetInContract.AreaIn; offer.ImageURL = assetInContract.ImageURL; offer.PriceETH = assetInContract.Price; offer.PriceILS = offer.PriceETH * account.exchangeRateETH_ILS; offer.PriceILS = Math.Truncate(offer.PriceILS * 1000) / 1000; offer.BuyerPublicKey = await deployedContract.getBuyerAddress(); offer.SellerPublicKey = await deployedContract.getOldAssetOwner(); offer.SellerSign = await deployedContract.getSellerSign(); offer.BuyerSign = await deployedContract.getBuyerSign(); offer.RegulatorSign = await deployedContract.getRegulatorSign(); offer.Tax = await deployedContract.getTax(); offer.BuyerID = await GetAddressID(offer.BuyerPublicKey); offer.OwnerID = await GetAddressID(offer.SellerPublicKey); offer.NewOwnerPublicKey = await deployedContract.getNewAssetOwner(); offer.NewOwnerID = await GetAddressID(offer.NewOwnerPublicKey); } else { offer.SellerPublicKey = assCon.SellerPublicKey; offer.BuyerPublicKey = assCon.BuyerPublicKey; offer.PriceETH = assCon.DealPrice; offer.PriceILS = offer.PriceETH * account.exchangeRateETH_ILS; offer.BuyerSign = true; offer.RegulatorSign = false; offer.IsDeniedByBuyer = false; offer.IsDeniedByRegulator = true; offer.SellerSign = true; offer.DenyReason = assCon.Reason; offer.AssetID = assCon.AssetID; List <Asset> AssetsInDB = new List <Asset>(); AssetsInDB = await _AssetsContext.Assets.FromSqlRaw("select * from Assets where AssetID = {0}", offer.AssetID).ToListAsync(); offer.Loaction = AssetsInDB[0].Loaction; offer.OwnerID = await GetAddressID(offer.SellerPublicKey); offer.BuyerID = await GetAddressID(offer.BuyerPublicKey); offer.AreaIn = AssetsInDB[0].AreaIn; offer.Rooms = AssetsInDB[0].Rooms; offer.ImageURL = AssetsInDB[0].ImageURL; offer.DenyReason = assCon.Reason; } offer.EtherscanURL = "https://ropsten.etherscan.io/address/" + assCon.ContractAddress; deployedContractsFromBlockchain.Add(offer); } account.DeployedContractList = deployedContractsFromBlockchain; return(View("RegulatorMainPage", _regulator)); }
public async Task <IActionResult> ContractsStatusPage(string PublicKey) //now { //load the page of the open/closed contracts, we read all the related open contracts and sort them await DappAccountController.RefreshAccountData(PublicKey); DappAccount account = DappAccountController.openWith[PublicKey.ToLower()]; List <AssetInContract> deployedContractsFromDB = new List <AssetInContract>(); deployedContractsFromDB = await _AssetInContractsContext.AssetsInContract.FromSqlRaw("select * from AssetsInContract where ( SellerPublicKey = {0} or BuyerPublicKey = {0} )", account.publicKey).ToListAsync(); List <ContractOffer> deployedContractsFromBlockchain = new List <ContractOffer>(); foreach (AssetInContract assCon in deployedContractsFromDB) { ContractOffer offer = new ContractOffer(); string contractAddress = assCon.ContractAddress; offer.ContractAddress = contractAddress; if (!assCon.Status.Equals("Denied")) //For the non-destroyed contracts, "Denied" => Self Destruction { SmartContractService deployedContract = new SmartContractService(account, contractAddress); Asset assetInContract = await deployedContract.getAssetDestails(); //read from blockchain offer.AssetID = assetInContract.AssetID; offer.Loaction = assetInContract.Loaction; offer.Rooms = assetInContract.Rooms; offer.AreaIn = assetInContract.AreaIn; offer.ImageURL = assetInContract.ImageURL; offer.PriceETH = assetInContract.Price; offer.PriceILS = offer.PriceETH * account.exchangeRateETH_ILS; offer.PriceILS = Math.Truncate(offer.PriceILS * 1000) / 1000; offer.BuyerPublicKey = await deployedContract.getBuyerAddress(); offer.SellerPublicKey = await deployedContract.getOldAssetOwner(); offer.SellerSign = await deployedContract.getSellerSign(); offer.BuyerSign = await deployedContract.getBuyerSign(); offer.RegulatorSign = await deployedContract.getRegulatorSign(); offer.Tax = await deployedContract.getTax(); offer.BuyerID = await GetAddressID(offer.BuyerPublicKey); offer.OwnerID = await GetAddressID(offer.SellerPublicKey); if (assCon.Status.Equals("Approved")) { offer.NewOwnerPublicKey = await deployedContract.getNewAssetOwner(); offer.NewOwnerID = await GetAddressID(offer.NewOwnerPublicKey); } if (assCon.Status.Equals("Ongoing")) { ulong time = await deployedContract.getTimeLeftInSeconds(); int timeLeft = (int)time; if (timeLeft > 21) { timeLeft = timeLeft - 20; } offer.TimeToBeOpen = timeLeft; } } else { offer.SellerPublicKey = assCon.SellerPublicKey; offer.BuyerPublicKey = assCon.BuyerPublicKey; offer.PriceETH = assCon.DealPrice; offer.PriceILS = offer.PriceETH * account.exchangeRateETH_ILS; if (assCon.DeniedBy.Equals("Buyer")) { offer.BuyerSign = false; offer.RegulatorSign = false; offer.IsDeniedByBuyer = true; offer.IsDeniedByRegulator = false; } else if (assCon.DeniedBy.Equals("Regulator")) { offer.BuyerSign = true; offer.RegulatorSign = false; offer.IsDeniedByBuyer = false; offer.IsDeniedByRegulator = true; } offer.SellerSign = true; offer.DenyReason = assCon.Reason; offer.AssetID = assCon.AssetID; List <Asset> AssetsInDB = new List <Asset>(); AssetsInDB = await _AssetsContext.Assets.FromSqlRaw("select * from Assets where AssetID = {0}", offer.AssetID).ToListAsync(); offer.Loaction = AssetsInDB[0].Loaction; offer.OwnerID = await GetAddressID(offer.SellerPublicKey); offer.BuyerID = await GetAddressID(offer.BuyerPublicKey); offer.AreaIn = AssetsInDB[0].AreaIn; offer.Rooms = AssetsInDB[0].Rooms; offer.ImageURL = AssetsInDB[0].ImageURL; offer.DenyReason = assCon.Reason; } offer.EtherscanURL = "https://ropsten.etherscan.io/address/" + assCon.ContractAddress; deployedContractsFromBlockchain.Add(offer); } account.DeployedContractList = deployedContractsFromBlockchain; return(View(account)); }