Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //------------Read Crib Report----------------// reportcontainerstyle-Ver2
- //var table = driver.FindElement(By.Id("bandstyle-Ver21"));
- var table = driver.FindElement(By.Id("reportcontainerstyle-Ver2"));
- var rows = table.FindElements(By.TagName("tr"));
- //To get days arrears details
- var mainTable = driver.FindElement(By.Name("ConsumerCreditDetails_Version3"));
- var subTables = mainTable.FindElements(By.Id("bandstyle-Ver2"));
- List<CribData> cribData = new List<CribData>();
- //Loan and Lease
- for (int i = 0; i < rows.Count; i++)
- {
- if (i != 0)//Skip header
- {
- var row = rows[i];
- var rowTds = row.FindElements(By.TagName("td"));
- if ((rowTds[3].Text.Trim().Equals("LOAN") || rowTds[3].Text.Trim().Equals("LEAS") || rowTds[3].Text.Trim().Equals("CRCD") || rowTds[3].Text.Trim().Equals("OVDR")) && rowTds[4].Text.Trim().Equals("ACTV") && rowTds[5].Text.Trim().Equals("OWN"))
- //if(true)
- {
- var crib = new CribData();
- if (!string.IsNullOrEmpty(rowTds[0].Text))
- {
- int no;
- if (int.TryParse(rowTds[0].Text.Trim(), out no))
- crib.NO = int.Parse(rowTds[0].Text.Trim());
- }
- crib.INST_CATG = rowTds[1].Text.Trim();
- crib.INST_BRANCH = rowTds[2].Text.Trim();
- crib.CF_TYPE = rowTds[3].Text.Trim();
- crib.CF_STATUS = rowTds[4].Text.Trim();
- crib.OWNSHIP = rowTds[5].Text.Trim();
- crib.CURRUNCY = rowTds[6].Text.Trim();
- if (!string.IsNullOrEmpty(rowTds[7].Text))
- {
- decimal amount;
- if (decimal.TryParse(rowTds[7].Text.Trim(), out amount))
- crib.AMT_GRANTED = amount;
- }
- if (!string.IsNullOrEmpty(rowTds[8].Text))
- {
- decimal amount;
- if (decimal.TryParse(rowTds[8].Text.Trim(), out amount))
- crib.CUR_BALANCE = amount;
- }
- if (!string.IsNullOrEmpty(rowTds[9].Text))
- {
- decimal amount;
- if (decimal.TryParse(rowTds[9].Text.Trim(), out amount))
- crib.ARREARS_AMT = amount;
- }
- if (!string.IsNullOrEmpty(rowTds[10].Text))
- {
- decimal amount;
- if (decimal.TryParse(rowTds[10].Text.Trim(), out amount))
- crib.INSTALLMENT = amount;
- }
- if (!string.IsNullOrEmpty(rowTds[11].Text))
- {
- decimal amount;
- if (decimal.TryParse(rowTds[11].Text.Trim(), out amount))
- crib.AMT_WRITTENOFF = amount;
- }
- if (!string.IsNullOrEmpty(rowTds[12].Text))
- {
- DateTime date;
- if (DateTime.TryParse(rowTds[12].Text.Trim(), out date))
- crib.REPORTED_DATE = date;
- }
- if (!string.IsNullOrEmpty(rowTds[13].Text))
- {
- DateTime date;
- if (DateTime.TryParse(rowTds[13].Text.Trim(), out date))
- crib.DISBURSE_DATE = date;
- }
- if (!string.IsNullOrEmpty(rowTds[14].Text))
- {
- DateTime date;
- if (DateTime.TryParse(rowTds[14].Text.Trim(), out date))
- crib.LATEST_PAY_DATE = date;
- }
- if (!string.IsNullOrEmpty(rowTds[15].Text))
- {
- DateTime date;
- if (DateTime.TryParse(rowTds[15].Text.Trim(), out date))
- crib.RESTRUCT_DATE = date;
- }
- if (!string.IsNullOrEmpty(rowTds[16].Text))
- {
- DateTime date;
- if (DateTime.TryParse(rowTds[16].Text.Trim(), out date))
- crib.END_DATE = date;
- }
- crib.REPAY_TYPE = rowTds[17].Text.Trim();
- crib.PURP = rowTds[18].Text.Trim();
- crib.COVERAGE = rowTds[19].Text.Trim();
- for (int subTab = 0; subTab < subTables.Count; subTab++)
- {
- if (subTab > 1)
- {
- var colsDaysArrers = subTables[subTab].FindElements(By.TagName("td"));
- if (colsDaysArrers.Count > 0)
- {
- if (colsDaysArrers[0].Text.Equals(crib.NO.ToString()))
- {
- for (int j = 1; j <= colsDaysArrers.Count - 1; j++)
- {
- var text = colsDaysArrers[j].Text;
- if (!(text.Equals("--") || text.Equals("OK") || text.Equals("")))
- {
- var val = double.Parse(text);
- if (val > 90)
- {
- crib.FACILITYARREARSSTATUS = "Irrigular";
- break;
- }
- else
- {
- crib.FACILITYARREARSSTATUS = "Regular";
- }
- }
- }
- break;
- }
- }
- }
- }
- if (!(crib.FACILITYARREARSSTATUS != null && crib.FACILITYARREARSSTATUS.Equals("Irrigular")))
- {
- crib.FACILITYARREARSSTATUS = "Regular";
- }
- cribData.Add(crib);
- }
- //var a = td.FindElement(By.TagName("INST_CATG"));
- //Console.WriteLine("HREF: " + a.GetAttribute("href"));
- //}
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement