public MainWindow()
{
bool boolRunningFromHome = false;
var window = new Window() //make sure the window is invisible
{
Width = 0,
Height = 0,
Left = -2000,
WindowStyle = WindowStyle.None,
ShowInTaskbar = false,
ShowActivated = false,
};
window.Show();
IdealAutomate.Core.Methods myActions = new Methods();
myActions.ScriptStartedUpdateStats();
InitializeComponent();
this.Hide();
_JobBoardName jobBoard = _JobBoardName.Dice;
string strWindowTitle = myActions.PutWindowTitleInEntity();
if (strWindowTitle.StartsWith("JobSearch"))
{
myActions.TypeText("%(\" \"n)", 1000); // minimize visual studio
}
myActions.Sleep(1000);
SqlConnection con = new SqlConnection("Server=(local)\\SQLEXPRESS02;Initial Catalog=IdealAutomateDB;Integrated Security=SSPI");
SqlCommand cmd = new SqlCommand();
bool developermode = false;
cmd.Connection = con;
string[] locations =
{
"Northbrook|101594833|SRCH_IL.0,10_IC1128934_KO11,12|42.1275267|-87.82895479999999",
"Skokie|104075955|SRCH_IL.0,6_IC1128973_KO7,8|42.03240249999999|-87.7416246",
"Wilmette|105652554|SRCH_IL.0,8_IC1129007_KO9,10|42.0722513|-87.7228384",
"Evanston|103984459|SRCH_IL.0,8_IC1128835_KO9,10|42.04507219999999|-87.68769689999999",
"Lake Forest|101957782|SRCH_IL.0,11_IC1128891_KO12,13|42.25863419999999|-87.840625",
"Morton Grove|107073968|SRCH_IL.0,12_IC1128925_KO13,14|42.0405852|-87.78256209999999",
"Deerfield|103159347|SRCH_IL.0,9_IC1128821_KO10,11|42.1711365|-87.8445119",
"Niles|104326590|SRCH_IL.0,5_IC1128931_KO6,7|42.0189191|-87.80284019999999",
"Lincolnwood|100872165|SRCH_IL.0,11_IC1128899_KO12,13|42.0044757|-87.73005940000002",
// "Northfield|",
"Winnetka|101817485|SRCH_IL.0,8_IC1129010_KO9,10|42.10808340000001|-87.735895",
"Glenview|103959268|SRCH_IL.0,8_IC1128852_KO9,10|42.07780649999999|-87.8223368",
"Glencoe|100896055|SRCH_IL.0,7_IC1128850_KO8,9|42.13502679999999|-87.75811879999999",
"Wheeling|101337567|SRCH_IL.0,8_IC1129004_KO9,10|42.1391927|-87.9289591",
"Buffalo Grove|104624642|SRCH_IL.0,13_IC1128800_KO14,15|42.1662831|-87.9631308",
//"Rosemont|",
"Park Ridge|103579343|SRCH_IL.0,10_IC1128947_KO11,12|42.0111412|-87.84061919999999",
//"Remote|92000001|SRCH_IL.0,6_IS11047_KO7,8_IP2"
};
string[] keywords =
{
"c%23",
"WPF",
"Machine Learning",
"OutSystems"
};
foreach (_JobBoardName jobBoardx in Enum.GetValues(typeof(_JobBoardName)))
{
//jobBoard = jobBoardx;
//if (jobBoardx == _JobBoardName.LinkedIn)
//{
// continue;
//}
if (jobBoardx == _JobBoardName.Indeed)
{
continue;
}
if (jobBoardx == _JobBoardName.Dice)
{
continue;
}
if (jobBoardx == _JobBoardName.Glassdoor)
{
continue;
}
foreach (var keyword in keywords)
{
foreach (var location in locations)
{
bool processNextPage = true;
int start = 0;
while (processNextPage == true)
{
PerformSearch(con, cmd, jobBoardx, myActions, keyword, location, ref developermode, ref processNextPage, ref start);
start += 25;
}
}
}
}
myActions.MessageBoxShow("Done");
goto myExit;
myExit:
myActions.ScriptEndedSuccessfullyUpdateStats();
Application.Current.Shutdown();
}
/// <summary>
/// Writes jobs found to database jobapplications
/// </summary>
/// <param name="con"></param>
/// <param name="cmd"></param>
/// <param name="jobBoard"></param>
/// <param name="myActions"></param>
/// <param name="keyword"></param>
/// <param name="location"></param>
/// <param name="developermode">the first pass switch</param>
/// <param name="processNextPage"></param>
/// <param name="start"></param>
void PerformSearch(SqlConnection con,
SqlCommand cmd,
_JobBoardName jobBoard,
Methods myActions,
string keyword,
string location,
ref bool developermode,
ref bool processNextPage,
ref int start)
{
//
// S T A R T N E W P R O C E S S: chrome
//
List <string> myWindowTitles4 = myActions.GetWindowTitlesByProcessName("chrome");
myWindowTitles4.RemoveAll(item => item == "");
string[] locgeo = location.Split('|');
string myUrlTarget = "";
switch (jobBoard)
{
case _JobBoardName.LinkedIn:
myUrlTarget = "https://www.linkedin.com/jobs/search/?distance=1&geoId=" + locgeo[1] + "&keywords=" + keyword + "&location=" + locgeo[0] + "%2C%20Illinois%2C%20United%20States&msgConversationId=6647936427130699776&msgOverlay=true&start=" + start;
break;
case _JobBoardName.Indeed:
myUrlTarget = "https://www.indeed.com/jobs?q=" + keyword + "&l=" + locgeo[0] + "%2C+IL&radius=0";
if (myUrlTarget.Contains("Remote"))
{
myUrlTarget = myUrlTarget.Replace("Remote%2C+IL", "Remote");
}
break;
case _JobBoardName.Glassdoor:
if (keyword == "c%23")
{
myUrlTarget = "https://www.glassdoor.com/Job/" + locgeo[0] + "-" + "c" + "-" + locgeo[2] + ".htm?radius=0";
}
else
{
myUrlTarget = "https://www.glassdoor.com/Job/" + locgeo[0] + "-" + keyword + "-" + locgeo[2] + ".htm?radius=0";
}
break;
case _JobBoardName.Dice:
myUrlTarget = "https://www.dice.com/jobs?q=" + keyword + "&location=" + locgeo[0] + ",%20IL,%20USA&latitude=" + locgeo[3] + "&longitude=" + locgeo[4] + "&countryCode=US&locationPrecision=City&radius=1&radiusUnit=mi&page=1&pageSize=100&language=en&includeRemote=false";
if (myUrlTarget.Contains("Remote%2C+IL"))
{
myUrlTarget = myUrlTarget.Replace("Remote%2C+IL", "Remote").Replace("includeRemote=false", "includeRemote=true");
}
break;
//case _JobBoardName.Monster:
// break;
default:
break;
}
if (!myWindowTitles4[0].Contains(jobBoard.ToString()))
{
// You may need to manually add content parameter as second parameter for run???
myActions.Run(@"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe", myUrlTarget);
myActions.Sleep(1000);
}
if (myWindowTitles4.Count > 0)
{
myActions.ActivateWindowByTitle(myWindowTitles4[0], (int)WindowShowEnum.SW_SHOWMAXIMIZED);
}
if (start > 0)
{
myActions.Sleep(2000);
}
myActions.TypeText("%(d)", 1500); // select address bar
myActions.TypeText("^(a)", 1500);
myActions.TypeText("^(c)", 1500);
string myUrl = myActions.PutClipboardInEntity();
if (myUrl != myUrlTarget && jobBoard != _JobBoardName.Glassdoor)
{
myActions.SelectAllPasteFromEntity(myUrlTarget, 500);
myActions.TypeText("{ENTER}", 500);
// Console.WriteLine("Enter pressed");
}
int count = 0;
ImageEntity myImage = new ImageEntity();
if (jobBoard != _JobBoardName.Glassdoor)
{
// wait for location in title except for dice because dice does not display location in title
if (jobBoard != _JobBoardName.Dice)
{
while (!myWindowTitles4[0].Contains(locgeo[0]) && count < 10)
{
myActions.Sleep(1000);
myWindowTitles4 = myActions.GetWindowTitlesByProcessName("chrome");
myWindowTitles4.RemoveAll(item => item == "");
count++;
}
if (count == 10)
{
// Console.WriteLine(string.Format("could not find {0} in title", locgeo[0]));
}
}
checkLoaded:
myImage = new ImageEntity();
switch (jobBoard)
{
case _JobBoardName.LinkedIn:
myImage.ImageFile = "Images\\Jobs.PNG";
break;
case _JobBoardName.Indeed:
myImage.ImageFile = "Images\\IndeedLoaded.PNG";
break;
case _JobBoardName.Glassdoor:
myImage.ImageFile = "Images\\GlassDoorLoaded.PNG";
break;
case _JobBoardName.Dice:
myImage.ImageFile = "Images\\DiceLoaded.PNG";
myImage.Tolerance = 99;
break;
//case _JobBoardName.Monster:
// break;
default:
break;
}
myImage.Sleep = 2000;
myImage.Attempts = 20;
myImage.RelativeX = 10;
myImage.RelativeY = 10;
int[,] myArray2 = myActions.PutAll(myImage);
if (myArray2.Length == 0)
{
Console.WriteLine("page not loaded");
goto checkLoaded;
}
}
myImage = new ImageEntity();
myImage.Sleep = 500;
myImage.Attempts = 20;
myImage.RelativeX = 10;
myImage.RelativeY = 10;
myImage.Tolerance = 97;
switch (jobBoard)
{
case _JobBoardName.LinkedIn:
break;
case _JobBoardName.Indeed:
break;
case _JobBoardName.Glassdoor:
myImage.RelativeX = -100;
myImage.RelativeY = 20;
myImage.ImageFile = "Images\\Search.PNG";
myActions.ClickImageIfExists(myImage);
myActions.TypeText("^(a)", 500);
myActions.TypeText(locgeo[0] + ", IL", 500);
myActions.TypeText("+({TAB})", 500);
myActions.TypeText("+({TAB})", 500);
myActions.TypeText("^(a)", 500);
myActions.TypeText(keyword.Replace("c%23", "c#"), 500);
myImage.ImageFile = "Images\\Search.PNG";
myImage.RelativeX = 10;
myImage.RelativeY = 10;
myActions.ClickImageIfExists(myImage);
myActions.Sleep(2000);
myImage.Tolerance = 99;
myImage.ImageFile = "Images\\ExactLocation.PNG";
myActions.ClickImageIfExists(myImage);
myImage.ImageFile = "Images\\ExactLocationChecked.PNG";
myActions.ClickImageIfExists(myImage);
myActions.Sleep(5000);
break;
case _JobBoardName.Dice:
break;
//case _JobBoardName.Monster:
// break;
default:
break;
}
myImage = new ImageEntity();
myImage.Sleep = 200;
myImage.Attempts = 1;
myImage.RelativeX = 10;
myImage.RelativeY = 10;
myImage.Tolerance = 99;
switch (jobBoard)
{
case _JobBoardName.LinkedIn:
myImage.ImageFile = "Images\\NoMatchingJobsLinkedIn.PNG";
break;
case _JobBoardName.Indeed:
myImage.ImageFile = "Images\\NoJobsFoundWithinIndeed.PNG";
break;
case _JobBoardName.Glassdoor:
myImage.ImageFile = "Images\\NoJobsGlassDoor.PNG";
break;
case _JobBoardName.Dice:
myImage.ImageFile = "Images\\NoJobsDice.PNG";
break;
//case _JobBoardName.Monster:
// break;
default:
break;
}
int[,] myArray = myActions.PutAll(myImage);
if (myArray.Length == 0)
{
// linkedin steps
// use ctrl-shift-j to open console
// ctrl-[ to go to elements
// ctrl-c
// read each line looking for href="/jobs/view
// when line contains href="/jobs/view, need to find closing double quote and add the
// text found to url list
// begin-delim = href="/jobs/view
// end-delim = double quote
// first time do ctrl-shift j only once; other times, do it twice to reset everything
myImage = new ImageEntity();
myImage.Sleep = 200;
myImage.Attempts = 1;
myImage.RelativeX = 10;
myImage.RelativeY = 10;
myImage.Tolerance = 99;
myImage.ImageFile = "Images\\DevToolsModeOn.PNG";
int[,] myArray2 = myActions.PutAll(myImage);
if (myArray2.Length != 0)
{
// linkedin steps
myActions.TypeText("^+(j)", 3500);
}
myActions.TypeText("^+(j)", 3500);
myImage = new ImageEntity();
myImage.ImageFile = "Images\\DevToolsElements.PNG";
myImage.Sleep = 500;
myImage.Attempts = 5;
myImage.RelativeX = 10;
myImage.RelativeY = 10;
myImage.Tolerance = 99;
myArray = myActions.PutAll(myImage);
if (myArray.Length == 0)
{
Console.WriteLine("could not find elements tab in developer tools");
}
myActions.TypeText("^([)", 3500);
developermode = true;
myActions.Sleep(2000);
string myPage = myActions.SelectAllCopyIntoEntity(2500);
int indexOfPagination = myPage.IndexOf("pagination");
if (indexOfPagination == -1 || jobBoard == _JobBoardName.Indeed || jobBoard == _JobBoardName.Dice)
{
processNextPage = false;
}
switch (jobBoard)
{
case _JobBoardName.LinkedIn:
myPage = FindJobsUpdateDB_LinkedIn(con, cmd, myActions, keyword, locgeo, myPage);
break;
case _JobBoardName.Indeed:
myPage = FindJobsUpdateDB_Indeed(con, cmd, myActions, keyword, locgeo, myPage);
break;
case _JobBoardName.Glassdoor:
myPage = FindJobsUpdateDB_Glassdoor(con, cmd, myActions, keyword, locgeo, myPage);
break;
case _JobBoardName.Dice:
myPage = FindJobsUpdateDB_Dice(con, cmd, myActions, keyword, locgeo, myPage);
break;
//case _JobBoardName.Monster:
// break;
default:
break;
}
// Console.WriteLine("Jobs found");
}
else
{
processNextPage = false;
return;
}
}