private void btnRun_Click(object sender, EventArgs e)
{
try
{//MMM =660588600 PMC =660592131
this.Enabled = false;
toolStripProgressBar1.Value = 0;
String server = GetRegistry.Registry.read(Program.RegKey, "server");
String database = GetRegistry.Registry.read(Program.RegKey, "database");
String uid = encryptQueryString.Encrypt.DecryptText(GetRegistry.Registry.read(Program.RegKey, "uid"));
String password = encryptQueryString.Encrypt.DecryptText(GetRegistry.Registry.read(Program.RegKey, "password"));
int iCount97 = 0;
switch (this.Text)
{
case "MMM 837P":
{
String table = GetRegistry.Registry.read(Program.RegKey, "Table_MMM_837P");
MMM837p clsMMM = new MMM837p(server, database, uid, password);
toolStripProgressBar1.Value = 0;
clsMMM.run(txtFoxFile.Text.Trim(), txtFileOutPut.Text, "019999999", "tblMemberMMM", table, "tblProvider", "MMM",
this.lblTotal, lblCount, toolStripProgressBar1, toolStripStatusLabel1, "660588600", dataGridView1, ref iCount97);
GetRegistry.Registry.write(Program.RegKey, "Count_MMM_837", iCount97.ToString());
}
break;
case "PMC 837P":
{
String table = GetRegistry.Registry.read(Program.RegKey, "Table_PMC_837P");
toolStripProgressBar1.Value = 0;
MMM837p clsPMC = new MMM837p(server, database, uid, password);
clsPMC.run(txtFoxFile.Text.Trim(), txtFileOutPut.Text, "039999999", "tblMemberPMC", table, "tblProvider_PMC", "PMC",
this.lblTotal, lblCount, toolStripProgressBar1, toolStripStatusLabel1, "660592131", dataGridView1, ref iCount97);
GetRegistry.Registry.write(Program.RegKey, "Count_PMC_837", iCount97.ToString());
}
break;
}
MessageBox.Show("Done...", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Enabled = true;
}
}
private void btnLoadData_Click_1(object sender, EventArgs e)
{
try
{
this.lblCount.Text = "Plase wait...";
this.Enabled = false;
switch (this.Text)
{
case "MMM 837P":
{
MMM837p clsMMM = new MMM837p(); //new MMM837p(server, database, uid, password);
clsMMM.loadData(txtFoxFile.Text, lblTotal, dataGridView1);
}
break;
case "PMC 837P":
{
MMM837p clsPMC = new MMM837p();
clsPMC.loadData(txtFoxFile.Text, lblTotal, dataGridView1);
}
break;
}
MessageBox.Show("Done...");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
this.Enabled = true;
this.lblCount.Text = "0";
}
}
