private void DeletePkgsFromBiosumProject_Finish()
{
if (m_frmTherm != null)
{
frmMain.g_oDelegate.ExecuteControlMethod(m_frmTherm, "Close");
frmMain.g_oDelegate.ExecuteControlMethod(m_frmTherm, "Dispose");
m_frmTherm = null;
}
m_strCurrentProcess = "";
frmMain.g_oDelegate.SetControlPropertyValue(this, "Enabled", true);
((frmDialog)ParentForm).MinimizeMainForm = false;
}
private void ThreadCleanUp()
{
try
{
frmMain.g_oDelegate.SetControlPropertyValue((System.Windows.Forms.Form)ReferenceFormDialog, "Visible",
true);
frmMain.g_oDelegate.SetControlPropertyValue((System.Windows.Forms.Form)ReferenceFormDialog, "Enabled",
true);
if (m_frmTherm != null)
{
frmMain.g_oDelegate.ExecuteControlMethod((System.Windows.Forms.Form)m_frmTherm, "Close");
frmMain.g_oDelegate.ExecuteControlMethod((System.Windows.Forms.Form)m_frmTherm, "Dispose");
m_frmTherm = null;
}
}
catch
{
}
}
private void StartTherm(string p_strNumberOfTherms, string p_strTitle)
{
m_frmTherm = new frmTherm((frmDialog)ParentForm, p_strTitle);
m_frmTherm.Text = p_strTitle;
m_frmTherm.lblMsg.Text = "";
m_frmTherm.lblMsg2.Text = "";
m_frmTherm.Visible = false;
m_frmTherm.btnCancel.Visible = false;
m_frmTherm.btnCancel.Enabled = false;
m_frmTherm.lblMsg.Visible = true;
m_frmTherm.progressBar1.Minimum = 0;
m_frmTherm.progressBar1.Visible = true;
m_frmTherm.progressBar1.Maximum = 10;
if (p_strNumberOfTherms == "2")
{
m_frmTherm.progressBar2.Size = m_frmTherm.progressBar1.Size;
m_frmTherm.progressBar2.Left = m_frmTherm.progressBar1.Left;
m_frmTherm.progressBar2.Top =
Convert.ToInt32(m_frmTherm.progressBar1.Top + (m_frmTherm.progressBar1.Height * 3));
m_frmTherm.lblMsg2.Top =
m_frmTherm.progressBar2.Top + m_frmTherm.progressBar2.Height + 5;
m_frmTherm.Height = m_frmTherm.lblMsg2.Top + m_frmTherm.lblMsg2.Height +
m_frmTherm.btnCancel.Height + 50;
m_frmTherm.btnCancel.Top =
m_frmTherm.ClientSize.Height - m_frmTherm.btnCancel.Height - 5;
m_frmTherm.lblMsg2.Show();
m_frmTherm.progressBar2.Visible = true;
}
m_frmTherm.AbortProcess = false;
m_frmTherm.Refresh();
m_frmTherm.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
((frmDialog)ParentForm).Enabled = false;
m_frmTherm.Visible = true;
}
public void create_travel_times()
{
int intRandomNumber;
string strRandomNumber;
string strRandomSave;
string strMDBFile;
string strConn;
string strSQL;
//string strPsiteRailTravel_YN="N";
int x;
int y;
System.Data.OleDb.OleDbConnection p_conn;
p_conn = new System.Data.OleDb.OleDbConnection();
ado_data_access p_ado = new ado_data_access();
utils p_utils = new utils();
strMDBFile = this.m_frmMain.frmProject.uc_project1.txtRootDirectory.Text + "\\gis\\db\\gis_travel_times.mdb";
strConn = p_ado.getMDBConnString(strMDBFile, "admin", "");
p_ado.OpenConnection(strConn, ref p_conn);
p_ado.SqlNonQuery(p_conn, "delete from travel_time");
if (p_ado.m_intError == 0)
{
p_ado.CreateDataSet(p_conn, "select * from plot", "plot");
if (p_ado.m_intError == 0)
{
p_ado.AddSQLQueryToDataSet(p_conn, ref p_ado.m_OleDbDataAdapter, ref p_ado.m_DataSet, "select * from processing_site where ucase(name) like 'TEST%'", "processing_site");
if (p_ado.m_intError == 0)
{
this.m_frmTherm = new frmTherm();
this.m_frmTherm.AbortProcess = false;
this.m_frmTherm.progressBar1.Minimum = 1;
this.m_frmTherm.progressBar1.Maximum =
p_ado.m_DataSet.Tables["plot"].Rows.Count;
m_frmTherm.btnCancel.Visible = true;
m_frmTherm.Show();
m_frmTherm.Focus();
m_frmTherm.Text = "Generating Random Travel Times";
m_frmTherm.Refresh();
this.m_frmTherm.btnCancel.Click += new System.EventHandler(this.ThermCancel);
for (x = 0; x <= p_ado.m_DataSet.Tables["plot"].Rows.Count - 1; x++)
{
this.m_frmTherm.Increment(x + 1);
strRandomSave = "";
for (y = 0; y <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; y++)
{
for (;;)
{
intRandomNumber = p_utils.RandomNumber(1, 18);
strRandomNumber = Convert.ToString(intRandomNumber);
intRandomNumber = p_utils.RandomNumber(0, 9);
strRandomNumber += "." + Convert.ToString(intRandomNumber);
intRandomNumber = p_utils.RandomNumber(0, 9);
strRandomNumber += Convert.ToString(intRandomNumber);
if (strRandomNumber != strRandomSave)
{
strRandomSave = strRandomNumber;
break;
}
}
strSQL = "insert into travel_time (psite_id,biosum_plot_id,travel_mode,travel_time) VALUES ";
strSQL += "(" + p_ado.m_DataSet.Tables["processing_site"].Rows[y]["psite_id"].ToString()
+ ",'" + p_ado.m_DataSet.Tables["plot"].Rows[x]["biosum_plot_id"].ToString()
+ "',1" +
"," + strRandomNumber + ");";
p_ado.SqlNonQuery(p_conn, strSQL);
}
System.Windows.Forms.Application.DoEvents();
if (this.m_frmTherm.AbortProcess == true)
{
break;
}
}
int intStart = 1;
this.m_frmTherm.progressBar1.Maximum =
p_ado.m_DataSet.Tables["processing_site"].Rows.Count;
strRandomSave = "";
for (x = 0; x <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; x++)
{
this.m_frmTherm.Increment(x + 1);
for (y = intStart; y <= p_ado.m_DataSet.Tables["processing_site"].Rows.Count - 1; y++)
{
strSQL = "";
if (p_ado.m_DataSet.Tables["processing_site"].Rows[y]["trancd"].ToString().Trim() == "2")
{
strSQL = "insert into travel_time (psite_id,railhead_id,travel_mode,travel_time) values ";
}
else if (p_ado.m_DataSet.Tables["processing_site"].Rows[y]["trancd"].ToString().Trim() == "3")
{
strSQL = "insert into travel_time (psite_id,collector_id,travel_mode,travel_time) values ";
}
if (strSQL.Trim().Length > 0)
{
for (;;)
{
intRandomNumber = p_utils.RandomNumber(1, 18);
strRandomNumber = Convert.ToString(intRandomNumber);
intRandomNumber = p_utils.RandomNumber(0, 9);
strRandomNumber += "." + Convert.ToString(intRandomNumber);
intRandomNumber = p_utils.RandomNumber(0, 9);
strRandomNumber += Convert.ToString(intRandomNumber);
if (strRandomNumber != strRandomSave)
{
strRandomSave = strRandomNumber;
break;
}
}
strSQL += "(" + p_ado.m_DataSet.Tables["processing_site"].Rows[x]["psite_id"].ToString()
+ "," + p_ado.m_DataSet.Tables["processing_site"].Rows[y]["psite_id"].ToString()
+ ",2" +
"," + strRandomNumber + ");";
p_ado.SqlNonQuery(p_conn, strSQL);
if (p_ado.m_intError != 0)
{
break;
}
}
}
if (p_ado.m_intError != 0)
{
break;
}
intStart++;
System.Windows.Forms.Application.DoEvents();
if (this.m_frmTherm.AbortProcess == true)
{
break;
}
}
if (p_ado.m_intError != 0)
{
}
else
{
MessageBox.Show("Finished Generating Travel Times");
}
this.m_frmTherm.Close();
this.m_frmTherm = null;
}
p_ado.m_DataSet.Clear();
p_ado.m_DataSet = null;
p_ado.m_OleDbDataAdapter.Dispose();
p_ado.m_OleDbDataAdapter = null;
p_conn.Close();
p_ado.m_OleDbConnection = null;
}
}
p_conn = null;
p_ado = null;
p_utils = null;
}
