private void locationToolStripMenuItem_Click(object sender, EventArgs e)
{
Location_setting_Form frm = new Location_setting_Form();
frm.MdiParent = this;
frm.Show();
}
private void Parent_Form_Load(object sender, EventArgs e)
{
try
{
if (!File.Exists(@"..\loc.txt"))
{
File.Create(@"..\loc.txt");
SqlHelper.Global_Location_String = File.ReadAllText(@"..\loc.txt");
}
else if (File.Exists(@"..\loc.txt"))
{
SqlHelper.Global_Location_String = File.ReadAllText(@"..\loc.txt");
}
if (!File.Exists(@"..\constr.txt"))
{
File.Create(@"..\constr.txt");
SqlHelper.Global_Connection_String = File.ReadAllText(@"..\constr.txt");
}
else if (File.Exists(@"..\constr.txt"))
{
SqlHelper.Global_Connection_String = File.ReadAllText(@"..\constr.txt");
}
if (SqlHelper.Global_Connection_String == "")
{
Connection__String_from frm = new Connection__String_from();
frm.MdiParent = this;
frm.Show();
groupBox1.Hide();
}
if (SqlHelper.Global_Location_String == "")
{
Location_setting_Form frm = new Location_setting_Form();
frm.MdiParent = this;
frm.Show();
groupBox1.Hide();
}
entryToolStripMenuItem.Visible = false;
reportsToolStripMenuItem.Visible = false;
adminControlsToolStripMenuItem.Visible = false;
if (SqlHelper.Global_Connection_String != "")
{
try
{
SqlHelper helper = new SqlHelper(SqlHelper.Global_Connection_String);
if (helper.IsConnect)
{
con = new SqlConnection(SqlHelper.Global_Connection_String);
AppSettings setting = new AppSettings();
setting.saveConnectionString("ConnectionString", SqlHelper.Global_Connection_String);
var DS1 = new Vehical_Entry_RecordDataSetTableAdapters.Report_QueryTableAdapter();
DS1.Connection.ConnectionString = SqlHelper.Global_Connection_String;
SqlCommand cmd = new SqlCommand("Count_Vehical", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dty = new DataTable();
da.Fill(dty);
label6.Text = dty.Rows.Count.ToString();
}
else
{
Connection__String_from frm = new Connection__String_from();
frm.MdiParent = this;
frm.Show();
groupBox1.Hide();
}
}
catch (Exception ex)
{
groupBox1.Hide();
MessageBox.Show("Connection Error");
MessageBox.Show(ex.Message);
}
}
}
catch (Exception)
{
groupBox1.Hide();
MessageBox.Show("Software Updated Its Environment On New PC. Please Restart Again");
}
}