private void SaveCases(PalmCaseInfoClass InfoCases) { using (CaseEntities Ctx = new CaseEntities()) { foreach (var WrkCase in InfoCases.ListaCasos) { // Salvar Info en MainCases MAINCAS Mc = new MAINCAS(); Mc.ID = Guid.NewGuid(); Mc.COUNTY = County; Mc.CASENUMBER = CleanString(WrkCase.CaseNumber); Mc.CASETYPE = WrkCase.CaseType; Mc.CASESTATUS = WrkCase.CaseStatus; Mc.PRIMARY_PARTY = WrkCase.PrimaryParty; Mc.SECONDARY_PARTY = WrkCase.SecondaryParty; Mc.FILEDATE = WrkCase.FileDate; Mc.NOTES = WrkCase.Courts; Ctx.MAINCASES.Add(Mc); } // Salvar Cuantos Records por fecha. RecordsXdia Rdia = new RecordsXdia(); Rdia.COUNTY = InfoCases.County; Rdia.DATE1 = StartDay; Rdia.DATE2 = EndDay; Rdia.CASOS = InfoCases.NumberOfCases; Ctx.RecordsXdias.Add(Rdia); // Save Changes. var x = Ctx.SaveChanges(); } }
private void MainBrowser_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e) { // Determinar en Que pagina Estoy. // Tomar Desicion // CASE // Darle a Pagina Anterior. if (cbGetCases.Checked) { int Activity = 0; var WPDoc = new HtmlAgilityPack.HtmlDocument(); var doc = ((MainForm)Application.OpenForms[0]).MainBrowser.Document; var renderedHtml = doc.GetElementsByTagName("HTML")[0].OuterHtml; WPDoc.LoadHtml(renderedHtml); var SearchBtn = doc.GetElementById("ctl00$cphBody$cmdSearch"); var CancelBtn = doc.GetElementById("ctl00$cphBody$cmdClear"); var ViewElements = doc.GetElementById("cphBody_cmbPageSize"); if (SearchBtn != null && CancelBtn != null) { Activity = 1; } if (ViewElements != null) { if (ViewElements.OuterHtml.IndexOf("selected=\"selected\" value=\"All\">") > 0) { Activity = 3; } else { Activity = 2; } } if (renderedHtml.Contains("Modify your search criteria by selecting the Search Criteria tab")) { Activity = 4; } switch (Activity) { //ctl00$cphBody$gvSearch$ctl09$txtParameter: 01 / 01 / 2013 //ctl00$cphBody$gvSearch$ctl10$txtParameter: 02 / 01 / 2013 //ctl00$cphBody$gvSearch$ctl11$cmbParameterPostBack: 101 //ctl00$cphBody$gvSearch$ctl12$cmbParameterNoPostBack: 146 //ctl00$cphBody$gvSearch$ctl13$cmbParameterNoPostBack: 96 case 1: { var BeginDate = doc.GetElementById("cphBody_gvSearch_txtParameter_7"); var EndDate = doc.GetElementById("cphBody_gvSearch_txtParameter_8"); var CourtType = doc.GetElementById("cphBody_gvSearch_cmbParameterPostBack_9"); CourtType.SetAttribute("Value", "101"); var CaseType = doc.GetElementById("cphBody_gvSearch_cmbParameterNoPostBack_10"); Thread.Sleep(2000); // var SearchDate = GetMeDate(); SelectNewDayRange(); BeginDate.SetAttribute("Value", StartDay.ToString("MM/dd/yyyy")); EndDate.SetAttribute("Value", EndDay.ToString("MM/dd/yyyy")); CaseType.SetAttribute("Value", "146"); SearchBtn.InvokeMember("Click"); logclick("Search"); break; } case 2: { ViewElements.SetAttribute("Value", "All"); ViewElements.InvokeMember("onChange"); // MainBrowser.Refresh(WebBrowserRefreshOption.Completely); logclick("Search"); break; } case 3: { PalmCaseInfoClass CInfo = new PalmCaseInfoClass(); CInfo.County = County; // Tomar Casos en el Dia; var CasosDiaStr = doc.GetElementById("cphBody_lblRecordsReturned"); if (CasosDiaStr != null) { CInfo.NumberOfCases = Convert.ToInt32(CasosDiaStr.InnerText); var wrkint = CInfo.NumberOfCases; if (wrkint == 200) { StartDay.AddDays(AdicionarDias * -1); StartDay.AddDays(-1); EndDay = StartDay; EndDay.AddDays(AdicionarDias); AdicionarDias = AdicionarDias - 3; MainBrowser.Navigate("https://applications.mypalmbeachclerk.com/eCaseView/search.aspx"); logclick("Main Page"); break; } else { var casosxdia = wrkint / AdicionarDias; var amplitud = casosxdia * 3; var cabe = (200 - amplitud); if (wrkint > cabe) { AdicionarDias++; } } } var TablaCasos = WPDoc.GetElementbyId("cphBody_gvResults"); var CasesInfoRow = TablaCasos.Descendants("tr").ToList(); foreach (var Crow in CasesInfoRow) { if (!Crow.InnerText.Contains("Arrest Date")) { var CasesInfoColumn = Crow.Descendants("td").ToList(); int Num = 0; string[] AColInfo = new string[7]; foreach (var Ccol in CasesInfoColumn) { AColInfo[Num] = Ccol.InnerText; Num++; } pbICases WC = new pbICases(); WC.CaseNumber = AColInfo[0]; WC.Courts = AColInfo[1]; WC.CaseType = AColInfo[2]; try { WC.FileDate = Convert.ToDateTime(AColInfo[4]); } catch { WC.FileDate = Convert.ToDateTime("2008-01-01"); } if (!string.IsNullOrEmpty(AColInfo[5])) { if (AColInfo[5].IndexOf(" V ") > 0) { WC.PrimaryParty = AColInfo[5].Substring(0, AColInfo[5].IndexOf(" V ")); WC.SecondaryParty = AColInfo[5].Substring(AColInfo[5].IndexOf(" V ") + 3); } else { WC.PrimaryParty = AColInfo[5]; WC.SecondaryParty = AColInfo[5]; } } WC.CaseStatus = AColInfo[6]; CInfo.ListaCasos.Add(WC); CInfo.FileDate = WC.FileDate; } } // Salvar en Async y Threadding. SaveCases(CInfo); // Slow the speed Thread.Sleep(24000); // cphBody_lbSearch // Volver a la pantalla de Busqueda //var SearchLink = doc.GetElementById("ctl00$cphBody$cmdSearch"); //SearchBtn.InvokeMember("Click"); MainBrowser.Navigate("https://applications.mypalmbeachclerk.com/eCaseView/search.aspx"); logclick("Main Page"); break; } case 4: { MainBrowser.Navigate("https://applications.mypalmbeachclerk.com/eCaseView/search.aspx"); logclick("Main Page"); break; } } } }