private DataTable ValidateFile(string fileName, DataTable table)
{
if (File.Exists(fileName))
{
try
{
table = Foxpro.ReadFile(fileName);
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File: " + fileName + " tidak ditemukan !");
table = null;
}
return(table);
}
private void LoadFile()
{
string fileName1 = "Htjtmp.dbf";
fileName1 = GlobalVar.DbfDownload + "\\" + fileName1;
if (UnzipFile(fileName1))
{
if (File.Exists(fileName1))
{
try
{
dtDownload = Foxpro.ReadFile(fileName1);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dtDownload.Columns.Add(newcol);
gvDownload1.DataSource = dtDownload;
lblDownloadCount1.Text = "0/" + dtDownload.Rows.Count.ToString("#,##0");
pbDownload1.Minimum = 0;
pbDownload1.Maximum = dtDownload.Rows.Count;
lblInfo1.Text = fileName1;
pbDownload1.Value = 0;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
lblInfo1.Text = "File " + fileName1 + " tidak ada.";
cmdDownload.Enabled = false;
MessageBox.Show("File: " + fileName1 + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void frmHPPRataRataDownload_Load(object sender, EventArgs e)
{
string fileName = "hppatmp\\hppatmp.DBF";
string fileZIPName = "hppatmp.zip";
fileName = GlobalVar.DbfDownload + "\\" + fileName;
fileZIPName = GlobalVar.DbfDownload + "\\" + fileZIPName;
if (UnzipFile(fileZIPName, fileName))
{
if (File.Exists(fileName))
{
try
{
dtHPPHistory = Foxpro.ReadFile(fileName);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dtHPPHistory.Columns.Add(newcol);
gvHPP.DataSource = dtHPPHistory;
lblInfoRecordCount.Text = "0/" + dtHPPHistory.Rows.Count.ToString("#,##0");
pbHPPDownload.Minimum = 0;
pbHPPDownload.Maximum = dtHPPHistory.Rows.Count;
lblFileNameLocation.Text = fileName;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
lblFileNameLocation.Text = "File " + fileName + " tidak ada.";
cmdDownload.Enabled = false;
MessageBox.Show("File: " + fileName + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download HPP rata-rata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private DataTable ValidateFile(string fileName, DataTable table)
{
if (File.Exists(fileName))
{
try
{
table = Foxpro.ReadFile(fileName);
pbSyncDownload.Value = 0;
pbSyncDownload.Minimum = 0;
pbSyncDownload.Maximum = table.Rows.Count;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File: " + fileName + " tidak ditemukan !");
}
return(table);
}
private void ExtractData()
{
string fileNameH = "datahi.dbf";
fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH;
if (File.Exists(fileNameH))
{
try
{
tblHeader = Foxpro.ReadFile(fileNameH);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHeader.Columns.Add(newcol);
//foreach (DataRow dr in tblHeader.Rows)
//{
// dr["no_perk"] = "";
//}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void LoadGridFromDBF()
{
try
{
if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada");
return;
}
string fileNameH = "hptmp.DBF";
string fileNameD = "dptmp.DBF";
string fileNamePromoB = "brgtmp.DBF";
string fileNamePromoC = "cptmp.DBF";
string fileNamePromoD = "ddptmp.DBF";
fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH;
fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD;
fileNamePromoB = GlobalVar.DbfDownload + "\\" + fileNamePromoB;
fileNamePromoC = GlobalVar.DbfDownload + "\\" + fileNamePromoC;
fileNamePromoD = GlobalVar.DbfDownload + "\\" + fileNamePromoD;
if (File.Exists(fileNameH))
{
tblPromo = Foxpro.ReadFile(fileNameH);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblPromo.Columns.Add(newcol);
DVPromo.DataSource = tblPromo;
lblPrmo.Text = "0/" + tblPromo.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("File " + fileNameH + " tidak ada");
return;
}
if (File.Exists(fileNameD))
{
try
{
tblDetailPromo = Foxpro.ReadFile(fileNameD);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblDetailPromo.Columns.Add(newcol);
DVdetailPromo.DataSource = tblDetailPromo;
lblDetailPromo.Text = "0/" + tblDetailPromo.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblDetailPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameD + " tidak ada");
return;
}
if (File.Exists(fileNamePromoB))
{
try
{
tblBPromo = Foxpro.ReadFile(fileNamePromoB);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblBPromo.Columns.Add(newcol);
DVBpromo.DataSource = tblBPromo;
lblBpromo.Text = "0/" + tblBPromo.Rows.Count.ToString("#,##0");
progressBar3.Minimum = 0;
progressBar3.Maximum = tblBPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNamePromoB + " tidak ada");
return;
}
if (File.Exists(fileNamePromoC))
{
try
{
tblCPromo = Foxpro.ReadFile(fileNamePromoC);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblCPromo.Columns.Add(newcol);
DVCpromo.DataSource = tblCPromo;
lblCpromo.Text = "0/" + tblCPromo.Rows.Count.ToString("#,##0");
progressBar4.Minimum = 0;
progressBar4.Maximum = tblCPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNamePromoC + " tidak ada");
return;
}
if (File.Exists(fileNamePromoD))
{
try
{
tblDPromo = Foxpro.ReadFile(fileNamePromoD);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblDPromo.Columns.Add(newcol);
DVDpromo.DataSource = tblDPromo;
lblDpromo.Text = "0/" + tblDPromo.Rows.Count.ToString("#,##0");
progressBar5.Minimum = 0;
progressBar5.Maximum = tblDPromo.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNamePromoD + " tidak ada");
return;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void ExtractData()
{
if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip");
}
else
{
MessageBox.Show("File dbfmatch.zip tidak ada");
this.Close();
return;
}
string fileNameH = "Hostmp.dbf";
string fileNameD = "Dostmp.dbf";
fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH;
fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD;
if (File.Exists(fileNameH))
{
try
{
tblHeader = Foxpro.ReadFile(fileNameH);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHeader.Columns.Add(newcol);
//dataGridView1.DataSource = tblHeader;
lblDownloadStatus1.Text = "0/" + tblHeader.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblHeader.Rows.Count;
this.Title = fileNameH;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
if (File.Exists(fileNameD))
{
try
{
tblDetail = Foxpro.ReadFile(fileNameD);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblDetail.Columns.Add(newcol);
//dataGridView3.DataSource = tblDetail;
lblDownloadStatus2.Text = "0/" + tblDetail.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblDetail.Rows.Count;
this.Title = this.Title + " " + fileNameD;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameH + " atau " + fileNameD + " Tidak ada");
return;
}
dtHeaderFilter = tblHeader.Clone();
dtDetailFilter = tblDetail.Clone();
}
private void frmHargaDownload11_Load(object sender, EventArgs e)
{
string fileNameBMK = "tmpbmk.DBF";
string fileNameHks = "hkstmp.DBF";
string fileNameHksAgen = "Hjualtmp.DBF";
string fileZIPName = "DBFMATCH";
fileNameBMK = GlobalVar.DbfDownload + "\\" + fileNameBMK;
fileNameHks = GlobalVar.DbfDownload + "\\" + fileNameHks;
fileNameHksAgen = GlobalVar.DbfDownload + "\\" + fileNameHksAgen;
if (UnzipFile(fileZIPName, fileNameBMK, fileNameHks, fileNameHksAgen))
{
if (File.Exists(fileNameBMK))
{
try
{
tblBMK = Foxpro.ReadFile(fileNameBMK);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblBMK.Columns.Add(newcol);
dataGridView1.DataSource = tblBMK;
lblDownloadStatus1.Text = "0/" + tblBMK.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblBMK.Rows.Count;
this.Title = fileNameBMK;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
if (File.Exists(fileNameHks))
{
try
{
tblHks = Foxpro.ReadFile(fileNameHks);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHks.Columns.Add(newcol);
dataGridView2.DataSource = tblHks;
lblDownloadStatus2.Text = "0/" + tblHks.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblHks.Rows.Count;
this.Title = fileNameHks;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
if (File.Exists(fileNameHksAgen))
{
try
{
tblHksAgen = Foxpro.ReadFile(fileNameHksAgen);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHksAgen.Columns.Add(newcol);
//dataGridView2.DataSource = tblHksAgen;
//lblDownloadStatus2.Text = "0/" + tblHksAgen.Rows.Count.ToString("#,##0");
//progressBar2.Minimum = 0;
//progressBar2.Maximum = tblHksAgen.Rows.Count;
//this.Title = fileNameHks;
//this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
dataGridView1.AutoGenerateColumns = true;
dataGridView2.AutoGenerateColumns = true;
}
}
private void ExtractData()
{
if (File.Exists(GlobalVar.DbfDownload + "\\BNSTMP.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\BNSTMP.zip");
}
string
fileName1 = GlobalVar.DbfDownload + "\\Grstktmp.dbf",
fileName2 = GlobalVar.DbfDownload + "\\Dtstktmp.dbf",
fileName3 = GlobalVar.DbfDownload + "\\Grprdtmp.dbf";
// Read table 1 (Grstktmp)
if (File.Exists(fileName1))
{
try
{
dt1 = new DataTable();
dt1 = Foxpro.ReadFile(fileName1);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dt1.Columns.Add(newcol);
dataGridView1.DataSource = dt1;
lblDlStatus1.Text = "0/" + dt1.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = dt1.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
// Read table 2 (Dtstktmp)
if (File.Exists(fileName2))
{
try
{
dt2 = new DataTable();
dt2 = Foxpro.ReadFile(fileName2);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dt2.Columns.Add(newcol);
dataGridView2.DataSource = dt2;
lblDlStatus2.Text = "0/" + dt2.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = dt2.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
// Read table 3 (Grprdtmp)
if (File.Exists(fileName3))
{
try
{
dt3 = new DataTable();
dt3 = Foxpro.ReadFile(fileName3);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dt3.Columns.Add(newcol);
dataGridView3.DataSource = dt3;
lblDlStatus3.Text = "0/" + dt3.Rows.Count.ToString("#,##0");
progressBar3.Minimum = 0;
progressBar3.Maximum = dt3.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void frmTargetSalesDownload_Load(object sender, EventArgs e)
{
if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada");
return;
}
string fileNameH = "TSlstmp.dbf";
string fileNameD = "TTokotmp.dbf";
fileNameH = GlobalVar.DbfDownload + "\\" + fileNameH;
fileNameD = GlobalVar.DbfDownload + "\\" + fileNameD;
if (File.Exists(fileNameH))
{
try
{
tblHeader = Foxpro.ReadFile(fileNameH);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblHeader.Columns.Add(newcol);
dataGridView1.DataSource = tblHeader;
lblDownloadStatus1.Text = "0/" + tblHeader.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblHeader.Rows.Count;
this.Title = fileNameH;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
//else
//{
// MessageBox.Show("File " + fileNameH + " tidak ada");
// return;
//}
if (File.Exists(fileNameD))
{
try
{
tblDetail = Foxpro.ReadFile(fileNameD);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblDetail.Columns.Add(newcol);
dataGridView2.DataSource = tblDetail;
lblDownloadStatus2.Text = "0/" + tblDetail.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblDetail.Rows.Count;
this.Title = fileNameD;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
//else
//{
// MessageBox.Show("File " + fileNameD + " tidak ada");
// return;
//}
}
private void FrmHargaJualDownload_Load(object sender, EventArgs e)
{
if (File.Exists(GlobalVar.DbfDownload + "\\DBFMATCH.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\DBFMATCH.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\DBFMATCH.zip tidak ada");
return;
}
string fileNameS = "Parttmp.dbf";
string fileNameB = "tmpbmk.dbf";
//string fileNameP = "Sptmp.dbf";
fileNameS = GlobalVar.DbfDownload + "\\" + fileNameS;
fileNameB = GlobalVar.DbfDownload + "\\" + fileNameB;
// fileNameP = GlobalVar.DbfDownload + "\\" + fileNameP;
if (File.Exists(fileNameS))
{
try
{
tblStokPart = Foxpro.ReadFile(fileNameS);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblStokPart.Columns.Add(newcol);
dataGridView1.DataSource = tblStokPart;
lblDownloadStatus1.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblStokPart.Rows.Count;
label2.Text = fileNameS;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
//else
//{
// MessageBox.Show("File " + fileNameS + " tidak ada");
// return;
//}
if (File.Exists(fileNameB))
{
try
{
tblBMK = Foxpro.ReadFile(fileNameB);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblBMK.Columns.Add(newcol);
dataGridView2.DataSource = tblBMK;
lblDownloadStatus2.Text = "0/" + tblBMK.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblBMK.Rows.Count;
label4.Text = fileNameB;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameB + " tidak ada");
return;
}
//if (File.Exists(fileNameP))
//{
// try
// {
// tblStokPart = Foxpro.ReadFile(fileNameP);
// DataColumn newcol = new DataColumn("cUploaded");
// newcol.DataType = Type.GetType("System.Boolean");
// tblStokPart.Columns.Add(newcol);
// //-dataGridView5.DataSource = tblStokPart;
// //-label9.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0");
// progressBar3.Minimum = 0;
// progressBar3.Maximum = tblStokPart.Rows.Count;
// this.Title = fileNameP;
// this.DialogResult = DialogResult.OK;
// }
// catch (Exception ex)
// {
// Error.LogError(ex);
// }
//}
//else
//{
// MessageBox.Show("File " + fileNameP + " tidak ada");
// return;
//}
}
private void LoadFile()
{
string fileName = lookupGudang.GudangID + GlobalVar.Gudang;
string fileName1 = fileName + "\\Htj2tmp.dbf";
string fileName2 = fileName + "\\Dtj2tmp.dbf";
string fileZIPName = fileName + ".zip";
fileName1 = GlobalVar.DbfDownload + "\\" + fileName1;
fileName2 = GlobalVar.DbfDownload + "\\" + fileName2;
fileZIPName = GlobalVar.DbfDownload + "\\" + fileZIPName;
if (UnzipFile(fileName, fileName1, fileName2))
{
if (File.Exists(fileName1) && File.Exists(fileName2))
{
try
{
dt1 = Foxpro.ReadFile(fileName1);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dt1.Columns.Add(newcol);
gvDownload1.DataSource = dt1;
lblDownloadCount1.Text = "0/" + dt1.Rows.Count.ToString("#,##0");
pbDownload1.Minimum = 0;
pbDownload1.Maximum = dt1.Rows.Count;
lblInfo1.Text = fileName1;
dt2 = Foxpro.ReadFile(fileName2);
DataColumn newcol2 = new DataColumn("cUploaded");
newcol2.DataType = Type.GetType("System.Boolean");
dt2.Columns.Add(newcol2);
gvDownload2.DataSource = dt2;
lblDownloadCount2.Text = "0/" + dt2.Rows.Count.ToString("#,##0");
pbDownload2.Minimum = 0;
pbDownload2.Maximum = dt2.Rows.Count;
lblInfo2.Text = fileName2;
pbDownload1.Value = 0;
pbDownload2.Value = 0;
this.DialogResult = DialogResult.OK;
cmdDownload.Enabled = true;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
lblInfo1.Text = "File " + fileName1 + " tidak ada.";
lblInfo2.Text = "File " + fileName2 + " tidak ada.";
cmdDownload.Enabled = false;
MessageBox.Show("File: " + fileName1 + " / " + fileName2 + " tidak ada. Mohon cek kembali file tersebut apakah sudah ada dilokasi file yang sudah ditentukan.", "Download", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void frmBPPDownload_Load(object sender, EventArgs e)
{
if (File.Exists(GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\BPP" + GlobalVar.Gudang + ".zip tidak ada");
return;
}
string fileName = "BPPtmp.dbf";
string fileName2 = "BPPDetailtmp.dbf";
fileName = GlobalVar.DbfDownload + "\\" + fileName;
fileName2 = GlobalVar.DbfDownload + "\\" + fileName2;
if (File.Exists(fileName))
{
try
{
dtBPP = Foxpro.ReadFile(fileName);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dtBPP.Columns.Add(newcol);
dataGridView2.DataSource = dtBPP;
dtBPP.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = dtBPP.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileName + " tidak ada");
return;
}
if (File.Exists(fileName2))
{
try
{
dtBPPDetail = Foxpro.ReadFile(fileName2);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
dtBPPDetail.Columns.Add(newcol);
dataGridView1.DataSource = dtBPPDetail;
dtBPPDetail.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = dtBPPDetail.Rows.Count;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileName2 + " tidak ada");
return;
}
}
private void frmMasterStokDownload_Load(object sender, EventArgs e)
{
if (File.Exists(GlobalVar.DbfDownload + "\\dbfmatch.zip"))
{
ExtractFile(GlobalVar.DbfDownload + "\\dbfmatch.zip");
}
else
{
MessageBox.Show("File " + GlobalVar.DbfDownload + "\\dbfmatch.zip tidak ada");
return;
}
string fileNameS = "Stktmp.dbf";
string fileNameB = "Bctmp.dbf";
string fileNameP = "Sptmp.dbf";
fileNameS = GlobalVar.DbfDownload + "\\" + fileNameS;
fileNameB = GlobalVar.DbfDownload + "\\" + fileNameB;
fileNameP = GlobalVar.DbfDownload + "\\" + fileNameP;
if (File.Exists(fileNameS))
{
try
{
tblStok = Foxpro.ReadFile(fileNameS);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblStok.Columns.Add(newcol);
dataGridView1.DataSource = tblStok;
lblDownloadStatus1.Text = "0/" + tblStok.Rows.Count.ToString("#,##0");
progressBar1.Minimum = 0;
progressBar1.Maximum = tblStok.Rows.Count;
this.Title = fileNameS;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameS + " tidak ada");
return;
}
if (File.Exists(fileNameB))
{
try
{
tblStokBarcode = Foxpro.ReadFile(fileNameB);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblStokBarcode.Columns.Add(newcol);
dataGridView4.DataSource = tblStokBarcode;
label7.Text = "0/" + tblStokBarcode.Rows.Count.ToString("#,##0");
progressBar2.Minimum = 0;
progressBar2.Maximum = tblStokBarcode.Rows.Count;
this.Title = fileNameB;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameB + " tidak ada");
return;
}
if (File.Exists(fileNameP))
{
try
{
tblStokPart = Foxpro.ReadFile(fileNameP);
DataColumn newcol = new DataColumn("cUploaded");
newcol.DataType = Type.GetType("System.Boolean");
tblStokPart.Columns.Add(newcol);
dataGridView5.DataSource = tblStokPart;
label9.Text = "0/" + tblStokPart.Rows.Count.ToString("#,##0");
progressBar3.Minimum = 0;
progressBar3.Maximum = tblStokPart.Rows.Count;
this.Title = fileNameP;
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
else
{
MessageBox.Show("File " + fileNameP + " tidak ada");
return;
}
}
