/// <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);
}
}
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);
}
}
/// <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>
/// 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 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ı");
}
}
}
/// <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);
}
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>
/// Если произошла отмена
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
static bool IfCancel(List <string> data)
{
PrintConsole.Header(data.ElementAt(0));
PrintConsole.Print($"Удалено {data.ElementAt(1)} из {data.ElementAt(2)}.", MenuType.InfoHeader);
BackLine.Continue();
return(false);
}
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>
/// Выйти из всех групп
/// </summary>
/// <param name="user">Пользователь</param>
/// <returns></returns>
static bool Groups(User user, CancellationToken cancellationToken)
{
string header = "Выйти из всех групп";
PrintConsole.Header(header);
Backup.Groups.Data[] list = Backup.Groups.GetGroups(user)[0] as Backup.Groups.Data[];
int i = 0;
try
{
for (; i < list.Length; i++)
{
PrintConsole.Header(header);
PrintConsole.Print($"Покинуто {i} сообществ из {list.Length}.", MenuType.InfoHeader);
PrintConsole.Print("Для отмены нажмите [SPACE].", MenuType.Warning);
user.GetApi().Groups.Leave(list[i].id);
cancellationToken.ThrowIfCancellationRequested();
}
PrintConsole.Print("Все сообщества покинуты.", MenuType.InfoHeader);
BackLine.Continue();
return(true);
}
catch (Exception e)
{
return(IfCancel(new List <string>()
{
header, $"{i}", $"{list.Length}"
}));
}
}
/// <summary>
/// Удалить всю музыку
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
static bool Music(User user, CancellationToken cancellationToken)
{
string header = "Удалить всю музыку";
PrintConsole.Header(header);
int i = 0;
var list = Get.GetList(new AnyData.Data()
{
api = user.GetApi(), id = user.GetId(), type = Get.Type.Profile, audios = null
});
try
{
for (; i < list.Length; i++)
{
PrintConsole.Header(header);
PrintConsole.Print($"Удалено {i} из {list.Length}.", MenuType.InfoHeader);
PrintConsole.Print("Для отмены нажмите [SPACE].", MenuType.Warning);
user.GetApi().Audio.Delete(list[i].id.Value, list[i].owner_id.Value);
cancellationToken.ThrowIfCancellationRequested();
}
return(true);
}
catch (Exception ex)
{
return(IfCancel(new List <string>()
{
header, $"{i}", $"{list.Length}"
}));
}
}
/// <summary>
/// Удалить все записи со стены
/// </summary>
/// <param name="user">Пользователь</param>
static bool Board(User user, CancellationToken cancellationToken)
{
string header = "Очистить стену";
PrintConsole.Header(header);
var posts = user.GetApi().Wall.Get(new WallGetParams());
int i = 0;
try
{
for (; i < posts.WallPosts.Count; i++)
{
PrintConsole.Header(header);
PrintConsole.Header($"Удалено {i} из {posts.TotalCount} записей");
PrintConsole.Print("Для отмены нажмите [SPACE].", MenuType.Warning);
user.GetApi().Wall.Delete(posts.WallPosts[i].OwnerId, posts.WallPosts[i].Id);
cancellationToken.ThrowIfCancellationRequested();
}
PrintConsole.Print("Все записи удалены.", MenuType.InfoHeader);
BackLine.Continue();
return(true);
}
catch (Exception ex)
{
return(IfCancel(new List <string>()
{
header, $"{i}", $"{posts.TotalCount}"
}));
}
}
/// <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);
}
}
/// <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>
/// 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>
/// 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>
/// Получение ID профиля после авторизации через VK.NET с токеном
/// </summary>
public static long?GetIdNet(VkApi api, string name)
{
WebClient client = new WebClient()
{
Encoding = Encoding.UTF8
};
var response = client.DownloadString($"https://api.vk.com/method/users.get?access_token={api.Token}&v=5.101");
if (response.IndexOf("error") > -1)
{
try
{
VkNet.Utils.VkErrors.IfErrorThrowException(response.ToString());
}
catch (Exception ex)
{
PrintConsole.Header(name, ex.Message);
BackLine.Continue();
}
return(null);
}
else
{
var user = JsonConvert.DeserializeObject <VkNet.Model.User>(JObject.Parse(response)["response"][0].ToString());
return(user.Id);
}
}
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);
}
}
/// <summary>
/// Вывод сообщения "продолжить?"
/// </summary>
/// /// <param name="clear">Очистить консоль перед выводом (false)</param>
public static bool ContinueQuestion(bool clear = false)
{
if (clear)
{
Console.Clear();
}
PrintConsole.Print("[1] - Продолжить");
PrintConsole.Print("\n[0] - Назад", MenuType.Back);
ConsoleKeyInfo cki;
while (true)
{
cki = Console.ReadKey(true);
if (cki.Key == ConsoleKey.D1 || cki.Key == ConsoleKey.NumPad1)
{
return(true);
}
else if (cki.Key == ConsoleKey.D0 || cki.Key == ConsoleKey.NumPad0)
{
return(false);
}
}
}
/// <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>
/// 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();
}
}
}
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>
/// 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);
}
}
}
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);
}
/// <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);
}
}
public void StartProgram()
{
PrintConsole.Welcome();
PrintConsole.WantToPlay();
bool status = GameLogic.CheckEnteredAnswer();
while (status)
{
CardDeck cardDeck = new CardDeck();
cardDeck.Initialization();
cardDeck.Mix();
Player player = new Player();
Player pc = new Player();
GameLogic.GiveCardToPlayer(player, cardDeck);
GameLogic.GiveCardToPlayer(pc, cardDeck);
GameLogic.ChooseWinner(player, pc);
PrintConsole.WantToPlayOneMoreTime();
status = GameLogic.CheckEnteredAnswer();
}
;
}
/// <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>
/// [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);
}
}
public void PrintExcel(List <string> dataList, string[] titles, string fileName)
{
if (dataList != null)
{
if (dataList.Count > 0)
{
//verilen başlık sayısına göre excel satır sayısı hesapla
int rowCount = dataList.Count() / titles.Length;
//Satır sayısı ile başlıkların sayısını çarpımı,doğrulama için
int Size = rowCount * titles.Length;
//Verilen liste ve dizi elemanları excel sayfasına düzgün yerleşiyor mu diye kontrol et, Örneğin listede 21 eleman varken,titles 4 elemanlı durumu hatalı
if (Size.Equals(dataList.Count))
{
ExcelPrinter printer = new ExcelPrinter();
//Verilen nesneler örtüşüyorsa, excele yazdıracak metodu çağır
printer.Print(dataList, titles, fileName);
}
else
{
PrintConsole._INFO("Eksik başlık bilgisi veya liste eleman sayısı istenen sayıda değil.");
}
}
}
}
