Guest User

Untitled

a guest
Nov 18th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.09 KB | None | 0 0
  1. $("#btnGetTaxByBL").click(function () {
  2. //var strURL = "http://cis-iis2.temple.edu/Fall2018/cis3344_tug81959/WebAPI/api/ServiceDeed/GetByBlockNLot/" + blockNo + "/" + lotNo;
  3. var strURL = "https://localhost:44395/api/ServiceDeed/GetByBlockNLot/" + blockNo + "/" + lotNo;
  4.  
  5. $("#display").html("");
  6. $("#msg").html("");
  7. $("#update").html("");
  8. $("#updateResult").html("");
  9.  
  10. console.log("btnGetTaxByBL clicked");
  11.  
  12. var blockNo = $("#txtBlockNo").val();
  13. var lotNo = $("#txtLotNo").val();
  14.  
  15. $.ajax({
  16. type: "GET",
  17. url: strURL,
  18. contentType: "application/json; charset=utf-8",
  19. dataType: "json",
  20. success: function (data) {
  21. var owner = data;
  22.  
  23. $("#display").html("<hr><p>".concat("HomeOwnerID: ", owner.HomeOwnerID,
  24. "<br>FirstName: ", owner.FirstName, "<br>LastName: ", owner.LastName,
  25. "<br>Address: ", owner.Address, "<br>City: ", owner.City,
  26. "<br>State: ", owner.State, "<br>ZipCode: ", owner.ZipCode,
  27. "<br>Telephone Number: ", owner.TelNo, "<br>Email: ", owner.Email,
  28. "<br>Block Number: ", owner.BlockNo, "<br>Lot Number: ", owner.LotNo,
  29. "<br>Date of Sale: ", owner.SaleDate, "<br>Sale Price: $", owner.SalePrice,
  30. "<br>Sold Status: ", owner.IsSold, "<br>Accessed Value: ", owner.AccessedVal,
  31. "<br>Land Value: ", owner.LandVal, "<br>Additional Value: ", owner.AdditionalVal,
  32. "<br>Tax Rate: ", owner.TaxRate, "<br>Tax Per Year: ", owner.TaxPerYear,
  33. "<br>Real Estate Tax: ", owner.RealEstateTax));
  34.  
  35. },
  36. error: function (req, status, error) {
  37. alert("Error: " + req.responseText + " | " + status + " | " + error);
  38. }
  39. }); //end of ajax method
  40. }); // end of btnGetTaxByBL click event
  41.  
  42. [HttpGet("GetByBlockNLot/{block}/{lot}")]
  43. public List<HomeTax> GetByBlockNLot(int block, int lot)
  44. {
  45. List<HomeTax> homeTaxList = new List<HomeTax>();
  46. DBConnect objDB = new DBConnect();
  47. String strSQL = "SELECT * FROM HomeOwnership_T INNER JOIN TaxInfo_T ON HomeOwnership_T.HomeOwnerID=TaxInfo_T.HomeOwnerID WHERE BlockNo =" + block + " AND LotNo =" + lot;
  48. int count = 0;
  49.  
  50. objDB.GetDataSet(strSQL, out count);
  51.  
  52. for (int i = 0; i < count; i++)
  53. {
  54. HomeTax objOwner = new HomeTax();
  55. objOwner.HomeOwnerID = (int)objDB.GetField("HomeOwnerID", i);
  56. objOwner.FirstName = (string)objDB.GetField("FirstName", i);
  57. objOwner.LastName = (string)objDB.GetField("LastName", i);
  58. objOwner.Address = (string)objDB.GetField("Address", i);
  59. objOwner.City = (string)objDB.GetField("City", i);
  60. objOwner.State = (string)objDB.GetField("State", i);
  61. objOwner.ZipCode = (string)objDB.GetField("ZipCode", i);
  62. objOwner.TelNo = (string)objDB.GetField("TelNo", i);
  63. objOwner.Email = (string)objDB.GetField("Email", i);
  64. objOwner.BlockNo = (int)objDB.GetField("BlockNo", i);
  65. objOwner.LotNo = (int)objDB.GetField("LotNo", i);
  66. objOwner.SaleDate = (DateTime)objDB.GetField("SaleDate", i);
  67. objOwner.SalePrice = (Decimal)objDB.GetField("SalePrice", i);
  68. objOwner.IsSold = (string)objDB.GetField("IsSold", i);
  69. objOwner.AccessedVal = (Decimal)objDB.GetField("AccessedVal", i);
  70. objOwner.LandVal = (Decimal)objDB.GetField("LandVal", i);
  71. objOwner.AdditionalVal = (Decimal)objDB.GetField("AdditionalVal", i);
  72. objOwner.TaxRate = (Decimal)objDB.GetField("TaxRate", i);
  73. objOwner.TaxPerYear = (Decimal)objDB.GetField("TaxPerYear", i);
  74. objOwner.RealEstateTax = (Decimal)objDB.GetField("RealEstateTax", i);
  75.  
  76. homeTaxList.Add(objOwner);
  77. }
  78. return homeTaxList;
  79. }
Add Comment
Please, Sign In to add comment