/// <summary>
/// Source içerisindeki tel ve faks noları çekiyor
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static List <string> SelectPhoneNumbers(this string source)
{
List <string> resultList = new List <string>();
try
{
Regex regex = new Regex("[1-9][1-9][1-9].([0-9]{2,3}).([0-9]{2,3}).([0-9]{1,2})", RegexOptions.IgnoreCase);
#region remove operations
source = source.RemoveCountryPhoneCode();
// source = source.RemoveLikeFaxWords();
source = source.RemoveMailWords();
source = source.RemoveWebWord();
source = source.RemoveDefinitionWords();
source = source.RemoveNoNeedCharacters();
source = source.RemoveNoMeaningChars();
#endregion
string numbers = source.SelectNumbers();
foreach (Match match in regex.Matches(source))
{
resultList.Add(match.Value);
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(resultList);
}
/// <summary>
/// [MusteriKod] [Email]
/// </summary>
/// <returns></returns>
public List <Email> getAllInfos()
{
try
{
string query = "SELECT * FROM dbo.VFirmaEmailler";
manager.Close();
manager.Open();
DataSet dataSet = manager.GetDataSet(query);
DataTable dataTable = new DataTable();
DataTableReader reader = dataSet.CreateDataReader();
dataTable.Load(reader);
manager.Close();
var emailList = new List <Email>(dataTable.Rows.Count);
foreach (DataRow row in dataTable.Rows)
{
var values = row.ItemArray;
var email = new Email()
{
MusteriKod = Convert.ToDecimal(values[0]),
MailAdresi = Convert.ToString(values[1])
};
emailList.Add(email);
}
return(emailList);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(null);
}
}
/// <summary>
/// Firma isimlerini taramadan önce kullanılır
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
private String RemoveForGettingFirmNames(String text)
{
text = text.ToLower();
text = text.RemoveALLMeaningless();
string[] patterns = new string[] {
"[0-9]",
":",
"-",
"(sayaç)(.*?)(çıkar)",
"kolkılıç.adil.hıdıroğlu",
"başakşehir(.*?)agency",
@" \. ",
"(kısıklı)|(levent)|(beşiktaş)|(üsküdar)"
};
String sourceText = text.ToLower();
foreach (var pattern in patterns)
{
try
{
sourceText = Regex.Replace(sourceText, pattern, " ");
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
return(sourceText);
}
public List <UnmatchedFirm> getList()
{
try
{
string query = "SELECT * FROM dbo.UnmatchedFirm";
DataSet dataSet = manager.GetDataSet(query);
DataTable dataTable = new DataTable();
DataTableReader reader = dataSet.CreateDataReader();
dataTable.Load(reader);
var list = new List <UnmatchedFirm>(dataTable.Rows.Count);
foreach (DataRow row in dataTable.Rows)
{
var values = row.ItemArray;
var firm = new UnmatchedFirm()
{
Id = Convert.ToDecimal(values[0]),
Unvan = Convert.ToString(values[1]),
Tel = Convert.ToString(values[2]),
Fax = Convert.ToString(values[3]),
Mail = Convert.ToString(values[4]),
Website = Convert.ToString(values[5])
};
list.Add(firm);
}
return(list);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(null);
}
}
public void EditFirmInfos(ref List <Firm> firmList)
{
try {
foreach (var firm in firmList)
{
string tel = " " + firm.firmPhone + " ";
string fax = firm.firmFax + " ";
tel = Regex.Replace(tel, " [0-9] ", "");
if (tel.StartsWith("0")) //tel numarasının başındaki 0 atılıyor
{
string[] telDigits = Regex.Split(tel, "");
tel = "";
int telDigitsCount = telDigits.Length;
for (int i = 1; i < telDigitsCount; i++)
{
tel += telDigits[i];
}
}
fax = Regex.Replace(fax, " [0-9] ", "");
firm.firmPhone = tel;
firm.firmFax = fax;
}
}
catch (Exception e) {
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
/// <summary>
/// [Musteri_kod] [ModTel]
/// </summary>
/// <returns></returns>
public List <TelNo> getAllInfos()
{
try
{
string query = "SELECT * FROM dbo.VTelefonlarYeni";
manager.Open();
DataSet dataSet = manager.GetDataSet(query);
manager.Close();
DataTable dataTable = new DataTable();
DataTableReader reader = dataSet.CreateDataReader();
dataTable.Load(reader);
var telNoList = new List <TelNo>(dataTable.Rows.Count);
foreach (DataRow row in dataTable.Rows)
{
var values = row.ItemArray;
var telNo = new TelNo()
{
MusteriKod = Convert.ToDecimal(values[0]),
TelefonNumarasi = Convert.ToString(values[1])
};
telNoList.Add(telNo);
}
return(telNoList);
} catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(null);
}
}
/// <summary>
/// Return fax...no
/// </summary>"(((fax)|(faks)))(.*?)[1-9][1-9][1-9].([0-9]{2,3}).([0-9]{2,3}).([0-9]{1,2})"
/// <param name="source"></param>
/// <returns></returns>
public static List <string> SelectFaxNumbers(this string source)
{
List <string> resultList = new List <string>();
try
{
Regex regex = new Regex("((fax)|(faks))(.*?)[1-9][1-9][1-9].([0-9]{2,3}).([0-9]{2,3}).([0-9]{1,2})", RegexOptions.IgnoreCase);
source = source.ToLower();
#region remove operations
source = source.RemoveCountryPhoneCode();
source = source.RemoveMailWords();
source = source.RemoveWebWord();
source = source.RemoveDefinitionWords();
source = source.RemoveNoNeedCharacters();
source = source.RemoveNoMeaningChars();
#endregion
foreach (Match match in regex.Matches(source))
{
string item = match.Value;
item = Regex.Replace(item, "(fax.)|(faks.)", "", RegexOptions.IgnoreCase);
if (item.Length < 21)
{
item = Regex.Replace(item, ":", "");
resultList.Add(item);
}
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(resultList);
}
/// <summary>
/// FirmList'i asenkron olarak doldurma isleminin basladigi metot,
/// ReaderService'i kullanır
/// </summary>
/// <returns></returns>
public int Start()
{
try
{
GetFirmsDelegate getFirms = ReaderService.getFirmListByXML;
IAsyncResult firmResult = getFirms.BeginInvoke(null, null);
FirmList = getFirms.EndInvoke(firmResult);
if (FirmList != null)
{
Mapping();
}
else
{
throw new Exception("FirmListCount are null");
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(1);
}
/// <summary>
/// Eşleşen ve eşleşmeyen firmaları bulan proc'ları çalıştırmak için kullanılır
/// </summary>
/// <param name="table"></param>
/// <param name="procedureName"></param>
public void executeProcedureWithTableParam(DataTable table, string procedureName)
{
try
{
using (SqlConnection connection = GetConnection())
{
connection.Open();
Console.WriteLine("Db connection is opened");
SqlCommand cmnd = new SqlCommand(procedureName, connection);
cmnd.CommandType = CommandType.StoredProcedure;
cmnd.CommandTimeout = 180;
SqlParameter param = new SqlParameter("@tableVar", SqlDbType.Structured)
{
TypeName = "dbo.FoundedFirm",
Value = table
};
cmnd.Parameters.Add(param);
Console.WriteLine("Query is ready to execute");
cmnd.ExecuteNonQuery();
Console.WriteLine("Successfully!");
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
/// <summary>
/// Select
/// </summary>
/// <param name="sqlString"></param>
/// <returns></returns>
public DataSet GetDataSet(String sqlString)
{
using (DbDataAdapter dbDataAdapter = DBFactory.GetDataAdapter(this.DBProvider))
{
try
{
dbDataAdapter.SelectCommand = DBFactory.GetCommand(this.DBProvider);
dbDataAdapter.SelectCommand.CommandText = sqlString;
dbDataAdapter.SelectCommand.Connection = this.Connection;
dbDataAdapter.SelectCommand.CommandTimeout = 120;
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable();
dataTable.BeginLoadData();
dbDataAdapter.Fill(dataTable);
dataTable.EndLoadData();
dataSet.EnforceConstraints = false;
dataSet.Tables.Add(dataTable);
return(dataSet);
}
catch (Exception ex)
{
PrintConsole.LOG(ex.StackTrace, ex.Message);
return(null);
}
}
}
/// <summary>
/// Source içerisinde soldan sağa tüm rakamları birleştiren metot
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static string SelectNumbers(this string source)
{
string numbers = "";
try
{
source = source.Trim();
#region source içerisindeki rakamları soldan sağa doğru okuyarak birleştirir
foreach (Match match in Regex.Matches(source, "[0-9]{1}"))
{
if (match.Length == 1)
{
string substr = source.Substring(match.Index, match.Length);
numbers += substr;
}
}
#endregion
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(numbers);
}
/// <summary>
/// Insert
/// </summary>
/// <param name="sqlQuery"></param>
/// <returns></returns>
public bool Execute(String sqlQuery)
{
using (DbDataAdapter adapter = DBFactory.GetDataAdapter(this.DBProvider))
{
try {
adapter.InsertCommand = DBFactory.GetCommand(this.DBProvider);
adapter.InsertCommand.CommandText = sqlQuery;
adapter.InsertCommand.Connection = this.Connection;
adapter.InsertCommand.Connection.Open();
adapter.InsertCommand.ExecuteNonQuery();
adapter.InsertCommand.Connection.Close();
return(true);
}
catch (Exception e) {
PrintConsole.LOG(e.StackTrace, e.Message);
return(false);
}
finally
{
Close();
}
}
}
public bool isExists(MatchedFirm t)
{
try
{
string query = String.Format("SELECT Id FROM dbo.MatchedFirm WHERE MusteriKodu = '{0}' AND Unvan = '{1}' AND Tel = '{2}'",
t.MusteriKodu,
t.Unvan,
t.Tel);
DataSet dataSet = manager.GetDataSet(query);
DataTable dataTable = new DataTable();
DataTableReader reader = dataSet.CreateDataReader();
dataTable.Load(reader);
if (dataTable.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(false);
}
}
private bool OpenExelWork()
{
try
{
//Yeni bir Excel Uygulaması Oluşturalım.
ExcelUygulama = new Application();
//Yeni bir Excel Projesi oluşturalım.
ExcelProje = ExcelUygulama.Workbooks.Add(Missing);
//Yeni bir Sayfa oluşturalım. (Worksheet1, Worksheet2 dediğimiz olay...)
ExcelSayfa = (Worksheet)ExcelProje.Worksheets.get_Item(1);
//Excelde kullanacağımız aralığı seçelim. (Hemen üstte ExcelSayfada Worksheet1'i seçtiğimizi görmelisiniz.)
ExcelRange = ExcelSayfa.UsedRange;
//Kullanacağımız Sayfayı (Worksheet1'i) ExcelSayfa değişkenine atayalım .
ExcelSayfa = (Worksheet)ExcelUygulama.ActiveSheet;
//Excel uygulamamızı gizleyelim.
ExcelUygulama.Visible = false;
//Uygulamamıza veri girmeden önce verilen uyarıyı gizleyelim. (bunları fazla sallamayın siz kodları kopyalayıp yapıştırın yeter.)
ExcelUygulama.AlertBeforeOverwriting = false;
return(true);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(false);
}
}
private Boolean isExists()
{
System.Xml.XmlWriter writer = null;
try
{
if (!File.Exists(FileName))
{
System.Xml.XmlWriterSettings settings = new System.Xml.XmlWriterSettings();
settings.Indent = true;
writer = System.Xml.XmlWriter.Create(FileName, settings);
writer.WriteStartDocument();
writer.WriteStartElement("WebAddresses");
writer.WriteEndElement();
writer.WriteEndDocument();
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
return(false);
}
finally
{
if (writer != null)
{
writer.Flush();
writer.Close();
}
}
return(true);
}
/// <summary>
/// Verilen source path ile html içeriğini okur ve HtmlPage.Document nesnesine atar..
/// </summary>
/// <param name="sourcePath"></param>
public override void ReadHtml(string sourcePath)
{
StreamReader streamReader = null;
try
{
string fileText = "";
string txt;
streamReader = File.OpenText(sourcePath);
txt = streamReader.ReadLine();
fileText = txt;
while (txt != null)
{
txt = streamReader.ReadLine();
fileText += txt;
}
htmlPage.Document = fileText;
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
finally
{
if (streamReader != null)
{
streamReader.Close();
}
}
}
private String RemoveForMappingFax(String text)
{
text = text.ToLower().RemoveForAllMappingOperations();
string[] patterns = new string[]
{
"-",
"www(.*?).com",
":",
"[ ]{2,5}",
"'",
" [0-9] ",
"[a-z]*@[a-z]*",
@" \. ",
@" \.tr",
" cd.",
" no",
};
String sourceText = text;
foreach (var pattern in patterns)
{
try
{
sourceText = Regex.Replace(sourceText, pattern, " ");
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
return(sourceText);
}
private void PullFirmList()
{
if (Osb_UrlList != null)
{
try {
FirmService firmService = null;
HtmlPageBuilder builder = new HtmlPageFromWebBuilder();
Parallel.For(0, Osb_UrlList.Count, i =>
{
firmService = new FirmService(builder, Osb_UrlList[i].Url, Osb_UrlList[i].HtmlTag);
IEnumerable <Firm> enumerableFirms = firmService.getFirmList();
FirmList.AddRange(enumerableFirms);
Console.WriteLine("{0} adresinden bulunan firmalar listeye eklendi", Osb_UrlList[i].Url);
});
}
catch (Exception e) {
PrintConsole.LOG(e.StackTrace, e.Message);
}
finally {
Console.WriteLine("Bütün Web Adreslerinden Tarama İşlemi Sonlandı");
}
}
}
private void PullPhoneListFromDB()
{
try {
TelNumberDAO telDAO = new TelNumberDAO();
TelNumberListFromDB = telDAO.GetTelNumberList();
int TelNumberListFromDbCount = TelNumberListFromDB.Count;
Parallel.For(0, TelNumberListFromDbCount, i =>
{
String telNo = TelNumberListFromDB[i].TelefonNumarasi;
telNo = Regex.Replace(telNo, " ", "");
telNo = " " + telNo + " ";
telNo = Regex.Replace(telNo, " [0-9] ", "");
telNo = telNo.Trim();
TelNumberListFromDB[i].TelefonNumarasi = telNo;
});
}
catch (Exception e) {
PrintConsole.LOG(e.StackTrace, e.Message);
}
finally {
Console.WriteLine("OSB-DB'den Telefon Numaraları Çekme İşlemi Sonlandı");
}
}
/// <summary>
/// Mailleri eşleştirmeden önce verilen texti düzenler ve geri döner
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
private String RemoveForMappingMails(String text)
{
text = text.ToLower().RemoveForAllMappingOperations();
string[] patterns = new string[]
{
@"( \.tr)",
":",
" www.[a-z]*. ",
" [0-9] ",
};
String sourceText = text;
foreach (var pattern in patterns)
{
try
{
sourceText = Regex.Replace(sourceText, pattern, " ");
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
return(sourceText);
}
/// <summary>
/// Tel numaralarını eşleştirmeden önce source'u hazırlar
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
private String RemoveForMappingPhone(String text)
{
text = text.ToLower().RemoveForAllMappingOperations();
string[] patterns = new string[]
{
"-",
"www(.*?).com",
":",
"[ ]{2,5}",
"'",
" [0-9] ",
"[a-z]*@[a-z]*",
@" \. ",
" cd.",
" no", "(acil telefonlar)", "itfaiye.?[0-9]* ", "emniyet.?.?.?.?.?[0-9]* ", "elektrik arıza.?.?.?.?.?[0-9]* ",
"su arıza.?.?.?.?.?[0-9]* ", "(doğalgaz arıza).?.?.?.?.?.?[0-9]*"
};
String sourceText = text;
foreach (var pattern in patterns)
{
try
{
sourceText = Regex.Replace(sourceText, pattern, " ");
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
return(sourceText);
}
/// <summary>
/// Listeleri asenkron olarak doldurma işleminin başladığı metot,
/// ReaderService'i kullanır
/// </summary>
/// <returns></returns>
private int Start()
{
try
{
isStarted = true;
GetFirmsDelegate getFirms = ReaderService.getFirmListByXML;
GetTelsDelegate getTels = ReaderService.getTelListFromDB;
GetMailsDelegate getMails = ReaderService.getMailListFromDB;
IAsyncResult firmResult = getFirms.BeginInvoke(null, null);
IAsyncResult telResult = getTels.BeginInvoke(null, null);
IAsyncResult mailResult = getMails.BeginInvoke(null, null);
FirmList = getFirms.EndInvoke(firmResult);
TelNumberListFromDB = getTels.EndInvoke(telResult);
EmailListFromDB = getMails.EndInvoke(mailResult);
if (FirmList != null && TelNumberListFromDB != null)
{
Mapping();
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(1);
}
/// <summary>
/// html kaynağından,body içeriğini html tagları ile beraber döndürür
/// </summary>
/// <param name="htmlSource"></param>
/// <returns></returns>
public static List <String> SelectBodyInnerHtml(this string htmlSource)
{
List <String> resultList = new List <String>();
try
{
HtmlAgilityPack.HtmlDocument document = new HtmlAgilityPack.HtmlDocument();
document.LoadHtml(htmlSource);
HtmlAgilityPack.HtmlNodeCollection nodeCollection = document.DocumentNode.SelectNodes("//body");
foreach (var item in nodeCollection)
{
String itemHtml = item.InnerHtml.ToString();
itemHtml = itemHtml.Trim();
if (!String.IsNullOrEmpty(itemHtml))
{
resultList.Add(itemHtml);
}
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(resultList);
}
/// <summary>
/// source içerisindeki web adreslerini listeleyen metot
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static List <string> SelectWebUrls(this string source)
{
List <string> webAdresList = new List <string>();
#region replacing
try
{
source = Regex.Replace(source, "-", "txrxe", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = Regex.Replace(source, "_", "axlxt", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
#endregion
try
{
Regex regex = new Regex("[w]{3}.([a-z]*|[0-9]*).[a-z]{3}.((tr)|(com)|(org)|(net))", RegexOptions.IgnoreCase);
foreach (Match match in regex.Matches(source))
{
if (match.Value.Count() > 8)
{
String x = match.Value;
#region replaceBack
try
{
x = Regex.Replace(x, "txrxe", "-", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
x = Regex.Replace(x, "axlxt", "_", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
#endregion
webAdresList.Add(x);
}
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(webAdresList);
}
public static String RemoveForAllMappingOperations(this String text)
{
string[] patterns = new string[]
{
"kurumsal", "hakkımızda", "vizyon", "misyon", "idari birimler", "izin|ruhsat", "tuzla",
"dede", "plaza kat", "kadıköy", " mah.atatürk", "mahalle", "cadde", " cd. ", "c barbaros", "şahabettin bilgi", " cad. ",
"(üye ol)|(üye giri[sş]i.)", "(itfaiye)|(elektrik arıza)|(su arıza)|(doğalgaz arıza)|(tıklayın)",
"tüm haklar[ıi] saklıdır", "tembelova alanı", "şevket ersoy ahmet ulvi ersoy",
"kullanım koşulları",
"organize sanayi bölgesi",
"(haberler)|(duyurular)",
"kullanım koşulları",
"gizlilik sözleşmesi",
"tıklayın..",
"(galeri)|(foto[gğ]raf)|(türkiye)|(turkey)",
"(ana.sayfa)|(linkler)|(firmalar)",
"/",
"[()]",
@"\+",
"copyright(.*?)",
@"(harita)|(bilgisi)|(için)|(tıklayınız)|(\.\.\.)",
"adres",
"(e.posta)|(e.mail)|( mail)",
"[a-z]*./.[a-z]*",
"( telefon.)|( tel.)|( yetkili)",
"(web)|(site)|(web.sitesi)",
"&(.*?);",
"&",
" h ",
"cad.",
" ( no)|(_no) ",
"tekilova alanı gençlik",
"(gebze)",
"(sosyal medya)(.*?)(maıl)",
".org.san.böl",
"(bulv)|(blv)",
"iyikesici",
"(başpınar)|(g.antep)",
"gazi.antep",
" [0-9] ",
};
String sourceText = text.ToLower();
foreach (var pattern in patterns)
{
try
{
sourceText = Regex.Replace(sourceText, pattern, " ");
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
return(sourceText);
}
/// <summary>
/// Remove like codes and tabs
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static string RemoveNoMeaningChars(this string source)
{
try
{
source = Regex.Replace(source, " ", " ", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = Regex.Replace(source, "&quuo;", "", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = Regex.Replace(source, "&", "", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = Regex.Replace(source, " ", " ", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = Regex.Replace(source, " ", " ", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
try
{
source = source.Replace("\t", " ");
while (source.IndexOf(" ") > 0)
{
source = source.Replace(" ", " ");
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(source);
}
private void PullWebSiteFromXML()
{
try {
BusinessOperations.XmlOperations.WebAddressConfig configWeb = new BusinessOperations.XmlOperations.WebAddressConfig();
Osb_UrlList = configWeb.read();
}
catch (Exception e) {
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
private List <Fax> GetDistinctFaxList()
{
List <string> faxNoKeyList = new List <string>();
List <Fax> distinctFaxList = new List <Fax>(); // distinct fax list
try
{
foreach (var item in matchedFaxList)
{
faxNoKeyList.Add(item.matchedFaxNo);
}
IEnumerable <string> distinctFaxNoKeyList = faxNoKeyList.Distinct(); // fax no tutulan liste
List <int> matchLengthList = new List <int>(); // eşleşme uzunluklarının tutulduğu liste
foreach (var item in faxNoKeyList)
{
foreach (var faxObj in matchedFaxList)
{
if (faxObj.matchedFaxNo.Equals(item))
{
matchLengthList.Add(faxObj.matchedLength);
}
}
int minLength = 1001;
foreach (var count in matchLengthList)
{
if (count < minLength)
{
minLength = count;
}
}
matchLengthList.Clear();
foreach (var faxObj in matchedFaxList)
{
if (faxObj.matchedLength.Equals(minLength) && faxObj.matchedFaxNo.Equals(item))
{
Fax faxValue = new Fax();
faxValue.matchedFirmName = faxObj.matchedFirmName;
faxValue.matchedFaxNo = item;
distinctFaxList.Add(faxValue);
}
}
}
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(distinctFaxList);
}
/// <summary>
/// DataLayerAccessMethod, file veya websitesi pathine göre builder seçip, builder.HtmlPage.ToString() veya Document objesi ile içeriği elde edebilirsiniz.
/// </summary>
/// <param name="builder"></param>
/// <param name="sourcePath"></param>
public static void Read(HtmlPageBuilder builder, String sourcePath)
{
try
{
builder.ReadHtml(sourcePath); // ilgili builder ile verilen path'den html sayfası okunuyor
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
}
/// <summary>
/// Remove Turkey countrycode +90
/// </summary>
/// <param name="source"></param>
/// <returns></returns>
public static string RemoveCountryPhoneCode(this string source)
{
try
{
source = Regex.Replace(source, "[+].[9][0].", " ", RegexOptions.IgnoreCase);
}
catch (Exception e)
{
PrintConsole.LOG(e.StackTrace, e.Message);
}
return(source);
}
