Beispiel #1
0
        public void InsertTransaction(TransationModel transactionModel)
        {
            Transation transation = new Transation
            {
                TableNum    = Convert.ToInt32(transactionModel.TableNum),
                TransNum    = transactionModel.TransNum,
                TotalAmount = transactionModel.ArticleModels.Sum(f => f.TotalPrice),
                TransDate   = DateTime.Now
            };
            List <TransArticle> transArticles = new List <TransArticle>();

            using (var orderDbContext = Provider.CreateDbContext())
            {
                int transactionId;
                if (!orderDbContext.Transations.Any())
                {
                    transactionId = 1;
                }
                else
                {
                    transactionId = orderDbContext.Transations.Max(t => t.Id) + 1;
                }
                foreach (ArticleModel f in transactionModel.ArticleModels)
                {
                    Article      article      = orderDbContext.Articles.First(a => a.Code == f.Code);
                    TransArticle transArticle = new TransArticle
                    {
                        TransactionId = transactionId,
                        ArticleId     = article.Id,
                        Qty           = f.Number,
                        TotalPrice    = f.TotalPrice
                    };
                    transArticles.Add(transArticle);
                }
                try
                {
                    orderDbContext.Transations.Add(transation);
                    orderDbContext.SaveChanges();
                    orderDbContext.TransArticles.AddRange(transArticles);
                    orderDbContext.SaveChanges();
                }
                catch (Exception ex)
                {
                    Log.Error(ex.ToString());
                }
            }
        }
Beispiel #2
0
        public string AdamsCO(string Streetno, string sname, string direction, string streettype, string unitnumber, string parcelNumber, string ownername, 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 = "", Built = "";
            string        Parcel_number = "", Tax_Authority = "", yearbuild = "", AddressCombain = "", Addresshrf = "", TaxesDue = "", Multiaddressadd = "", MailingAddress = "";
            var           driverService = PhantomJSDriverService.CreateDefaultService();

            driverService.HideCommandPromptWindow = true;
            //driver = new PhantomJSDriver();
            //driver = new ChromeDriver()
            using (driver = new PhantomJSDriver())
            {
                try
                {
                    if (searchType == "titleflex")
                    {
                        string Address = "";
                        if (direction != "")
                        {
                            Address = Streetno.Trim() + " " + direction.ToUpper().Trim() + " " + sname.ToUpper().Trim() + " " + streettype.ToUpper().Trim();
                        }
                        if (Streetno != "")
                        {
                            Address = Streetno + " " + sname + " " + streettype + " " + unitnumber;
                        }
                        gc.TitleFlexSearch(orderNumber, "", ownername, Address, "CO", "Adams");
                        if ((HttpContext.Current.Session["TitleFlex_Search"] != null))
                        {
                            driver.Quit();
                            return("MultiParcel");
                        }
                        else if (HttpContext.Current.Session["titleparcel"].ToString() == "")
                        {
                            HttpContext.Current.Session["Adams_Zero"] = "Zero";
                            driver.Quit();
                            return("No Data Found");
                        }
                        searchType   = "parcel";
                        parcelNumber = HttpContext.Current.Session["titleparcel"].ToString().Replace(".", "");
                    }
                    driver.Navigate().GoToUrl("http://gisapp.adcogov.org/quicksearch/");
                    if (searchType == "address")
                    {
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchOptions_2")).Click();
                        Thread.Sleep(1000);
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchInput")).SendKeys(Streetno);
                        gc.CreatePdf_WOP(orderNumber, "Address search", driver, "CO", "Adams");
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchSubmitLink")).Click();
                        Thread.Sleep(2000);
                        if (direction.Trim() != "")
                        {
                            AddressCombain = Streetno + " " + direction + " " + sname + " " + streettype;
                        }
                        else
                        {
                            AddressCombain = Streetno + " " + sname + " " + streettype.Trim();
                        }
                        int                 Max          = 0;
                        IWebElement         Addresstable = driver.FindElement(By.XPath("//*[@id='ctl00_ContentPlaceHolder_QuickSearchResultsDisplay']/tbody"));
                        IList <IWebElement> Addresrow    = Addresstable.FindElements(By.TagName("tr"));
                        IList <IWebElement> AddressTD;
                        gc.CreatePdf_WOP(orderNumber, "Address After", driver, "CO", "Adams");
                        foreach (IWebElement AddressT in Addresrow)
                        {
                            AddressTD = AddressT.FindElements(By.TagName("td"));
                            if (AddressTD.Count != 0 && AddressTD[2].Text.Contains(AddressCombain.ToUpper()))
                            {
                                IWebElement Parcellink = AddressTD[0].FindElement(By.TagName("a"));
                                Addresshrf = Parcellink.GetAttribute("href");
                                string parcelno    = AddressTD[0].Text;
                                string OwnerName   = AddressTD[1].Text;
                                string Address     = AddressTD[2].Text;
                                string Multiresult = OwnerName + "~" + Address;
                                gc.insert_date(orderNumber, parcelno, 1851, Multiresult, 1, DateTime.Now);
                                Max++;
                            }
                        }
                        if (Max == 1)
                        {
                            driver.Navigate().GoToUrl(Addresshrf);
                            Thread.Sleep(2000);
                        }
                        if (Max > 1 && Max < 26)
                        {
                            HttpContext.Current.Session["multiParcel_Adams"] = "Yes";
                            driver.Quit();
                            return("MultiParcel");
                        }
                        if (Max > 25)
                        {
                            HttpContext.Current.Session["multiParcel_Adams_Multicount"] = "Maximum";
                            driver.Quit();
                            return("Maximum");
                        }
                        if (Max == 0)
                        {
                            HttpContext.Current.Session["Adams_Zero"] = "Zero";
                            driver.Quit();
                            return("No Data Found");
                        }
                    }
                    if (searchType == "parcel")
                    {
                        string Parcel = parcelNumber.Substring(0, 1);
                        if (Convert.ToInt16(Parcel) == 0)
                        {
                            driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchInput")).SendKeys(parcelNumber.Replace("-", "").Trim());
                        }
                        if (Convert.ToInt16(Parcel) != 0)
                        {
                            driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchInput")).SendKeys("0" + parcelNumber.Replace("-", "").Trim());
                        }
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchSubmitLink")).Click();
                        Thread.Sleep(2000);
                        try
                        {
                            string Nodata = driver.FindElement(By.XPath("//*[@id='ctl00_ContentPlaceHolder_QuickSearchResultsDisplay']/tbody/tr/td")).Text;
                            if (Nodata.Contains("Sorry, there are no data"))
                            {
                                HttpContext.Current.Session["Adams_Zero"] = "Zero";
                                driver.Quit();
                                return("No Data Found");
                            }
                        }
                        catch { }
                        IWebElement ParcelLink = driver.FindElement(By.XPath("//*[@id='ctl00_ContentPlaceHolder_QuickSearchResultsDisplay']/tbody/tr[2]/td[1]/a"));
                        string      Parcelhref = ParcelLink.GetAttribute("href");
                        driver.Navigate().GoToUrl(Parcelhref);
                        Thread.Sleep(2000);
                    }
                    if (searchType == "Account")
                    {
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchOptions_1")).Click();
                        Thread.Sleep(2000);
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchInput")).SendKeys(unitnumber);
                        gc.CreatePdf_WOP(orderNumber, "Account search", driver, "CO", "Adams");
                        driver.FindElement(By.Id("ctl00_ContentPlaceHolder_SearchSubmitLink")).Click();
                        Thread.Sleep(20000);
                        gc.CreatePdf_WOP(orderNumber, "Account Click", driver, "CO", "Adams");
                        IWebElement Accountlink = driver.FindElement(By.XPath("//*[@id='ctl00_ContentPlaceHolder_QuickSearchResultsDisplay']/tbody/tr[2]/td[1]")).FindElement(By.TagName("a"));
                        string      Accounthref = Accountlink.GetAttribute("href");
                        driver.Navigate().GoToUrl(Accounthref);
                    }
                    //*[@id="propertyReport"]/span[3]/span[1]/div/span[2]
                    Parcel_number = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[3]/span[1]/div/span[2]")).Text;
                    string      owner      = driver.FindElement(By.Id("ownerNameLabel")).Text;
                    string      AddressPro = driver.FindElement(By.Id("propertyContentCell")).Text;
                    IWebElement Expandall  = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[2]/span[1]/a"));
                    Expandall.Click();
                    Thread.Sleep(2000);
                    gc.CreatePdf(orderNumber, Parcel_number, "Expand All", driver, "CO", "Adams");
                    string Account     = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[6]/span[3]/div/table/tbody/tr[2]/td[1]/span")).Text;
                    string Taxdistrist = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[6]/span[3]/div/table/tbody/tr[2]/td[3]/a")).Text;
                    string Legal       = driver.FindElement(By.XPath(" //*[@id='propertyReport']/span[5]/span[3]/div/span")).Text;
                    string Subdevision = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[5]/span[6]/div/span")).Text;
                    string MillLevyAss = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[6]/span[3]/div/table/tbody/tr[2]/td[4]/span")).Text;
                    string Permit      = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[8]/span[3]/div")).Text;
                    Thread.Sleep(2000);
                    try
                    {
                        yearbuild = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[14]/span[2]/div/table/tbody/tr[2]/td[2]/span")).Text;
                    }
                    catch { }
                    string Buildas              = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[14]/span[2]/div/table/tbody/tr[1]/td[2]/span")).Text;
                    string Buildingtype         = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[14]/span[2]/div/table/tbody/tr[3]/td[2]/span")).Text;
                    string Propertydetailresult = owner + "~" + AddressPro + "~" + Account + "~" + Taxdistrist + "~" + Legal + "~" + Subdevision + "~" + MillLevyAss + "~" + Buildas + "~" + Buildingtype + "~" + yearbuild + "~" + Permit;
                    gc.insert_date(orderNumber, Parcel_number, 1613, Propertydetailresult, 1, DateTime.Now);
                    IWebElement         landvaluetable = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[12]/span[3]/div/table/tbody"));
                    IList <IWebElement> landvaluerow   = landvaluetable.FindElements(By.TagName("tr"));
                    IList <IWebElement> landvalueid;
                    foreach (IWebElement landvalue in landvaluerow)
                    {
                        landvalueid = landvalue.FindElements(By.TagName("td"));
                        if (!landvalue.Text.Contains("Land Subtotal") && !landvalue.Text.Contains("Account Number") && landvalueid[0].Text.Trim() != "")
                        {
                            string LandResult1 = landvalueid[0].Text + "~" + landvalueid[1].Text + "~" + landvalueid[2].Text + "~" + landvalueid[3].Text + "~" + landvalueid[4].Text + "~" + landvalueid[5].Text + "~" + landvalueid[6].Text + "~" + landvalueid[7].Text + "~" + landvalueid[8].Text;
                            gc.insert_date(orderNumber, Parcel_number, 1628, LandResult1, 1, DateTime.Now);
                        }
                        if (landvalue.Text.Contains("Land Subtotal"))
                        {
                            string Landresult = landvalueid[0].Text + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + landvalueid[7].Text + "~" + landvalueid[8].Text;
                            gc.insert_date(orderNumber, Parcel_number, 1628, Landresult, 1, DateTime.Now);
                        }
                    }
                    IWebElement         Improvementtable = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[12]/span[5]/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 (Improvement.Text.Contains("Improvements Subtotal:"))
                        {
                            string impromentresult = Improvementid[0].Text + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + Improvementid[1].Text + "~" + Improvementid[2].Text;;
                            gc.insert_date(orderNumber, Parcel_number, 1628, impromentresult, 1, DateTime.Now);
                        }
                    }
                    IWebElement         TotalPropertytable = driver.FindElement(By.XPath("//*[@id='propertyReport']/span[12]/span[7]/table/tbody"));
                    IList <IWebElement> TotalPropertyrow   = TotalPropertytable.FindElements(By.TagName("tr"));
                    IList <IWebElement> TotalPropertytid;
                    foreach (IWebElement TotalProperty in TotalPropertyrow)
                    {
                        TotalPropertytid = TotalProperty.FindElements(By.TagName("td"));
                        if (TotalPropertytid.Count != 0)
                        {
                            string TotalPropertyresult = TotalPropertytid[0].Text + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + "" + "~" + TotalPropertytid[1].Text + "~" + TotalPropertytid[2].Text;
                            gc.insert_date(orderNumber, Parcel_number, 1628, TotalPropertyresult, 1, DateTime.Now);
                        }
                    }
                    //Tax_Authority
                    try
                    {
                        driver.Navigate().GoToUrl("http://www.adcogov.org/faqs/where-do-i-make-payment-0");
                        string Taxauthority = driver.FindElement(By.XPath("//*[@id='node-8873']/div[1]/div/div/p")).Text;
                        Tax_Authority = gc.Between(Taxauthority, "to the", ". To");
                    }
                    catch { }
                    //Tax Site
                    driver.Navigate().GoToUrl("https://www.adcotax.com/treasurer/web/login.jsp");
                    driver.FindElement(By.XPath("//*[@id='middle_left']/font/form/input[1]")).Click();
                    Thread.Sleep(2000);
                    gc.CreatePdf(orderNumber, Parcel_number, "Tax Site Enter", driver, "CO", "Adams");
                    driver.FindElement(By.Id("TaxAParcelID")).SendKeys(Parcel_number);
                    gc.CreatePdf(orderNumber, Parcel_number, "Tax Site Parcel", driver, "CO", "Adams");
                    driver.FindElement(By.XPath("//*[@id='middle']/font/form/table[3]/tbody/tr/td[1]/input")).Click();
                    Thread.Sleep(2000);
                    driver.FindElement(By.XPath("//*[@id='searchResultsTable']/tbody/tr/td[1]/strong/a")).Click();
                    Thread.Sleep(2000);
                    gc.CreatePdf(orderNumber, Parcel_number, "Tax Site After", driver, "CO", "Adams");
                    //Summary
                    string check = "", AreaID = "", Title1 = "", ValueAmount = "", paymenttype = "", ValueTitle = "", Title2 = "", Taxes = "", TActual = "", TAssessed = "";
                    try
                    {
                        //IWebElement currenttaxtable = driver.FindElement(By.LinkText("Account Summary"));
                        IWebElement         IValue    = driver.FindElement(By.XPath("//*[@id='taxAccountValueSummary']/div/table/tbody"));
                        IList <IWebElement> IValueRow = IValue.FindElements(By.TagName("tr"));
                        IList <IWebElement> IValueTD;
                        foreach (IWebElement value in IValueRow)
                        {
                            IValueTD = value.FindElements(By.TagName("td"));
                            if (IValueTD.Count != 0 && value.Text != "")
                            {
                                if (IValueTD[1].Text.Trim() == "" && IValueTD[0].Text.Trim() != "" && IValueTD[2].Text.Trim() != "" && !IValueTD[0].Text.Contains("Area Id"))
                                {
                                    if (check != "" && check == "Area ID")
                                    {
                                        check        = "";
                                        ValueAmount += IValueTD[0].Text + "~" + IValueTD[2].Text + "~";
                                    }
                                    else
                                    {
                                        ValueTitle  += IValueTD[0].Text + "~";
                                        ValueAmount += IValueTD[2].Text + "~";
                                    }
                                }
                                if (IValueTD[1].Text.Trim() == "" && IValueTD[0].Text.Trim() != "" && IValueTD[2].Text.Trim() != "" && IValueTD[0].Text.Contains("Area Id"))
                                {
                                    ValueTitle += IValueTD[0].Text + "~" + IValueTD[2].Text + "~";
                                    check       = "Area ID";
                                }
                                if (IValueTD[0].Text.Trim() == "" && IValueTD[1].Text.Trim() != "" && IValueTD[2].Text.Trim() != "")
                                {
                                    Title1 = IValueTD[1].Text;
                                    Title2 = IValueTD[2].Text;
                                }
                                if (IValueTD[0].Text.Trim() != "" && IValueTD[1].Text.Trim() != "" && IValueTD[2].Text.Trim() != "")
                                {
                                    ValueTitle  += IValueTD[0].Text + "(" + Title1 + ")" + "~" + IValueTD[0].Text + "(" + Title2 + ")" + "~";
                                    ValueAmount += IValueTD[1].Text + "~" + IValueTD[2].Text + "~";
                                }
                            }
                        }

                        db.ExecuteQuery("update data_field_master set Data_Fields_Text='" + ValueTitle.Remove(ValueTitle.Length - 1, 1) + "' where Id = '" + 1634 + "'");
                        gc.insert_date(orderNumber, Parcel_number, 1634, ValueAmount.Remove(ValueAmount.Length - 1, 1), 1, DateTime.Now);
                    }
                    catch
                    { }
                    int z = 0;
                    //*[@id="totals"]/table/tbody
                    //*[@id="totals"]/table/tbody
                    try
                    {
                        for (int i = 1; i < 3; i++)

                        {
                            IWebElement Inquirytable = driver.FindElement(By.Id("totals"));
                            if (Inquirytable.Text.Contains("Misc Due") || Inquirytable.Text.Contains("Interest Due"))
                            {
                                break;
                            }
                            IWebElement As_off = driver.FindElement(By.Id("paymentDate"));
                            As_of = As_off.GetAttribute("value");
                            if (i == 1)
                            {
                                paymenttype = driver.FindElement(By.XPath("//*[@id='inquiryForm']/table/tbody/tr[2]/td[2]/label[1]")).Text;
                                driver.FindElement(By.Id("paymentTypeFirst")).Click();
                                Thread.Sleep(3000);
                                gc.CreatePdf(orderNumber, Parcel_number, "first Due", driver, "CO", "Adams");
                            }
                            else
                            {
                                paymenttype = driver.FindElement(By.XPath("//*[@id='inquiryForm']/table/tbody/tr[2]/td[2]/label[2]")).Text;
                                //if (paymenttype == "First")
                                //{
                                //    driver.FindElement(By.Id("paymentTypeFirst")).Click();
                                //    Thread.Sleep(1000);
                                //    gc.CreatePdf(orderNumber, Parcel_number, "first", driver, "CO", "Adams");
                                //}
                                if (paymenttype == "Second")
                                {
                                    driver.FindElement(By.Id("paymentTypeSecond")).Click();
                                    Thread.Sleep(3000);
                                    gc.CreatePdf(orderNumber, Parcel_number, "second Due", driver, "CO", "Adams");
                                }
                            }

                            Total_Due = GlobalClass.After(Inquirytable.Text, "Total Due").Trim();
                            if (Inquirytable.Text.Contains("Taxes Due"))
                            {
                                TaxesDue = gc.Between(Inquirytable.Text, "Taxes Due", "Total Due").Trim();
                            }
                            string cuttenttaxresult1 = As_of + "~" + paymenttype + "~" + TaxesDue + "~" + Total_Due;
                            gc.insert_date(orderNumber, Parcel_number, 1635, cuttenttaxresult1, 1, DateTime.Now);
                            z++;
                        }
                    }
                    catch { }
                    if (z > 1)
                    {
                        for (int i = 1; i < 3; i++)
                        {
                            string strEffectiveDate = "";
                            string currDate         = DateTime.Now.ToString("MM/dd/yyyy");
                            string dateChecking     = DateTime.Now.ToString("MM") + "/15/" + DateTime.Now.ToString("yyyy");
                            if (i == 1)
                            {
                                if (Convert.ToDateTime(currDate) > Convert.ToDateTime(dateChecking))
                                {
                                    string nextEndOfMonth = "";
                                    if ((Convert.ToInt16(Convert.ToInt16(DateTime.Now.ToString("MM"))) < 12))
                                    {
                                        nextEndOfMonth = new DateTime(Convert.ToInt16(DateTime.Now.ToString("yyyy")), Convert.ToInt16(Convert.ToInt16(DateTime.Now.ToString("MM")) + 1), DateTime.DaysInMonth(Convert.ToInt16(DateTime.Now.ToString("yyyy")), Convert.ToInt16(DateTime.Now.ToString("MM")) + 1)).ToString("MM/dd/yyyy");
                                    }
                                    else
                                    {
                                        int nxtYr = Convert.ToInt16(DateTime.Now.ToString("yyyy")) + 1;
                                        nextEndOfMonth = nextEndOfMonth = new DateTime(nxtYr, 1, DateTime.DaysInMonth(Convert.ToInt16(DateTime.Now.ToString("yyyy")), 1)).ToString("MM/dd/yyyy");
                                    }
                                    strEffectiveDate = nextEndOfMonth;
                                }
                                else
                                {
                                    string EndOfMonth = new DateTime(Convert.ToInt16(DateTime.Now.ToString("yyyy")), Convert.ToInt16(Convert.ToInt16(DateTime.Now.ToString("MM"))), DateTime.DaysInMonth(Convert.ToInt16(DateTime.Now.ToString("yyyy")), Convert.ToInt16(DateTime.Now.ToString("MM")))).ToString("MM/dd/yyyy");
                                    strEffectiveDate = EndOfMonth;
                                }
                            }
                            paymenttype = driver.FindElement(By.XPath("//*[@id='inquiryForm']/table/tbody/tr[2]/td[2]/label[1]")).Text;
                            if (i == 1)
                            {
                                if (paymenttype == "First")
                                {
                                    driver.FindElement(By.Id("paymentDate")).Clear();
                                    driver.FindElement(By.Id("paymentDate")).SendKeys(strEffectiveDate);
                                    Thread.Sleep(1000);
                                    driver.FindElement(By.Id("paymentTypeFirst")).Click();
                                    Thread.Sleep(1000);
                                    gc.CreatePdf(orderNumber, Parcel_number, "first", driver, "CO", "Adams");
                                }
                            }
                            else
                            {
                                paymenttype = driver.FindElement(By.XPath("//*[@id='inquiryForm']/table/tbody/tr[2]/td[2]/label[2]")).Text;
                                if (paymenttype == "Full")
                                {
                                    driver.FindElement(By.Id("paymentTypeFull")).Click();
                                    Thread.Sleep(2000);
                                    gc.CreatePdf(orderNumber, Parcel_number, "Full", driver, "CO", "Adams");
                                }
                                if (paymenttype == "Second")
                                {
                                    driver.FindElement(By.Id("paymentTypeSecond")).Click();
                                    Thread.Sleep(2000);
                                    gc.CreatePdf(orderNumber, Parcel_number, "Second", driver, "CO", "Adams");
                                }
                            }
                            IWebElement As_off = driver.FindElement(By.Id("paymentDate"));
                            As_of = As_off.GetAttribute("value");
                            string              strTaxesDue = "", strInterestDue = "", strPenalty = "", strTotal = "";
                            IWebElement         Totaltable = driver.FindElement(By.Id("totals"));
                            IList <IWebElement> Totalrow   = Totaltable.FindElements(By.TagName("tr"));
                            IList <IWebElement> totalth;
                            foreach (IWebElement Total in Totalrow)
                            {
                                totalth = Total.FindElements(By.TagName("td"));
                                if (totalth.Count != 0 && Total.Text.Contains("Taxes Due"))
                                {
                                    strTaxesDue = totalth[1].Text;
                                }
                                if (totalth.Count != 0 && Total.Text.Contains("Penalty"))
                                {
                                    strPenalty = totalth[1].Text;
                                }
                                if (totalth.Count != 0 && Total.Text.Contains("Interest Due"))
                                {
                                    strInterestDue = totalth[1].Text;
                                }
                                if (totalth.Count != 0 && Total.Text.Contains("Total Due"))
                                {
                                    strTotal = totalth[1].Text;
                                }
                            }
                            db.ExecuteQuery("update data_field_master set Data_Fields_Text='" + "Payment Type~Taxes Due~Interest Due~Total Due~As of" + "' where Id = '" + 1640 + "'");
                            string Totalresult = paymenttype + "~" + strTaxesDue + "~" + strInterestDue + "~" + strTotal + "~" + As_of;
                            gc.insert_date(orderNumber, Parcel_number, 1640, Totalresult, 1, DateTime.Now);
                        }
                    }

                    driver.FindElement(By.LinkText("Transaction Detail")).Click();
                    Thread.Sleep(2000);
                    IWebElement         Transationtable = driver.FindElement(By.XPath("//*[@id='middle']/table[2]/tbody"));
                    IList <IWebElement> Transationrow   = Transationtable.FindElements(By.TagName("tr"));
                    IList <IWebElement> Transationid;
                    foreach (IWebElement Transation in Transationrow)
                    {
                        Transationid = Transation.FindElements(By.TagName("td"));
                        if (Transationid.Count != 0 && !Transation.Text.Contains("Tax Year"))
                        {
                            string impromentresult = Transationid[0].Text + "~" + Transationid[1].Text + "~" + Transationid[2].Text + "~" + Transationid[3].Text + "~" + Transationid[4].Text;
                            gc.insert_date(orderNumber, Parcel_number, 1636, impromentresult, 1, DateTime.Now);
                        }
                    }
                    gc.CreatePdf(orderNumber, Parcel_number, "Transaction Detail", driver, "CO", "Adams");
                    IWebElement         summaryTransationtable = driver.FindElement(By.XPath("//*[@id='middle']/table[1]/tbody"));
                    IList <IWebElement> summaryTransationrow   = summaryTransationtable.FindElements(By.TagName("tr"));
                    IList <IWebElement> summaryTransationid;
                    foreach (IWebElement summaryTransation in summaryTransationrow)
                    {
                        summaryTransationid = summaryTransation.FindElements(By.TagName("td"));
                        if (summaryTransationid.Count != 0 & !summaryTransation.Text.Contains("Tax Year"))
                        {
                            string impromentsummaryTransationresult = summaryTransationid[0].Text + "~" + summaryTransationid[1].Text + "~" + summaryTransationid[2].Text + "~" + summaryTransationid[3].Text + "~" + summaryTransationid[4].Text + "~" + summaryTransationid[5].Text + "~" + summaryTransationid[6].Text + "~" + summaryTransationid[7].Text + "~" + Tax_Authority;
                            gc.insert_date(orderNumber, Parcel_number, 1637, impromentsummaryTransationresult, 1, DateTime.Now);
                        }
                    }
                    driver.FindElement(By.LinkText("Account Value")).Click();
                    Thread.Sleep(2000);
                    IWebElement         Authoritytable = driver.FindElement(By.XPath("//*[@id='middle']/table[3]/tbody"));
                    IList <IWebElement> Authorityrow   = Authoritytable.FindElements(By.TagName("tr"));
                    IList <IWebElement> Authorityid;
                    foreach (IWebElement Authority in Authorityrow)
                    {
                        Authorityid = Authority.FindElements(By.TagName("td"));
                        if (Authorityid.Count == 4 & !Authority.Text.Contains("Authority"))
                        {
                            string Authorityresult = Authorityid[0].Text + "~" + Authorityid[1].Text + "~" + Authorityid[2].Text + "~" + Authorityid[3].Text;
                            gc.insert_date(orderNumber, Parcel_number, 1638, Authorityresult, 1, DateTime.Now);
                        }
                    }
                    gc.CreatePdf(orderNumber, Parcel_number, "Account Value", driver, "CO", "Adams");
                    string geturl = driver.Url;
                    //Adams County Property
                    try
                    {
                        IWebElement IPropertyTax       = driver.FindElement(By.LinkText("Adams County Property Tax Notice"));
                        string      strPropertyTax     = IPropertyTax.GetAttribute("href");
                        IWebElement IReedemedTax       = driver.FindElement(By.LinkText("Redemption Certificate"));
                        string      strReedemedTax     = IReedemedTax.GetAttribute("href");
                        IWebElement IAccountBalance    = driver.FindElement(By.LinkText("Account Balance"));
                        string      strAccountBalance  = IAccountBalance.GetAttribute("href");
                        IWebElement IStatementTaxDue   = driver.FindElement(By.LinkText("Statement Of Taxes Due"));
                        string      strStatementTaxDue = IStatementTaxDue.GetAttribute("href");
                        IWebElement ISummaryTax        = driver.FindElement(By.LinkText("Summary of Taxes Due"));
                        string      strSummaryTax      = ISummaryTax.GetAttribute("href");

                        driver.Navigate().GoToUrl(strPropertyTax);
                        Thread.Sleep(6000);
                        try
                        {
                            IWebElement IPropertyTaxClick = driver.FindElement(By.LinkText("Adams County Property Tax Notice"));
                            IPropertyTaxClick.Click();
                            Thread.Sleep(4000);
                            gc.CreatePdf(orderNumber, Parcel_number, "Account Adams County Property Tax", driver, "CO", "Adams");
                        }
                        catch { }
                        driver.Navigate().GoToUrl(strReedemedTax);
                        Thread.Sleep(6000);
                        try
                        {
                            IWebElement IReedemedTaxClick = driver.FindElement(By.LinkText("Redemption Certificate"));
                            IReedemedTaxClick.Click();
                            Thread.Sleep(4000);
                            gc.CreatePdf(orderNumber, Parcel_number, "Account Redemption Certificate", driver, "CO", "Adams");
                        }
                        catch { }
                        driver.Navigate().GoToUrl(strAccountBalance);
                        Thread.Sleep(6000);
                        try
                        {
                            IWebElement IAccountTaxClick = driver.FindElement(By.LinkText("Account Balance"));
                            IAccountTaxClick.Click();
                            Thread.Sleep(4000);
                            gc.CreatePdf(orderNumber, Parcel_number, "Account Account Balance", driver, "CO", "Adams");
                        }
                        catch { }
                        driver.Navigate().GoToUrl(strStatementTaxDue);
                        Thread.Sleep(6000);
                        try
                        {
                            IWebElement IStatementTaxClick = driver.FindElement(By.LinkText("Statement Of Taxes Due"));
                            IStatementTaxClick.Click();
                            Thread.Sleep(4000);
                            gc.CreatePdf(orderNumber, Parcel_number, "Account Statement Of Taxes Due", driver, "CO", "Adams");
                        }
                        catch { }
                        driver.Navigate().GoToUrl(strSummaryTax);
                        Thread.Sleep(6000);
                        try
                        {
                            IWebElement ISummaryTaxClick = driver.FindElement(By.LinkText("Summary of Taxes Due"));
                            ISummaryTaxClick.Click();
                            Thread.Sleep(4000);
                            gc.CreatePdf(orderNumber, Parcel_number, "Account Summary of Taxes Due", driver, "CO", "Adams");
                        }
                        catch { }


                        //driver.FindElement(By.LinkText("Adams County Property Tax Notice")).Click();
                        //Thread.Sleep(9000);
                        ////*[@id="myReports"]/form/table[1]/tbody
                        //gc.CreatePdf(orderNumber, Parcel_number, "County Property Tax Notice", driver, "CO", "Adams");
                        ////driver.FindElement(By.XPath("//*[@id='myReports']/form/table[1]/tbody/tr[2]/td[2]/a"))
                        //driver.FindElement(By.LinkText("Adams County Property Tax Notice")).Click();
                        //Thread.Sleep(5000);
                        //gc.CreatePdf(orderNumber, Parcel_number, "Adams County Property", driver, "CO", "Adams");
                        //// string Adamsproperty = Countyadmslink.GetAttribute("href");
                        //driver.Navigate().GoToUrl(geturl);
                        ////Redemption Certificate
                        //driver.FindElement(By.LinkText("Redemption Certificate")).Click();
                        //Thread.Sleep(4000);
                        //IWebElement RedemWeb = driver.FindElement(By.LinkText("Redemption Certificate"));
                        //string Hrefred = RedemWeb.GetAttribute("href");
                        //gc.downloadfile(Hrefred, orderNumber, Parcel_number, "ViewTaxBill", "SC", "Lexington");
                        //Thread.Sleep(4000);
                        //gc.CreatePdf(orderNumber, Parcel_number, "Redemption County Property", driver, "CO", "Adams");
                        //driver.Navigate().GoToUrl(geturl);
                        //driver.FindElement(By.LinkText("Account Balance")).Click();
                        //Thread.Sleep(4000);
                        //driver.FindElement(By.LinkText("Account Balance")).Click();
                        //Thread.Sleep(4000);
                        //gc.CreatePdf(orderNumber, Parcel_number, "Account Balance", driver, "CO", "Adams");
                    }
                    catch { }
                    driver.Quit();
                    gc.mergpdf(orderNumber, "CO", "Adams");
                    return("Data Inserted Successfully");
                }
                catch (Exception ex)
                {
                    driver.Quit();
                    GlobalClass.LogError(ex, orderNumber);
                    throw ex;
                }
            }
        }
Beispiel #3
0
        static void Main()
        {
            Client[]     cl;
            Transation[] tr;


            cl = new Client[5];
            tr = new Transation[5];

            cl[0] = new Client(1, "Вася Петров", "+79690524788", "*****@*****.**");
            cl[1] = new Client(2, "Вера Кудря", "+79690524789", "*****@*****.**");
            cl[2] = new Client(3, "Лоя Петрова", "+79690524780", "*****@*****.**");
            cl[3] = new Client(4, "Юлия Балабан", "+79690524781", "*****@*****.**");
            cl[4] = new Client(5, "Тюпов Артем", "+79690524782", "*****@*****.**");

            tr[0] = new Transation(1, 2, "18/06/2000", "12:25:47", 500);
            tr[1] = new Transation(2, 1, "18/06/2007", "13:25:47", 600);
            tr[2] = new Transation(3, 3, "18/06/2008", "14:25:47", 700);
            tr[3] = new Transation(4, 1, "18/06/2009", "15:25:47", 800);
            tr[4] = new Transation(5, 5, "18/06/2010", "16:25:47", 900);


            // Простой запрос
            var custQuery =
                from client in cl
                select client;

            foreach (Client cli in custQuery)
            {
                Console.Write(cli.id + "---" + cli.name + "\n");
            }

            Console.Write("\n\n\n\n");

            //Запрос с where
            var custQuery1 =
                from transact in tr
                where transact.paymentAmount > 600
                select transact;

            foreach (Transation tran in custQuery1)
            {
                Console.Write(tran.id + "---" + tran.paymentAmount + "\n");
            }

            Console.Write("\n\n\n\n");

            //запрос с группировкой
            var custQuery2 =
                from transact in tr
                group transact by transact.date;

            foreach (var tranGr in custQuery2)
            {
                Console.Write(tranGr.Key + "---");
                foreach (Transation transact in tranGr)
                {
                    Console.Write(transact.id + "\n");
                }
            }

            Console.Write("\n\n\n\n");

            //запрос с джойном
            var custQuery3 =
                from transact in tr
                join client in cl on transact.idClient equals client.id
                select new { ClientName = client.name, TransactionID = transact.id };

            foreach (var item in custQuery3)
            {
                Console.WriteLine(item.ClientName + "---" + item.TransactionID + "\n");
            }

            Console.Write("\n\n\n\n");


            //запрос с let и where
            var custQuery4 =
                from client in cl
                let words = client.name.Split(' ')
                            from word in words
                            select word;

            foreach (var ct in custQuery4)
            {
                Console.Write(ct + "\n");
            }

            Console.Read();
        }