//Save to excel file
public void saveExcel()
{
//set current date to be written as excel file name
FileName_data fileName = new FileName_data()
{
currentDate = currentDate,
currentUser = currentUser,
excelPath = excelPath
};
WriteToExcel.saveExcelFile(fileName);
System.Threading.Thread.Sleep(10000);
}
//DCU Login
private void DCUlogin()
{
//Open Chrome window
ChromeOptions options = new ChromeOptions();
options.AddArgument("user-data-dir=C:/Users/RJ's Desktop/AppData/Local/Google/Chrome/User Data/Profile 1");
var cd = new ChromeDriver(options);
//naviagte to DCU.org and login
cd.Url = @"https://www.dcu.org/";
cd.Navigate();
IWebElement r = cd.FindElementById("userid");
r.SendKeys(DCU_User);
r = cd.FindElementById("password");
r.SendKeys(DCU_Pass);
r = cd.FindElementById("submitBtn");
r.Click();
//MessageBox.Show("derp wait");
cd.SwitchTo().Frame("appContainer");
//Get Data for Checking
new WebDriverWait(cd, TimeSpan.FromSeconds(20));
new WebDriverWait(cd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.XPath(".//*[@id='ext-comp-1014']/div[1]/div[2]/div[1]/div[2]/span"))));
r = cd.FindElement(By.XPath(".//*[@id='ext-comp-1014']/div[1]/div[2]/div[1]/div[2]/span"));
lblDCUCheckingData.Text = r.GetAttribute("innerHTML");
//Get Data for Savings
r = cd.FindElement(By.XPath(".//*[@id='ext-comp-1014']/div[2]/div[2]/div[1]/div[2]/span"));
lblDCUSavingsData.Text = r.GetAttribute("innerHTML");
//Get Data for VISA Credit Card
r = cd.FindElement(By.XPath(".//*[@id='ext-comp-1023']/div/div[2]/div[1]/div[2]/span"));
lblDCUCreditData.Text = r.GetAttribute("innerHTML");
//Change to account sheet for dcu
WriteToExcel dcuExcel = new WriteToExcel();
currentSheet = 2;
dcuExcel.ChangeSheet(currentSheet);
//Store accounts data in DCU_data
DCU_data accounts = new DCU_data()
{
Checking = lblDCUCheckingData.Text,
Savings = lblDCUSavingsData.Text,
Credit = lblDCUCreditData.Text
};
WriteToExcel.writeAccountsToExcelDCU(accounts);
//navigate to checking table
r = cd.FindElement(By.XPath(".//*[@id='ext-gen43']/span"));
r.Click();
//cd.SwitchTo().Frame("appContainer");
new WebDriverWait(cd, TimeSpan.FromSeconds(60)).Until(ExpectedConditions.ElementExists((By.XPath(".//*[@id='lblAccountGrid']/span/h3"))));
//obtain data
IWebElement test = cd.FindElement(By.XPath(".//*[@id='lblAccountGrid']/span/h3"));
System.Threading.Thread.Sleep(10000);
//Check for number of rows to obtain data from
for (int x = 1; x < 1000;)
{
// Store detected elements in a data list
List <IWebElement> elementList = new List <IWebElement>();
elementList.AddRange(cd.FindElements(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[2]/div")));
if (elementList.Count > 0)
{
x++;
lbltest.Text = x.ToString();
}
else
{
break;
}
}
//Convert element count to an integer. Decrease by 1 for accuracy when looping.
int checkEleCount = Convert.ToInt32(lbltest.Text);
checkEleCount--;
//change to checking excel sheet
currentSheet = 3;
dcuExcel.ChangeSheet(currentSheet);
//Add data for each transaction
for (int x = 1; x <= checkEleCount;)
{
Label[] activeLabel = { lblDateRes,
lblDesRes,
lblDeposRes,
lblWithRes,
lblBalRes, };
// Default strings. Changes after assigned new value.
string activeDate = "No good";
string activeDes = "No good";
string activeDepos = "No good";
string activeWith = "No good";
string activeBal = "No good";
string[] currentElement = { activeDate, activeDes, activeDepos, activeWith, activeBal };
//loop through each part of a row for each transaction
for (int y = 2; y < 7;)
{
try
{
r = cd.FindElement(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[" + y + "]/div"));
activeLabel[y - 2].Text = r.GetAttribute("innerHTML");
currentElement[y - 2] = activeLabel[y - 2].Text;
}
catch (NoSuchElementException)
{
r = cd.FindElement(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[" + y + "]"));
activeLabel[y - 2].Text = r.GetAttribute("innerHTML");
currentElement[y - 2] = activeLabel[y - 2].Text;
}
//go to next column in the row
y++;
}
DCU_data transactions = new DCU_data
{
Date = currentElement[0],
Description = currentElement[1],
Deposit = currentElement[2],
Withdrawl = currentElement[3],
Balance = currentElement[4],
};
WriteToExcel.writeTransactionsToExcelDCU(transactions);
//MessageBox.Show("Details were successfully added to the excel file!", "Success..", MessageBoxButtons.OK, MessageBoxIcon.Information);
x++;
}
cd.Navigate().Back();
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////Credit/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//MessageBox.Show("derp wait");
cd.SwitchTo().Frame("appContainer");
new WebDriverWait(cd, TimeSpan.FromSeconds(20));
new WebDriverWait(cd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.XPath(".//*[@id='ext-comp-1014']/div[1]/div[2]/div[1]/div[2]/span"))));
r = cd.FindElement(By.XPath(".//*[@id='ext-comp-1014']/div[1]/div[2]/div[1]/div[2]/span"));
//navigate to credit table
r = cd.FindElement(By.XPath(".//*[@id='ext-gen55']/span"));
r.Click();
//cd.SwitchTo().Frame("appContainer");
new WebDriverWait(cd, TimeSpan.FromSeconds(60)).Until(ExpectedConditions.ElementExists((By.XPath(".//*[@id='lblAccountGrid']/span/h3"))));
//obtain data
IWebElement testCredit = cd.FindElement(By.XPath(".//*[@id='lblAccountGrid']/span/h3"));
System.Threading.Thread.Sleep(10000);
//Check for number of rows to obtain data from. This will rarely ever exceed 1000 per month.
for (int x = 1; x < 1000;)
{
// Store detected elements in a data list
List <IWebElement> elementList = new List <IWebElement>();
elementList.AddRange(cd.FindElements(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[2]/div")));
if (elementList.Count > 0)
{
x++;
lbltest.Text = x.ToString();
}
else
{
break;
}
}
//Convert element count to an integer. Decrease by 1 for accuracy when looping
int checkEleCountCredit = Convert.ToInt32(lbltest.Text);
checkEleCountCredit--;
//Change to credit dcu excel sheet
WriteToExcel dcuExcelCredit = new WriteToExcel();
currentSheet = 4;
dcuExcelCredit.ChangeSheet(currentSheet);
//Add data for each transaction
for (int x = 1; x <= checkEleCountCredit;)
{
Label[] activeLabel = { lblDateRes,
lblDesRes,
lblDeposRes,
lblWithRes,
lblBalRes, };
// Default strings. Changes after assigned new value
string activeDate = "No good";
string activeDes = "No good";
string activeDepos = "No good";
string activeWith = "No good";
string activeBal = "No good";
string[] currentElement = { activeDate, activeDes, activeDepos, activeWith, activeBal };
//loop through each part of a row for each transaction
for (int y = 2; y < 7;)
{
try
{
r = cd.FindElement(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[" + y + "]/div"));
activeLabel[y - 2].Text = r.GetAttribute("innerHTML");
currentElement[y - 2] = activeLabel[y - 2].Text;
}
catch (NoSuchElementException)
{
r = cd.FindElement(By.XPath(".//*[@id='ext-gen34']/table/tbody/tr[" + x + "]/td[" + y + "]"));
activeLabel[y - 2].Text = r.GetAttribute("innerHTML");
currentElement[y - 2] = activeLabel[y - 2].Text;
}
y++;
}
DCU_data transactions = new DCU_data
{
Date = currentElement[0],
Description = currentElement[1],
Deposit = currentElement[2],
Withdrawl = currentElement[3],
Balance = currentElement[4],
};
WriteToExcel.writeTransactionsToExcelDCU(transactions);
x++;
//for (int data = 0; data < 5;)
//{
// if (activeData[data] == " ")
// {
// activeData[data] = "";
// }
// data++;
}
////set current date to be written as excel file name
//FileName fileName = new FileName()
//{
// currentDate = currentDate,
// currentUser = currentUser,
// excelPath = excelPath
//};
//MyExcel.saveExcelFile(fileName);
cd.Navigate().Back();
r = cd.FindElement(By.XPath(".//*[@id='logout']"));
r.Click();
System.Threading.Thread.Sleep(10000);
new WebDriverWait(cd, TimeSpan.FromSeconds(120));
new WebDriverWait(cd, TimeSpan.FromSeconds(60)).Until(ExpectedConditions.ElementExists((By.XPath(".//*[@id='userid']"))));
cd.Close();
System.Threading.Thread.Sleep(10000);
cd.Quit();
}
//NET Federal Credit Union Login
private void NETlogin()
{
//NET Federal Bank Login
//Run selenium
FirefoxDriver fd = new FirefoxDriver();
fd.Url = @"https://netfedcu.online-cu.com/ISuite5/Features/Auth/MFA/Default.aspx";
fd.Navigate();
IWebElement r = fd.FindElementById("ctl01_Main1_UserIDTextbox");
r.SendKeys(NET_User);
r = fd.FindElementById("ctl01_Main1_LoginBtn");
r.Click();
new WebDriverWait(fd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.Id("ctl01_Main1_PasswordTextbox"))));
r = fd.FindElementById("ctl01_Main1_PasswordTextbox");
r.SendKeys(NET_Pass);
r = fd.FindElementById("ctl01_Main1_SignInBtn");
r.Click();
//Get Data for Checking
new WebDriverWait(fd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.Id("ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl03_AvailBalLabel"))));
r = fd.FindElementById("ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl03_AvailBalLabel");
lblNetCheckingData.Text = r.GetAttribute("innerHTML");
//Get Data for Savings
new WebDriverWait(fd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.Id("ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl02_AvailBalLnkBtn"))));
r = fd.FindElementById("ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl02_AvailBalLnkBtn");
lblNetSavingsData.Text = r.GetAttribute("innerHTML");
//Store accounts data in NET_data
NET_data accounts = new NET_data()
{
Checking = lblNetCheckingData.Text,
Savings = lblNetSavingsData.Text,
};
//Write Checking and Savings to excel file
WriteToExcel.writeAccountsToExcelNET(accounts);
//Change Sheet to NET checking
startExcel.currentSheet = 5;
//navigate to checking table
//r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl03_ACSLabelLnkBtn']"));
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_MemberTab_objc0_ctl00_AccountSummaryLiteGrid_ctl03_RecentActivityLnkBtn']"));
r.Click();
System.Threading.Thread.Sleep(10000);
//Select show last 28 days in history combo box
IWebElement iWebelement = fd.FindElement(By.Id("ctl01_Main1_dropdownDateRange")); //Getting the element of the Text Box
IWebElement iWebelementList = fd.FindElement(By.Id("ctl01_Main1_dropdownDateRange")); //Getting the elements of List/Drop down Box
SelectElement selected = new SelectElement(iWebelementList); //Parsing the list
iWebelement.SendKeys(OpenQA.Selenium.Keys.ArrowDown); // Clicking the drop down image
selected.SelectByText("Last 28 Days"); // Use select element class to select the value
//click show history button
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_UISButtonShowHistory']"));
r.Click();
System.Threading.Thread.Sleep(10000);
//Check for number of rows to obtain data from
for (int x = 2; x < 1000;)
{
// Store detected elements in a data list
List <IWebElement> elementList = new List <IWebElement>();
elementList.AddRange(fd.FindElements(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid']/tbody/tr[" + x + "]/td[1]")));
if (elementList.Count > 0)
{
x++;
lbltest.Text = x.ToString();
}
else
{
break;
}
}
//Convert element count to an integer. Decrease by 2 for accuracy when looping.
int checkEleCount = Convert.ToInt32(lbltest.Text);
checkEleCount = checkEleCount - 2;
//change to checking excel sheet
currentSheet = 5;
startExcel.ChangeSheet(currentSheet);
//Add data for each transaction
for (int x = 1; x <= checkEleCount;)
{
Label[] activeLabel = { lblNetDateRes,
lblNetDesRes,
lblNetAmtRes,
lblWithRes };
// Default strings. Changes after assigned new value.
string activeNetDate = "No good Date";
string activeNetDes = "No good Des";
string activeNetAmount = "No good Amt";
string activeNetBalance = "No good Bal";
string[] currentElement = { activeNetDate, activeNetDes, activeNetAmount, activeNetBalance };
//assign values to labels for each part of the transaction in the selected row
{
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid']/tbody/tr[" + (x + 1) + "]/td[1]"));
activeLabel[0].Text = r.GetAttribute("innerHTML");
currentElement[0] = activeLabel[0].Text;
if (x < 9)
{
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid_ctl0" + (x + 1) + "_UneditedDescription']"));
}
else
{
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid_ctl" + (x + 1) + "_UneditedDescription']"));
}
activeLabel[1].Text = r.GetAttribute("innerHTML");
currentElement[1] = activeLabel[1].Text;
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid']/ tbody/tr[" + (x + 1) + "]/td[3]"));
activeLabel[2].Text = r.GetAttribute("innerHTML");
currentElement[2] = activeLabel[2].Text;
r = fd.FindElement(By.XPath(".//*[@id='ctl01_Main1_SufixListRepeater_ctl03_HistoryForRepeatSuffix1_SFXHistoryRollup_SFXHistoryGrid']/ tbody/tr[" + (x + 1) + "]/td[4]"));
activeLabel[3].Text = r.GetAttribute("innerHTML");
currentElement[3] = activeLabel[3].Text;
}
NET_data transactions = new NET_data
{
Date = currentElement[0],
Description = currentElement[1],
Amount = currentElement[2],
Balance = currentElement[3],
};
//Write transactions to excel
WriteToExcel.writeTransactionsToExcelNET(transactions);
x++;
}
fd.Navigate().Back();
//Log out of NET Bank
new WebDriverWait(fd, TimeSpan.FromSeconds(10)).Until(ExpectedConditions.ElementExists((By.Id("ctl01_LogoutImage"))));
r = fd.FindElementById("ctl01_LogoutImage");
r.Click();
//Send data from labels to NET_data for main Accounts
//MyExcel netExcel = new MyExcel();
////Open excel and set accounts excel sheet
//netExcel.currentSheet = 2;
//netExcel.InitializeExcel(excelPath + templateName);
System.Threading.Thread.Sleep(10000);
new WebDriverWait(fd, TimeSpan.FromSeconds(120));
fd.Close();
System.Threading.Thread.Sleep(10000);
fd.Quit();
}