Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $("#btnGetTaxByBL").click(function () {
- //var strURL = "http://cis-iis2.temple.edu/Fall2018/cis3344_tug81959/WebAPI/api/ServiceDeed/GetByBlockNLot/" + blockNo + "/" + lotNo;
- var strURL = "https://localhost:44395/api/ServiceDeed/GetByBlockNLot/" + blockNo + "/" + lotNo;
- $("#display").html("");
- $("#msg").html("");
- $("#update").html("");
- $("#updateResult").html("");
- console.log("btnGetTaxByBL clicked");
- var blockNo = $("#txtBlockNo").val();
- var lotNo = $("#txtLotNo").val();
- $.ajax({
- type: "GET",
- url: strURL,
- contentType: "application/json; charset=utf-8",
- dataType: "json",
- success: function (data) {
- var owner = data;
- $("#display").html("<hr><p>".concat("HomeOwnerID: ", owner.HomeOwnerID,
- "<br>FirstName: ", owner.FirstName, "<br>LastName: ", owner.LastName,
- "<br>Address: ", owner.Address, "<br>City: ", owner.City,
- "<br>State: ", owner.State, "<br>ZipCode: ", owner.ZipCode,
- "<br>Telephone Number: ", owner.TelNo, "<br>Email: ", owner.Email,
- "<br>Block Number: ", owner.BlockNo, "<br>Lot Number: ", owner.LotNo,
- "<br>Date of Sale: ", owner.SaleDate, "<br>Sale Price: $", owner.SalePrice,
- "<br>Sold Status: ", owner.IsSold, "<br>Accessed Value: ", owner.AccessedVal,
- "<br>Land Value: ", owner.LandVal, "<br>Additional Value: ", owner.AdditionalVal,
- "<br>Tax Rate: ", owner.TaxRate, "<br>Tax Per Year: ", owner.TaxPerYear,
- "<br>Real Estate Tax: ", owner.RealEstateTax));
- },
- error: function (req, status, error) {
- alert("Error: " + req.responseText + " | " + status + " | " + error);
- }
- }); //end of ajax method
- }); // end of btnGetTaxByBL click event
- [HttpGet("GetByBlockNLot/{block}/{lot}")]
- public List<HomeTax> GetByBlockNLot(int block, int lot)
- {
- List<HomeTax> homeTaxList = new List<HomeTax>();
- DBConnect objDB = new DBConnect();
- String strSQL = "SELECT * FROM HomeOwnership_T INNER JOIN TaxInfo_T ON HomeOwnership_T.HomeOwnerID=TaxInfo_T.HomeOwnerID WHERE BlockNo =" + block + " AND LotNo =" + lot;
- int count = 0;
- objDB.GetDataSet(strSQL, out count);
- for (int i = 0; i < count; i++)
- {
- HomeTax objOwner = new HomeTax();
- objOwner.HomeOwnerID = (int)objDB.GetField("HomeOwnerID", i);
- objOwner.FirstName = (string)objDB.GetField("FirstName", i);
- objOwner.LastName = (string)objDB.GetField("LastName", i);
- objOwner.Address = (string)objDB.GetField("Address", i);
- objOwner.City = (string)objDB.GetField("City", i);
- objOwner.State = (string)objDB.GetField("State", i);
- objOwner.ZipCode = (string)objDB.GetField("ZipCode", i);
- objOwner.TelNo = (string)objDB.GetField("TelNo", i);
- objOwner.Email = (string)objDB.GetField("Email", i);
- objOwner.BlockNo = (int)objDB.GetField("BlockNo", i);
- objOwner.LotNo = (int)objDB.GetField("LotNo", i);
- objOwner.SaleDate = (DateTime)objDB.GetField("SaleDate", i);
- objOwner.SalePrice = (Decimal)objDB.GetField("SalePrice", i);
- objOwner.IsSold = (string)objDB.GetField("IsSold", i);
- objOwner.AccessedVal = (Decimal)objDB.GetField("AccessedVal", i);
- objOwner.LandVal = (Decimal)objDB.GetField("LandVal", i);
- objOwner.AdditionalVal = (Decimal)objDB.GetField("AdditionalVal", i);
- objOwner.TaxRate = (Decimal)objDB.GetField("TaxRate", i);
- objOwner.TaxPerYear = (Decimal)objDB.GetField("TaxPerYear", i);
- objOwner.RealEstateTax = (Decimal)objDB.GetField("RealEstateTax", i);
- homeTaxList.Add(objOwner);
- }
- return homeTaxList;
- }
Add Comment
Please, Sign In to add comment