private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
Netsis netsis = new Netsis(dataGridView1);
netsis.netsis(dataGridView1);
}
if (comboBox1.SelectedIndex == 1)
{
UtilityClass uObject = new UtilityClass();
var connection = uObject.CreateOleDbConnection();
var mainDataTable = uObject.ExcelToDataTable(connection);
var lucaObject = uObject.ClassSwitcherRelatedToColumnNumber(mainDataTable, dataGridView1, connection);
mainDataTable = lucaObject.DataTableForNColumn();
uObject.SetMainDataTableVariable(mainDataTable);
}
if (comboBox1.SelectedIndex == 2)
{
LogoAccountingFront logoAccounting = new LogoAccountingFront();
logoAccounting.logoAccountingFront(dataGridView1);
}
if (comboBox1.SelectedIndex == 3)
{
LogoGeneral logoGeneral = new LogoGeneral(dataGridView1);
}
GC.Collect();
label3.Text = "Firma Adı : " + variables.FirmaAdi;
}
public DataTable GetDataTable(DataGridView dataGrid)
{
LogoAccountingFront logoAccountingFront = new LogoAccountingFront();
variables.mainDataTable = logoAccountingFront.GetTable("");
variables.mainDataTable.Columns["HESAP KODU"].SetOrdinal(0);
variables.mainDataTable.Columns["YEVMİYE TARİHİ"].SetOrdinal(1);
variables.mainDataTable.Columns["BORÇ"].SetOrdinal(2);
variables.mainDataTable.Columns["ALACAK"].SetOrdinal(3);
variables.mainDataTable.Columns.Add("BORÇ BAKİYE", typeof(string)).SetOrdinal(4);
variables.mainDataTable.Columns.Add("ALACAK BAKİYE", typeof(string)).SetOrdinal(5);
variables.mainDataTable.Columns.Add("ADAT HARİCİ TUTAR", typeof(string)).SetOrdinal(6);
variables.mainDataTable.Columns["İŞLEM Döviz BAKİYE"].SetOrdinal(7); //İşlem Görecek Tutar
variables.mainDataTable.Columns.Add("ADAT GÜN", typeof(string)).SetOrdinal(8);
variables.mainDataTable.Columns.Add("BORÇ FAİZ", typeof(string)).SetOrdinal(9);
variables.mainDataTable.Columns.Add("ALACAK FAİZ", typeof(string)).SetOrdinal(10);
//variables.mainDataTable.Columns["Hesap Kodu"].ColumnMapping = MappingType.Hidden;//Hesap Kodu Gizleme
//Gereksiz Sütunların Silinmesi
variables.mainDataTable.Columns.Remove("HESAP ADI");
variables.mainDataTable.Columns.Remove("FİŞ TÜRÜ");
variables.mainDataTable.Columns.Remove("FİŞ NO");
variables.mainDataTable.Columns.Remove("AÇIKLAMA");
variables.mainDataTable.Columns.Remove("BAKİYE");
variables.mainDataTable.Columns.Remove("TUTAR");
variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ BORÇ");
variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ ALACAK");
variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ TUTAR");
variables.mainDataTable.Columns.Remove("FİRMA DÖVİZ");
variables.mainDataTable.Columns.Remove("DÖVİZ ADI");
variables.mainDataTable.Columns.Remove("DÖVİZ KUR");
variables.mainDataTable.Columns.Remove("BELGE SERİ NO");
variables.mainDataTable.Columns.Remove("BELGE NO");
variables.mainDataTable.Columns.Remove("ÜNVAN");
variables.mainDataTable.Columns.Remove("BELGE TARİHİ");
variables.mainDataTable.Columns.Remove("SR");
return(variables.mainDataTable);
}