private void sb_saveOwnersDetailsToDB(DataTable dt, int cycleNumber) { if (dt == null) { return; } int i; Model.rwmmsVehicleOwnersDetail entry_vehicleOwnersDetail; bool add; string meliNo; using (var entityLogistic = new Model.logisticEntities()) { for (i = 0; i <= dt.Rows.Count - 1; i++) { add = false; if (!Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo])) { meliNo = dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo].ToString(); entry_vehicleOwnersDetail = entityLogistic.rwmmsVehicleOwnersDetails.FirstOrDefault(o => o.wMeliNo == meliNo); if (entry_vehicleOwnersDetail == null) { add = true; entry_vehicleOwnersDetail = new Model.rwmmsVehicleOwnersDetail(); } } else { entry_vehicleOwnersDetail = new Model.rwmmsVehicleOwnersDetail(); add = true; } //entry_vehicleOwnersDetail.companyId = companyId; entry_vehicleOwnersDetail.CycleNumber = cycleNumber; entry_vehicleOwnersDetail.FetchTime = DateTime.Now; entry_vehicleOwnersDetail.Source = "rwmms"; entry_vehicleOwnersDetail.wEmail = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_email]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_email].ToString(); entry_vehicleOwnersDetail.wFName = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_fname]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_fname].ToString(); entry_vehicleOwnersDetail.wLName = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_lname]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_lname].ToString(); entry_vehicleOwnersDetail.wMeliNo = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_meliNo].ToString(); entry_vehicleOwnersDetail.wMobileNumber = Functions.IsNull(dt.Rows[i][vehicleOwnersDetailDataTable.fld_mobileNumber]) ? null : dt.Rows[i][vehicleOwnersDetailDataTable.fld_mobileNumber].ToString(); if (add) { entityLogistic.rwmmsVehicleOwnersDetails.Add(entry_vehicleOwnersDetail); } else { entityLogistic.Entry(entry_vehicleOwnersDetail).State = System.Data.Entity.EntityState.Modified; } entityLogistic.SaveChanges(); } } }
private void sb_readOwnerDetail(int companyId, int cycleNumber) { login lg = new login(); lg.fnc_loginWithSelenium(this.v_webBrowser); bool add; string tableId = "ContentPlaceHolder1_dgVehicleOwners"; this.v_webBrowser.Navigate().GoToUrl(this.v_url); SharedFunctions.sb_waitForReady(this.v_webBrowser); var btnSearch = this.v_webBrowser.FindElement(By.Id("ContentPlaceHolder1_btnSearch")); if (btnSearch == null) { return; } btnSearch.Click(); SharedFunctions.sb_waitForReady(this.v_webBrowser); var table = this.v_webBrowser.FindElement(By.Id(tableId)); if (table == null) { return; } var rows = table.FindElements(By.TagName("tr")); if (rows == null || rows.Count < 3) { return; } var columns = rows[1].FindElements(By.TagName("td")); if (columns.Count >= 6) { var href = columns[6].FindElement(By.TagName("a")); if (href != null) { href.Click(); SharedFunctions.sb_waitForReady(this.v_webBrowser); table = this.v_webBrowser.FindElement(By.Id("ContentPlaceHolder1_dgVehicleOwnerDetails")); if (table == null) { return; } rows = table.FindElements(By.TagName("tr")); if (rows == null || rows.Count < 3) { return; } columns = rows[1].FindElements(By.TagName("td")); if (columns.Count >= 6) { href = columns[6].FindElement(By.TagName("a")); if (href != null) { href.Click(); //SharedFunctions.sb_waitForReady(this.v_webBrowser); SharedFunctions.sb_waitForReady(this.v_webBrowser); string htmlEditPage = this.v_webBrowser.PageSource; string firstName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtFirstName"); string lastName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtLastName"); string fatherName = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtFatherName"); string certNo = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtIdentityNumber"); string registerCity = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtIdentityRegisterLocation"); string meliNo = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtNationalCode"); string postalCode = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentPostCode"); string email = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentEmail"); string mobileNumber = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtMobileNumber"); string birthDate = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtBirthDate"); string address = Functions.fnc_getElementValue(htmlEditPage, "ContentPlaceHolder1_txtAgentAddress"); using (var entityLogistic = new Model.logisticEntities()) { if (!string.IsNullOrEmpty(meliNo)) { add = false; var entryOwnerExtraDetail = entityLogistic.rwmmsVehicleOwnersDetails.FirstOrDefault(o => o.wMeliNo == meliNo); if (entryOwnerExtraDetail == null) { entryOwnerExtraDetail = new Model.rwmmsVehicleOwnersDetail(); add = true; } entryOwnerExtraDetail.CycleNumber = cycleNumber; entryOwnerExtraDetail.FetchTime = DateTime.Now; entryOwnerExtraDetail.Source = this.v_url; entryOwnerExtraDetail.vehicleOwnerId = companyId; entryOwnerExtraDetail.wAddress = (Functions.IsNull(address) ? null : address); entryOwnerExtraDetail.wBirthDate = (Functions.IsNull(birthDate) ? null : birthDate); entryOwnerExtraDetail.wCertNo = (Functions.IsNull(certNo) ? null : certNo); entryOwnerExtraDetail.wEmail = (Functions.IsNull(email) ? null : email); entryOwnerExtraDetail.wFatherName = (Functions.IsNull(fatherName) ? null : fatherName); entryOwnerExtraDetail.wFName = (Functions.IsNull(firstName) ? null : firstName); entryOwnerExtraDetail.wLName = (Functions.IsNull(lastName) ? null : lastName); entryOwnerExtraDetail.wMeliNo = (Functions.IsNull(meliNo) ? null : meliNo); entryOwnerExtraDetail.wMobileNumber = (Functions.IsNull(mobileNumber) ? null : mobileNumber); entryOwnerExtraDetail.wPostalCode = (Functions.IsNull(postalCode) ? null : postalCode); entryOwnerExtraDetail.wRegisterCity = (Functions.IsNull(registerCity) ? null : registerCity); if (add) { entityLogistic.rwmmsVehicleOwnersDetails.Add(entryOwnerExtraDetail); } else { entityLogistic.Entry(entryOwnerExtraDetail).State = System.Data.Entity.EntityState.Modified; } entityLogistic.SaveChanges(); } } } } } } }