static private void CloseFormInternal()
{
LoadForm.Close();
LoadForm = null;
}
private void getDataButtonClick(object sender, EventArgs e)
{
Database1Entities db = new Database1Entities();
List <String> pkts = (from x in db.Pkts select x.kodePkt).ToList();
pktComboBox.DataSource = pkts;
/**
* load semua file pkt
**/
loadForm lf = new loadForm();
lf.Show();
Application.DoEvents();
FolderBrowserDialog fdb = new FolderBrowserDialog();
String folderPath;
if (fdb.ShowDialog() == DialogResult.OK)
{
folderPath = fdb.SelectedPath;
foreach (String temp in pkts)
{
String filePath = folderPath + "\\" + temp + ".xlsx";
//Console.WriteLine(filePath);
//filePath = Variables.parentFolder + Variables.todayYear + "\\" + Variables.todayMonth + "\\" + Variables.todayDay + "\\" + temp + ".xlsx";
//Console.WriteLine(filePath);
bool found = false;
try
{
Util.openExcel(filePath);
//Reinisialisasi
sheetIndex = 0;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
DataSet data = Util.openExcel(filePath);
ds.Add(data);
List <transaksiPkt> pktSheets = loadDataIntoClass(data);
collectionTransaksiPkt.Add(pktSheets);
List <String> sheetnames = new List <String>();
for (int i = 0; i < data.Tables.Count; i++)
{
sheetnames.Add(data.Tables[i].TableName.ToString());
}
listSheetNames.Add(sheetnames);
//comboBox1.DataSource = sheetnames;
//loadGridView(data);
Util.closeExcel();
found = true;
}
catch (Exception err)
{
}
if (!found)
{
try
{
filePath = folderPath + "\\" + temp + ".xls";
//Console.WriteLine(filePath);
//filePath = Variables.parentFolder + Variables.todayYear + "\\" + Variables.todayMonth + "\\" + Variables.todayDay + "\\" + temp + ".xls";
//Console.WriteLine(filePath);
//Reinisialisasi
sheetIndex = 0;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
DataSet data = Util.openExcel(filePath);
List <String> sheetnames = new List <String>();
for (int i = 0; i < data.Tables.Count; i++)
{
sheetnames.Add(data.Tables[i].TableName.ToString());
//Console.WriteLine(data.Tables[i].TableName.ToString());
}
listSheetNames.Add(sheetnames);
ds.Add(data);
List <transaksiPkt> pktSheets = loadDataIntoClass(data);
collectionTransaksiPkt.Add(pktSheets);
Util.closeExcel();
found = true;
}
catch (Exception err2)
{
//MessageBox.Show("File " + temp + " tidak ada");
}
}
if (!found)
{
//MessageBox.Show("File " + temp + " tidak ada");
}
}
}
lf.Close();
MessageBox.Show("Done");
comboBox1.DataSource = listSheetNames[0];
loadGridView(ds[0]);
}
static private void ShowForm()
{
LoadForm = new loadForm();
Application.Run(LoadForm);
}
