public void deleteCanceledOfferBySeller(string ContractAddress) { //delete the record from db of the unsigned contracts var report = (from d in _AssetInContractsContext.AssetsInContract where d.ContractAddress == ContractAddress select d).Single(); _AssetInContractsContext.AssetsInContract.Remove(report); _AssetInContractsContext.SaveChanges(); }
private bool InsertAssetInContractToDB(ContractOffer offer, string contractAddress) { //update the AssetInContracts table after the contract deployment (=creation) AssetInContract newOffer = new AssetInContract(); newOffer.AssetID = offer.AssetID; newOffer.ContractAddress = "" + contractAddress; newOffer.SellerPublicKey = offer.SellerPublicKey; newOffer.BuyerPublicKey = offer.BuyerPublicKey; newOffer.Status = "Ongoing"; newOffer.DeniedBy = "None"; newOffer.Reason = "None"; newOffer.DealPrice = offer.PriceETH; _AssetInContractsContext.AssetsInContract.Add(newOffer); _AssetInContractsContext.SaveChanges(); return(true); }
private async Task UpdateContractToApprovedInDB(string ContractAddress) { //update registry - contract in "InGoing state" to "Approve" state DappAccount account = RegulatorController._regulator; SmartContractService deployedContract = new SmartContractService(account, ContractAddress); Asset dealAsset = await deployedContract.getAssetDestails(); int dealAssetID = dealAsset.AssetID; AssetInContract report; try { report = (from d in _AssetInContractsContext.AssetsInContract where d.AssetID == dealAssetID && d.Status.Equals("Approved") select d).Single(); } catch (Exception e) { report = null; } if (report != null) { _AssetInContractsContext.AssetsInContract.Remove(report); _AssetInContractsContext.SaveChanges(); } var report2 = (from d in _AssetInContractsContext.AssetsInContract where d.ContractAddress == ContractAddress select d).Single(); report2.Status = "Approved"; _AssetInContractsContext.AssetsInContract.Update(report2); _AssetInContractsContext.SaveChanges(); }