public decimal TaxAssessment(TaxQuery taxQuery) { TaxAssessment taxAssessment = null; TaxType taxType = null; decimal result = 0; try { //execute the document channel event result = _taxController.ExecuteEvent(taxQuery.PostalCode, taxQuery.Amount); //get tax type id taxType = _taxDataAccess.GetTaxTypeByPostalCode(taxQuery.PostalCode); taxAssessment = new TaxAssessment { NettIncome = taxQuery.Amount, IncomeTax = result, TaxTypeId = taxType.TaxTypeId, DateCreated = DateTime.Now, UserCreated = "System" }; //save assessment calculation _taxDataAccess.AddTaxAssessment(taxAssessment); } catch (Exception) { throw; } return(result); }
public int AddTaxAssessment(TaxAssessment taxAssessment) { EF.Entities.TaxAssessment model = _mapper.Map <TaxAssessment, EF.Entities.TaxAssessment>(taxAssessment); ContextEngine.TaxAssessment.Add(model); ContextEngine.SaveChanges(); return(model.TaxAssessmentId); }
public TaxAssessmentTest() { _taxAssessment = MockTaxAssessmentInNorway.GenerateSampleTaxAssessments(); }
public string FTP_ChesterfieldVA(string streetno, string direction, string streetname, string city, string streettype, string unitnumber, string ownernm, string parcelNumber, string searchType, string orderNumber, string directParcel) { GlobalClass.global_orderNo = orderNumber; HttpContext.Current.Session["orderNo"] = orderNumber; GlobalClass.global_parcelNo = parcelNumber; List <string> taxinformation = new List <string>(); string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = ""; string As_of = "", Total_Due = "", MillLevy = "", Class = "", YearBuilt = "", subdivision = ""; List <string> pdflink = new List <string>(); string Parcel_number = "", Tax_Authority = "", type = "", AddressCombain = "", Addresshrf = "", Pin = "", address = "", MailingAddress = "", Constructed = ""; var driverService = PhantomJSDriverService.CreateDefaultService(); driverService.HideCommandPromptWindow = true; //driver = new PhantomJSDriver(); //driver = new ChromeDriver() using (driver = new PhantomJSDriver()) { if (direction != "") { address = streetno.Trim() + " " + direction.Trim() + " " + streetname.Trim() + " " + streettype.Trim(); } else { address = streetno.Trim() + " " + streetname.Trim() + " " + streettype.Trim(); } if (searchType == "titleflex") { gc.TitleFlexSearch(orderNumber, "", ownernm, address, "VA", "Chesterfield"); if ((HttpContext.Current.Session["TitleFlex_Search"] != null && HttpContext.Current.Session["TitleFlex_Search"].ToString() == "Yes")) { return("MultiParcel"); } searchType = "parcel"; parcelNumber = HttpContext.Current.Session["titleparcel"].ToString().Replace(".", ""); } try { StartTime = DateTime.Now.ToString("HH:mm:ss"); driver.Navigate().GoToUrl("https://www.chesterfield.gov/828/Real-Estate-Assessment-Data#/"); if (searchType == "address") { driver.FindElement(By.Id("searchText")).SendKeys(address); Thread.Sleep(4000); gc.CreatePdf_WOP(orderNumber, "Address Search", driver, "VA", "Chesterfield"); driver.FindElement(By.XPath("//*[@id='read-search-toolbar']/div/div/div/button[2]/div/i")).Click(); Thread.Sleep(6000); gc.CreatePdf_WOP(orderNumber, "Address After", driver, "VA", "Chesterfield"); string Recored1 = driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div/div[6]")).Text; string Recored = GlobalClass.Before(Recored1, "records"); if (Recored.Trim().Contains("1")) { driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div/div[3]/a/div/div/div[2]")).Click(); Thread.Sleep(2000); } if (!Recored.Trim().Contains("1")) { int Max = 0; //*[@id="read-content"]/main/div/div/div[2]/div[2]/div/div/div IWebElement Multipletable = driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div")); IList <IWebElement> Multiplerow = Multipletable.FindElements(By.TagName("div")); IList <IWebElement> Multipleid; foreach (IWebElement assessment in Multiplerow) { Multipleid = assessment.FindElements(By.TagName("div")); if (Multipleid.Count == 3 && !assessment.Text.Contains("bedroom(s)") && assessment.Text.Trim() != "" && assessment.Text.Contains("Parcel ID:")) { //string Adres1 = Multipleid[5].Text; string addres = Multipleid[0].Text; string Parcel1 = Multipleid[2].Text; string Parcel = GlobalClass.After(Parcel1, "Parcel ID:"); string Multipleresult = addres + "~" + Parcel; gc.insert_date(orderNumber, Parcel, 2154, Multipleresult, 1, DateTime.Now); Max++; } } if (Max > 1 && Max < 26) { HttpContext.Current.Session["multiparcel_Chesterfield"] = "Yes"; driver.Quit(); return("MultiParcel"); } if (Max > 25) { HttpContext.Current.Session["multiParcel_Chesterfield_Multicount"] = "Maximum"; driver.Quit(); return("Maximum"); } } // gc.CreatePdf_WOP(orderNumber, "Address Search", driver, "VA", "Chesterfield"); try { string Nodata = driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div/div")).Text; if (Nodata.Contains("No results were found")) { HttpContext.Current.Session["Zero_Chesterfield"] = "Zero"; return("No Data Found"); } } catch { } } if (searchType == "parcel") { driver.FindElement(By.Id("searchText")).SendKeys(parcelNumber); Thread.Sleep(4000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search", driver, "VA", "Chesterfield"); driver.FindElement(By.XPath("//*[@id='read-search-toolbar']/div/div/div/button[2]/div/i")).Click(); Thread.Sleep(6000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search After", driver, "VA", "Chesterfield"); driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div/div[3]/a/div/div/div[2]/div/div[4]/ul[1]")).Click(); Thread.Sleep(8000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search click After", driver, "VA", "Chesterfield"); } if (searchType == "Block") { driver.FindElement(By.Id("searchText")).SendKeys(unitnumber); Thread.Sleep(4000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search", driver, "VA", "Chesterfield"); driver.FindElement(By.XPath("//*[@id='read-search-toolbar']/div/div/div/button[2]/div/i")).Click(); Thread.Sleep(6000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search After", driver, "VA", "Chesterfield"); driver.FindElement(By.XPath("//*[@id='read-content']/main/div/div/div[2]/div[2]/div/div/div/div[3]/a/div/div/div[2]/div/div[4]/ul[1]")).Click(); Thread.Sleep(8000); gc.CreatePdf(orderNumber, parcelNumber, "Parcel Search click After", driver, "VA", "Chesterfield"); } Parcel_number = driver.FindElement(By.Id("parcelNumber")).Text; string RealEstateAccount = driver.FindElement(By.Id("accountNumber")).Text; string PropertyClass = driver.FindElement(By.Id("propClass")).Text; string MagisterialDistrict = driver.FindElement(By.Id("magDistrict")).Text; try { subdivision = driver.FindElement(By.Id("subdivision")).Text; } catch { } string DeededAcreage = driver.FindElement(By.Id("acres")).Text; string ownerName = driver.FindElement(By.Id("ownerName")).Text; string MailingAddress1 = driver.FindElement(By.Id("mailingAddress")).Text; string MailingAddress2 = driver.FindElement(By.Id("mailingAddressLine2")).Text; string MailingAddress3 = MailingAddress1 + " " + MailingAddress2; string OwnershipType = driver.FindElement(By.Id("ownershipType")).Text; string legalDescription = driver.FindElement(By.Id("legalDescription")).Text; gc.CreatePdf(orderNumber, parcelNumber, "Overview", driver, "VA", "Chesterfield"); IJavaScriptExecutor js = driver as IJavaScriptExecutor; //*[@id="read-content"]/div[4]/div/div/div[1]/div/div/div IWebElement Assessmentslink = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow = Assessmentslink.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD; foreach (IWebElement charge in IChargesRow) { IChargesTD = charge.FindElements(By.TagName("a")); if (IChargesTD.Count != 0) { try { string strcharges = IChargesTD[0].GetAttribute("innerText"); if (strcharges.Contains("RESIDENTIAL")) { IWebElement IChargesSearch = IChargesTD[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } Thread.Sleep(2000); gc.CreatePdf(orderNumber, parcelNumber, "Residential", driver, "VA", "Chesterfield"); try { YearBuilt = driver.FindElement(By.Id("yearBuilt_0")).Text; } catch { } string Propertydetail = RealEstateAccount + "~" + PropertyClass + "~" + MagisterialDistrict + "~" + subdivision + "~" + DeededAcreage + "~" + ownerName + "~" + MailingAddress3 + "~" + OwnershipType + "~" + legalDescription + "~" + YearBuilt; gc.insert_date(orderNumber, Parcel_number, 2140, Propertydetail, 1, DateTime.Now); // Assessmentslink.Click(); //Thread.Sleep(2000); IWebElement Assessmentslink1 = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow1 = Assessmentslink1.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD1; foreach (IWebElement charge1 in IChargesRow1) { IChargesTD1 = charge1.FindElements(By.TagName("a")); if (IChargesTD1.Count != 0) { try { string strcharges = IChargesTD1[0].GetAttribute("innerText"); if (strcharges.Contains("ASSESSMENTS")) { IWebElement IChargesSearch = IChargesTD1[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } Thread.Sleep(2000); gc.CreatePdf(orderNumber, parcelNumber, "Assessment", driver, "VA", "Chesterfield"); IWebElement Assessmenttable = driver.FindElement(By.XPath("//*[@id='tab_Assessments']/div/div[2]/div/div[1]/div/table/tbody")); IList <IWebElement> Assessmentrow = Assessmenttable.FindElements(By.TagName("tr")); IList <IWebElement> assessmentid; foreach (IWebElement assessment in Assessmentrow) { assessmentid = assessment.FindElements(By.TagName("td")); if (assessmentid.Count != 0 && !assessment.Text.Contains("Assessment Year:") && assessment.Text.Trim() != "") { string Assessmentresult = assessmentid[1].Text + "~" + assessmentid[2].Text + "~" + assessmentid[3].Text + "~" + assessmentid[4].Text + "~" + assessmentid[5].Text + "~" + assessmentid[6].Text; gc.insert_date(orderNumber, Parcel_number, 2141, Assessmentresult, 1, DateTime.Now); } } IWebElement Assessmentslink2 = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow2 = Assessmentslink2.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD2; foreach (IWebElement charge2 in IChargesRow2) { IChargesTD2 = charge2.FindElements(By.TagName("a")); if (IChargesTD2.Count != 0) { try { string strcharges = IChargesTD2[0].GetAttribute("innerText"); if (strcharges.Contains("IMPROVEMENTS")) { IWebElement IChargesSearch = IChargesTD2[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } gc.CreatePdf(orderNumber, parcelNumber, "Improvements", driver, "VA", "Chesterfield"); IWebElement Improvementtable = driver.FindElement(By.XPath("//*[@id='tab_Improvements']/div/div[2]/div/div[1]/div/table/tbody")); IList <IWebElement> Improvementrow = Improvementtable.FindElements(By.TagName("tr")); IList <IWebElement> Improvementid; foreach (IWebElement Improvement in Improvementrow) { Improvementid = Improvement.FindElements(By.TagName("td")); if (Improvementid.Count > 1) { string Improvementresult = Improvementid[0].Text + "~" + Improvementid[1].Text + "~" + Improvementid[2].Text + "~" + Improvementid[3].Text + "~" + Improvementid[4].Text + "~" + Improvementid[5].Text; gc.insert_date(orderNumber, Parcel_number, 2142, Improvementresult, 1, DateTime.Now); } } IWebElement Assessmentslink3 = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow3 = Assessmentslink3.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD3; foreach (IWebElement charge3 in IChargesRow3) { IChargesTD3 = charge3.FindElements(By.TagName("a")); if (IChargesTD3.Count != 0) { try { string strcharges = IChargesTD3[0].GetAttribute("innerText"); if (strcharges.Contains("LAND")) { IWebElement IChargesSearch = IChargesTD3[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } gc.CreatePdf(orderNumber, parcelNumber, "Land", driver, "VA", "Chesterfield"); string Deeded_Acreage = ""; IList <IWebElement> Acreslist = driver.FindElements(By.Id("acres")); foreach (IWebElement Acres in Acreslist) { string Deered = Acres.Text; if (Deered != "") { Deeded_Acreage = Deered; } } string floodPlain = driver.FindElement(By.Id("floodPlain")).Text; string Easement = driver.FindElement(By.Id("easement")).Text; string CountyWater = driver.FindElement(By.Id("countyWater")).Text; string CountySewer = driver.FindElement(By.Id("countySewer")).Text; string Well = driver.FindElement(By.Id("well")).Text; string Septic = driver.FindElement(By.Id("septic")).Text; string Gas = driver.FindElement(By.Id("gas")).Text; string electricity = driver.FindElement(By.Id("electricity")).Text; string PavedStreets = driver.FindElement(By.Id("pavedStreets")).Text; string StormDrains = driver.FindElement(By.Id("stormDrains")).Text; string curbing = driver.FindElement(By.Id("curbing")).Text; string Zoning = driver.FindElement(By.XPath("//*[@id='read-zoning']/div[2]/div/ul/li/div")).Text; string LandLinkresult = Deeded_Acreage + "~" + floodPlain + "~" + Easement + "~" + CountyWater + "~" + Well + "~" + Septic + "~" + Gas + "~" + electricity + "~" + PavedStreets + "~" + StormDrains + "~" + curbing + "~" + Zoning; gc.insert_date(orderNumber, Parcel_number, 2143, LandLinkresult, 1, DateTime.Now); IWebElement Assessmentslink4 = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow4 = Assessmentslink4.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD4; foreach (IWebElement charge4 in IChargesRow4) { IChargesTD4 = charge4.FindElements(By.TagName("a")); if (IChargesTD4.Count != 0) { try { string strcharges = IChargesTD4[0].GetAttribute("innerText"); if (strcharges.Contains("OWNERSHIP")) { IWebElement IChargesSearch = IChargesTD4[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } gc.CreatePdf(orderNumber, parcelNumber, "Ownership", driver, "VA", "Chesterfield"); IWebElement Ownershiptable = driver.FindElement(By.XPath("//*[@id='tab_Ownership']/div/div[2]/div/div[1]/div/table/tbody")); IList <IWebElement> Ownershiprow = Ownershiptable.FindElements(By.TagName("tr")); IList <IWebElement> Ownershipid; foreach (IWebElement Ownership in Ownershiprow) { Ownershipid = Ownership.FindElements(By.TagName("td")); if (Ownershipid.Count > 1) { string Ownershipresult = Ownershipid[1].Text + "~" + Ownershipid[2].Text + "~" + Ownershipid[3].Text + "~" + Ownershipid[4].Text + "~" + Ownershipid[5].Text + "~" + Ownershipid[6].Text + "~" + Ownershipid[7].Text + "~" + Ownershipid[8].Text + "~" + Ownershipid[9].Text + "~" + Ownershipid[10].Text; gc.insert_date(orderNumber, Parcel_number, 2153, Ownershipresult, 1, DateTime.Now); } } //Tax Site TaxTime = DateTime.Now.ToString("HH:mm:ss"); IWebElement Assessmentslink5 = driver.FindElement(By.XPath("//*[@id='read-content']/div[4]/div/div/div[1]/div/div/div")); IList <IWebElement> IChargesRow5 = Assessmentslink5.FindElements(By.TagName("div")); IList <IWebElement> IChargesTD5; foreach (IWebElement charge5 in IChargesRow5) { IChargesTD5 = charge5.FindElements(By.TagName("a")); if (IChargesTD5.Count != 0) { try { string strcharges = IChargesTD5[0].GetAttribute("innerText"); if (strcharges.Contains("TAX")) { IWebElement IChargesSearch = IChargesTD5[0]; js.ExecuteScript("arguments[0].click();", IChargesSearch); Thread.Sleep(3000); break; } } catch { } } } gc.CreatePdf(orderNumber, parcelNumber, "TaxHistory", driver, "VA", "Chesterfield"); string taxAccount = driver.FindElement(By.Id("taxAccount")).Text; string Currentbalance1 = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[2]/div/div/div/ul/li/div[1]")).Text; string currentbalncedate = GlobalClass.After(Currentbalance1, "as of"); string currentbalanceamt = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[2]/div/div/div/ul/li/div[2]")).Text; IWebElement TaxAssessmenttable = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[3]/div[2]/div/div/table/tbody")); IList <IWebElement> TaxAssessmentrow = TaxAssessmenttable.FindElements(By.TagName("tr")); IList <IWebElement> TaxAssessmentid; foreach (IWebElement TaxAssessment in TaxAssessmentrow) { TaxAssessmentid = TaxAssessment.FindElements(By.TagName("td")); if (TaxAssessmentid.Count != 0) { string TaxAssessmentresult = taxAccount + "~" + currentbalncedate + "~" + currentbalanceamt + "~" + TaxAssessmentid[0].Text + "~" + TaxAssessmentid[1].Text + "~" + TaxAssessmentid[2].Text + "~" + TaxAssessmentid[3].Text; gc.insert_date(orderNumber, Parcel_number, 2144, TaxAssessmentresult, 1, DateTime.Now); } } driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[6]/div/div[1]/div[1]")).Click(); Thread.Sleep(6000); IList <IWebElement> Licount = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[6]/div/div[2]/div/ul")).FindElements(By.TagName("li")); try { for (int I = 1; I <= 6; I++) { //*[@id="tab_Tax"]/div/div[2]/div/ul/li[6]/div/div[2]/div/ul/li[1] IWebElement Halfclick = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[6]/div/div[2]/div/ul/li[" + I + "]")); Halfclick.SendKeys(Keys.Enter); //js.ExecuteScript("arguments[0].click();", Halfclick); Thread.Sleep(4000); string Taxyear1 = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[6]/div/div[2]/div/ul/li[" + I + "]/div[1]")).Text; string taxyear = GlobalClass.Before(Taxyear1, ":"); gc.CreatePdf(orderNumber, parcelNumber, "TaxHistory" + I, driver, "VA", "Chesterfield"); IWebElement TaxaccountHistorytable = driver.FindElement(By.XPath("//*[@id='tab_Tax']/div/div[2]/div/ul/li[6]/div/div[2]/div/ul/li[" + I + "]/div[2]/div/div/div/table/tbody")); IList <IWebElement> TaxaccountHistoryrow = TaxaccountHistorytable.FindElements(By.TagName("tr")); IList <IWebElement> TaxaccountHistoryid; foreach (IWebElement TaxaccountHistory in TaxaccountHistoryrow) { TaxaccountHistoryid = TaxaccountHistory.FindElements(By.TagName("td")); if (TaxaccountHistoryid.Count != 0) { string TaxaccountHistoryresult = taxyear + "~" + TaxaccountHistoryid[0].Text + "~" + TaxaccountHistoryid[1].Text + "~" + TaxaccountHistoryid[2].Text + "~" + TaxaccountHistoryid[3].Text + "~" + TaxaccountHistoryid[4].Text + "~" + TaxaccountHistoryid[5].Text + "~" + TaxaccountHistoryid[6].Text; gc.insert_date(orderNumber, Parcel_number, 2145, TaxaccountHistoryresult, 1, DateTime.Now); } } } } catch { } LastEndTime = DateTime.Now.ToString("HH:mm:ss"); gc.insert_TakenTime(orderNumber, "VA", "Chesterfield", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime); driver.Quit(); //HttpContext.Current.Session["titleparcel"] = null; gc.mergpdf(orderNumber, "VA", "Chesterfield"); return("Data Inserted Successfully"); } catch (Exception ex) { driver.Quit(); GlobalClass.LogError(ex, orderNumber); throw ex; } } }