private void btn_SaveCampaignScraper_Click(object sender, EventArgs e)
{
string Location = string.Empty;
string LocationArea = string.Empty;
string Country = string.Empty;
string PostalCode = string.Empty;
string IndustryType = string.Empty;
string CompanySize = string.Empty;
string Group = string.Empty;
string SeniorLevel = string.Empty;
string Language = string.Empty;
string Relationship = string.Empty;
string Function = string.Empty;
string IntrestedIn = string.Empty;
string YearsOfExperience = string.Empty;
string RecentlyJoined = string.Empty;
string Fortune1000 = string.Empty;
string within = string.Empty;
string TitleValue = string.Empty;
string CompanyValue = string.Empty;
string FileName = string.Empty;
string FirstName = string.Empty;
string LastName = string.Empty;
string Keyword = string.Empty;
string Title = string.Empty;
string Company = string.Empty;
string CampaignName = string.Empty;
CheckNetConn = System.Net.NetworkInformation.NetworkInterface.GetIsNetworkAvailable();
if (CheckNetConn)
{
try
{
try
{
SearchCriteria.starter = true;
if (comboBoxemail.Items.Count <= 0)
{
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Load The account From Menu and switch the tab and again come to InBoardProGetData Tab ]");
lbGeneralLogs.Items.Clear();
frmAccounts FrmAccount = new frmAccounts();
FrmAccount.Show();
return;
}
if (comboBoxemail.SelectedIndex < 0)
{
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Select The Email Id From The Dropdown and Fill All Mandatory (*) Fields ]");
}
if (string.IsNullOrEmpty(txtScraperExportFilename.Text))
{
MessageBox.Show("Please Add any Name to Export File Name");
return;
}
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Starting Scraping ]");
IsStop_InBoardProGetDataThread = false;
lstInBoardProGetDataThraed.Clear();
if (string.IsNullOrEmpty(txtBoxCampaignScraperName.Text))
{
MessageBox.Show("Please write the Campaign Name and then click on Save Campaign button.");
return;
}
if (combScraperLocation.SelectedIndex == 0)
{
Location = "I";
lblScraperCountry.Visible = true;
CombScraperCountry.Visible = true;
}
else if (combScraperLocation.SelectedIndex == 1)
{
Location = "Y";
lblScraperCountry.Visible = false;
CombScraperCountry.Visible = false;
}
foreach (KeyValuePair<string, string> item in CountryCode)
{
try
{
if (item.Value == CombScraperCountry.SelectedItem.ToString())
{
Country = item.Key;
break;
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> getting CountryCode ---1--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> getting CountryCode ---1--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---1--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---1--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
#region AreaWiseLocation
foreach (var item in listAreaLocation)
{
string getAreWiseCode = HttpHelper.getHtmlfromUrl1(new Uri("http://www.linkedin.com/ta/region?query=" + item.ToString()));
int startindex = getAreWiseCode.IndexOf("\"id\":");
int startindex1 = getAreWiseCode.IndexOf("displayName");
//{"resultList":[{"id":"in:6498","headLine":"<strong>Bhilai<\/strong> Area, India","displayName":"Bhilai Area, India","subLine":""}]}
if (startindex > 0)
{
try
{
string start = getAreWiseCode.Substring(startindex).Replace("\"id\":", string.Empty);
int endindex = start.IndexOf(",");
string end = start.Substring(0, endindex).Replace(":", "%3A").Replace("\"", "");
//SearchCriteria.LocationAreaCode = end.Replace(":", "%").Replace("\"", "");
string start1 = getAreWiseCode.Substring(startindex1).Replace("displayName", string.Empty);
int endindex1 = start1.IndexOf("\",\"");
string end1 = start1.Substring(0, endindex1).Replace(":", "").Replace("\"", "");
if (string.IsNullOrEmpty(LocationArea))
{
LocationArea = end;
}
else
{
LocationArea = LocationArea + "," + end;
}
string contrycd = end.Split('%')[0].Replace("3A", string.Empty);
if (contrycd != Country)
{
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Wrong Selection of Country or Your Area Location is not matched the country ]");
return;
}
else
{
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Added Area Location: " + end1.ToString() + " ]");
}
}
catch { }
}
}
#endregion
#region Industry List
string Industryvalue = string.Empty;
string[] arrIndustry = Regex.Split(IndustryList, ",");
foreach (string Industry in checkedListBoxIndustry.CheckedItems)
{
foreach (string itemIndustry in arrIndustry)
{
try
{
if (itemIndustry.Contains(Industry))
{
string[] arryIndustry = Regex.Split(itemIndustry, ";");
if (arryIndustry.Length == 2)
{
if (!string.IsNullOrEmpty(arryIndustry[1]))
{
if (string.IsNullOrEmpty(Industryvalue))
{
Industryvalue = arryIndustry[1];
}
else
{
Industryvalue = Industryvalue + "," + arryIndustry[1];
}
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> arrIndustry 1 ---2--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> arrIndustry 1 ---2--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
//if (string.IsNullOrEmpty(Industryvalue))
//{
// Industryvalue = "select-all";
//}
IndustryType = Industryvalue;
#endregion
#region Company size List
string companysizevalue = string.Empty;
string[] arraycompnaysize = Regex.Split(companysizelist, ",");
foreach (string companysize in checkedListBoxCompanySize.CheckedItems)
{
foreach (string item in arraycompnaysize)
{
try
{
if (item.Split(':')[1] == companysize)
{
string[] ArrayCompnay = Regex.Split(item, ":");
if (!string.IsNullOrEmpty(ArrayCompnay[0]))
{
if (string.IsNullOrEmpty(companysizevalue))
{
companysizevalue = ArrayCompnay[0];
}
else
{
companysizevalue = companysizevalue + "," + ArrayCompnay[0];
}
}
//break;
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---3--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---3--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
//break;
}
if (companysizevalue == "all")
{
CompanySize = string.Empty;
}
else
{
CompanySize = companysizevalue;
}
#endregion
#region Group List
string Groupsvalue = string.Empty;
foreach (string Groups in checkedListGroups.CheckedItems)
{
//foreach (var item1 in GroupStatus.GroupMemUrl)
//{
// string[] grp = item1.Split(':');
// if (SelUser[1] == grp[0])
// {
// SpeGroupId = grp[2];
// break;
// }
//}
foreach (var item in GroupStatus.GroupMemUrl)
{
try
{
string[] grp = item.Split(':');
if (grp[0].Equals(Groups))
{
if (!string.IsNullOrEmpty(grp[2]))
{
if (string.IsNullOrEmpty(Groupsvalue))
{
Groupsvalue = grp[2];
}
else
{
Groupsvalue = Groupsvalue + "," + grp[2];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---4--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---4--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
Group = Groupsvalue;
#endregion
#region Senority List
string Seniorlevelvalue = string.Empty;
string[] senoirLevelList = Regex.Split(senioritylevel, ",");
foreach (string Seniorlevel in checkedListBoxSeniorlevel.CheckedItems)
{
foreach (string itemSeniorLevel in senoirLevelList)
{
try
{
if (itemSeniorLevel.Contains(Seniorlevel))
{
string[] arrysenoirLevel = Regex.Split(itemSeniorLevel, ":");
if (arrysenoirLevel.Length == 2)
{
if (!string.IsNullOrEmpty(arrysenoirLevel[0]))
{
if (string.IsNullOrEmpty(Seniorlevelvalue))
{
Seniorlevelvalue = arrysenoirLevel[0];
}
else
{
Seniorlevelvalue = Seniorlevelvalue + "," + arrysenoirLevel[0];
}
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> arrIndustry 1 ---2--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> arrIndustry 1 ---2--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (Seniorlevelvalue == "all")
{
SeniorLevel = string.Empty;
}
else
{
SeniorLevel = Seniorlevelvalue;
}
#endregion
#region Language List
string language = string.Empty;
string[] arrLang = Regex.Split(Language, ",");
foreach (string LanguageL in checkedListBoxLanguage.CheckedItems)
{
foreach (string item in arrLang)
{
try
{
if (item.Contains(LanguageL))
{
string[] arryLang = Regex.Split(item, ";");
if (arryLang.Length == 2)
{
if (!string.IsNullOrEmpty(arryLang[1]))
{
if (string.IsNullOrEmpty(language))
{
language = arryLang[1];
}
else
{
language = language + "," + arryLang[1];
}
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---6--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---6--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (string.IsNullOrEmpty(language))
{
//language = "select-all";
language = "";
}
language = language;
#endregion
#region Relationship List
string Relationships = string.Empty;
string[] arrRelation = Regex.Split(RelationshipList, ",");
foreach (string RelationL in checkedListRelationship.CheckedItems)
{
foreach (string item in arrRelation)
{
try
{
if (item.Contains(RelationL))
{
string[] arryRelat = Regex.Split(item, ":");
if (arryRelat.Length == 2)
{
if (!string.IsNullOrEmpty(arryRelat[0]))
{
if (string.IsNullOrEmpty(Relationships))
{
Relationships = arryRelat[0];
}
else
{
Relationships = arryRelat[0] + "," + Relationships;
}
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---7--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---7--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (Relationships == "N")
{
Relationship = string.Empty;
}
else
{
Relationship = Relationships;
}
#endregion
#region Function List
string Functions = string.Empty;
string[] FunctionList = Regex.Split(Functionlist, ",");
foreach (string FunctionL in checkedListFunction.CheckedItems)
{
foreach (string itemFunction in FunctionList)
{
try
{
if (itemFunction.Contains(FunctionL))
{
string[] functionItem = Regex.Split(itemFunction, ":");
if (!string.IsNullOrEmpty(functionItem[0]))
{
if (string.IsNullOrEmpty(Functions))
{
Functions = functionItem[0];
}
else
{
Functions = Functions + "," + functionItem[0];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---8--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---8--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (Functions == "all")
{
Function = string.Empty;
}
else
{
Function = Functions;
}
#endregion
#region IntrestedIn
string Interested_In = string.Empty;
string[] IntrestesList = Regex.Split(IntrestedinList, ",");
foreach (string InterestedL in checkedListBoxInterestedIN.CheckedItems)
{
foreach (string Intresteditem in IntrestesList)
{
try
{
if (Intresteditem.Contains(InterestedL))
{
string[] arrayIntrst = Regex.Split(Intresteditem, ":");
if (!string.IsNullOrEmpty(Intresteditem))
{
if (string.IsNullOrEmpty(Interested_In))
{
Interested_In = arrayIntrst[0];
}
else
{
Interested_In = Interested_In + "," + arrayIntrst[0];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---9--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---9--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (Interested_In == "select-all")
{
IntrestedIn = string.Empty;
}
else
{
IntrestedIn = Interested_In;
}
#endregion
#region Explerience list
string TotalExperience = string.Empty;
string[] arratExpericne = Regex.Split(expList, ",");
foreach (string YearOfExperienceL in GetDataForPrimiumAccount.CheckedItems)
{
foreach (string itemExp in arratExpericne)
{
try
{
if (itemExp.Contains(YearOfExperienceL))
{
string[] arrayitem = Regex.Split(itemExp, ":");
if (!string.IsNullOrEmpty(arrayitem[1]))
{
if (string.IsNullOrEmpty(TotalExperience))
{
TotalExperience = arrayitem[0];
}
else
{
TotalExperience = TotalExperience + "," + arrayitem[0];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---10--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---10--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (TotalExperience == "select-all")
{
YearsOfExperience = string.Empty;
}
else
{
YearsOfExperience = TotalExperience;
}
#endregion
#region Recently Joined
string Recently_Joined = string.Empty;
string[] RecetlyJoinedArr = Regex.Split(RecentlyjoinedList, ",");
foreach (string RecentlyJoinedL in checkedListBoxRecentlyJoined.CheckedItems)
{
foreach (string item in RecetlyJoinedArr)
{
try
{
string[] arrayitem = Regex.Split(item, ":");
if (item.Contains(RecentlyJoinedL))
{
if (!string.IsNullOrEmpty(arrayitem[0]))
{
if (string.IsNullOrEmpty(Recently_Joined))
{
Recently_Joined = arrayitem[0];
}
else
{
Recently_Joined = Recently_Joined + "," + arrayitem[0];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---11--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---11--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (Recently_Joined == "select-all")
{
Recently_Joined = string.Empty;
}
else
{
RecentlyJoined = Recently_Joined.Trim();
}
#endregion
#region Fortune List
string Fortune_1000 = string.Empty;
string[] FortuneArr = Regex.Split(fortuneList, ",");
foreach (string Fortune1000L in checkedListBoxFortune1000.CheckedItems)
{
foreach (string item in FortuneArr)
{
try
{
string[] arrayItem = Regex.Split(item, ":");
if (item.Contains(Fortune1000L))
{
if (!string.IsNullOrEmpty(arrayItem[0]))
{
if (string.IsNullOrEmpty(Fortune_1000))
{
Fortune_1000 = arrayItem[0];
}
else
{
Fortune_1000 = Fortune_1000 + "," + arrayItem[0];
}
}
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---12--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---12--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
}
if (RecentlyJoined == "select-all")
{
Fortune1000 = string.Empty;
}
else
{
Fortune1000 = Fortune_1000;
}
#endregion
#region Within the PostalCode
try
{
string[] arraywithinList = Regex.Split(WithingList, ",");
foreach (string item in arraywithinList)
{
if (item.Contains(cmbboxWithin.SelectedItem.ToString()))
{
string[] arrayWithin = Regex.Split(item, ":");
within = arrayWithin[0];
}
}
}
catch (Exception ex)
{
}
#endregion
#region within Title value
try
{
string[] arrayTitleList = Regex.Split(TitleValue, ",");
foreach (string item in arrayTitleList)
{
string[] arrayTitleValue = Regex.Split(item, ":");
if (arrayTitleValue[1] == cmbboxTitle.SelectedItem.ToString())
{
TitleValue = arrayTitleValue[0];
}
}
}
catch (Exception ex)
{
}
#endregion
#region within Companyvalue
try
{
if (cmbboxCompanyValue.Enabled == true)
{
string[] arrayTitleList = Regex.Split(TitleValue, ",");
foreach (string item in arrayTitleList)
{
string[] arrayTitleValue = Regex.Split(item, ":");
if (arrayTitleValue[1] == cmbboxCompanyValue.SelectedItem.ToString())
{
CompanyValue = arrayTitleValue[0];
}
}
}
}
catch (Exception ex)
{
}
#endregion
FileName = (txtScraperExportFilename.Text).Replace("\"", string.Empty).Replace(",", string.Empty).ToString();
FirstName = txtScrperFirstname.Text;
LastName = txtScrperlastname.Text;
Keyword = txtKeyword.Text;
Title = txtTitle.Text;
if (Keyword.Contains("or") || (Keyword.Contains("and")) || (Keyword.Contains("not")))
{
try
{
Keyword = Keyword.Replace(" or ", " OR ");
Keyword = Keyword.Replace(" and ", " AND ");
Keyword = Keyword.Replace(" not ", " NOT ");
}
catch { }
}
if (Title.Contains("or") || (Title.Contains("and")) || (Title.Contains("not")))
{
try
{
Title = Title.Replace(" or ", " OR ");
Title = Title.Replace(" and ", " AND ");
Title = Title.Replace(" not ", " NOT ");
}
catch { }
}
if (!string.IsNullOrEmpty(txtPostalcode.Text))
{
PostalCode = txtPostalcode.Text;
}
if (!string.IsNullOrEmpty(txtCompnayName.Text))
{
Company = txtCompnayName.Text;
}
if (CombScraperCountry.SelectedItem.ToString() != null && CombScraperCountry.SelectedIndex > 0)
{
try
{
if (!string.IsNullOrEmpty(CombScraperCountry.SelectedItem.ToString()))
{
string countryValue = string.Empty;
string temCOuntry = CombScraperCountry.SelectedItem.ToString();
GetCountryNameValue(ref temCOuntry, ref countryValue);
Country = countryValue;
}
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---13--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---13--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
CampaignName = txtBoxCampaignScraperName.Text;
string Account = comboBoxemail.SelectedItem.ToString();
clsDBQueryManager obj_clsDBQueryManager = new clsDBQueryManager();
DataTable DT = new DataTable();
DataSet DS = new DataSet();
DS = obj_clsDBQueryManager.getDataFromAccountsTable(Account);
DT = DS.Tables[0];
string Password = string.Empty;
string ProxyAddress = string.Empty;
string ProxyPort = string.Empty;
string ProxyUserName = string.Empty;
string ProxyPassword = string.Empty;
foreach (DataRow itemAccount in DT.Rows)
{
try
{
Password = itemAccount["Password"].ToString();
ProxyAddress = itemAccount["ProxyAddress"].ToString();
ProxyPort = itemAccount["ProxyPort"].ToString();
ProxyUserName = itemAccount["ProxyUserName"].ToString();
ProxyPassword = itemAccount["ProxyPassword"].ToString();
}
catch
{ }
}
//database query to insert data
string query = "Insert into tb_CampaignScraper (CampaignName, Account, FirstName, LastName, Location, Country, AreaWiseLocation, PostalCode, Company, Keyword, Title, Industry, Relationship, Language, Groups, ExportedFileName, TitleValue, CompanyValue, within, YearsOfExperience, Function, SeniorLevel, IntrestedIn, CompanySize, Fortune1000, RecentlyJoined) Values ('" + CampaignName + "','" + Account + ":" + Password + ":" + ProxyAddress + ":" + ProxyPort + ":" + ":" + ProxyUserName + ":" + ProxyPassword + "','" + FirstName + "','" + LastName + "','" + Location + "','" + Country + "','" + LocationArea + "','" + PostalCode + "','" + Company + "','" + Keyword + "','" + Title + "','" + IndustryType + "','" + Relationship + "','" + language + "','" + Group + "','" + FileName + "','" + TitleValue + "','" + CompanyValue + "','" + within + "','" + YearsOfExperience + "','" + Function + "','" + SeniorLevel + "','" + IntrestedIn + "','" + CompanySize + "','" + Fortune1000 + "','" + RecentlyJoined + "');";
obj_clsDBQueryManager.InsertCampaignScraperData(query, "tb_CampaignScraper");
frmCampaignScraper obj_frmCampaignScraper = new frmCampaignScraper();
obj_frmCampaignScraper.Show();
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Campaign Details saved with the campaign name :" + CampaignName + " ]");
}
catch (Exception ex)
{
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---13--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinErrorLogs);
GlobusFileHelper.AppendStringToTextfileNewLine("DateTime :- " + DateTime.Now + " :: Error --> btnSearchScraper_Click() ---13--->>>> " + ex.Message + "StackTrace --> >>>" + ex.StackTrace, Globals.Path_LinkedinPreScrapperErrorLogs);
}
}
else
{
MessageBox.Show("Your Internet Connection is disabled ! or not working, Please Check Your Internet Connection...");
AddLoggerScrapeUsers("[ " + DateTime.Now + " ] => [ Your Internet Connection is disabled ! or not working, Please Check Your Internet Connection... ]");
}
}