private void sessionConfigurationToolStripMenuItem_Click(object sender, EventArgs e)
{
SessionConfig sConfig = new SessionConfig();
sConfig.cancellable = true;
sConfig.ShowDialog();
}
private void sessionConfigurationToolStripMenuItem_Click(object sender, EventArgs e)
{
SessionConfig sConfig = new SessionConfig();
sConfig.cancellable = true;
sConfig.ShowDialog();
}
void checkSessionInfo()
{
int count =0;
using (SqlConnection connection = new SqlConnection(GlobalVariables.dbConnectString))
{
try
{
connection.Open();
String query = "Select count(*) from " + Table.session_info.tableName;
using (SqlCommand command = new SqlCommand(query, connection))
{
count = (int)command.ExecuteScalar();
}
}
catch (Exception)
{
DialogResult dr = MessageBox.Show("Some Error Occurred", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dr == System.Windows.Forms.DialogResult.OK)
{
Close();
}
}
finally
{
connection.Close();
}
}
if (count != 0)
{
using (SqlConnection connection = new SqlConnection(GlobalVariables.dbConnectString))
{
try
{
connection.Open();
String query = "Select " + Table.session_info.session + " from " + Table.session_info.tableName + " where "
+ Table.session_info.active_session + " = 1";
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader dr = command.ExecuteReader();
if(dr.Read())
{
GlobalVariables.currentSession = Convert.ToInt32(dr[Table.session_info.session]);
}
dr.Close();
}
}
catch (Exception)
{
DialogResult dr = MessageBox.Show("Some Error Occurred", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dr == System.Windows.Forms.DialogResult.OK)
{
Close();
}
}
finally
{
connection.Close();
}
}
return;
}
else
{
SessionConfig sConfig = new SessionConfig();
sConfig.cancellable = false;
sConfig.ShowDialog();
if (sConfig.killParent) Close();
}
}
void checkSessionInfo()
{
int count = 0;
using (SqlConnection connection = new SqlConnection(GlobalVariables.dbConnectString))
{
try
{
connection.Open();
String query = "Select count(*) from " + Table.session_info.tableName;
using (SqlCommand command = new SqlCommand(query, connection))
{
count = (int)command.ExecuteScalar();
}
}
catch (Exception)
{
DialogResult dr = MessageBox.Show("Some Error Occurred", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dr == System.Windows.Forms.DialogResult.OK)
{
Close();
}
}
finally
{
connection.Close();
}
}
if (count == 1)
{
using (SqlConnection connection = new SqlConnection(GlobalVariables.dbConnectString))
{
try
{
connection.Open();
String query = "Select " + Table.session_info.session + " from " + Table.session_info.tableName;
using (SqlCommand command = new SqlCommand(query, connection))
{
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
GlobalVariables.currentSession = Convert.ToInt32(dr[Table.session_info.session]);
}
dr.Close();
}
}
catch (Exception)
{
DialogResult dr = MessageBox.Show("Some Error Occurred", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (dr == System.Windows.Forms.DialogResult.OK)
{
Close();
}
}
finally
{
connection.Close();
}
}
return;
}
else
{
SessionConfig sConfig = new SessionConfig();
sConfig.cancellable = false;
sConfig.ShowDialog();
if (sConfig.killParent)
{
Close();
}
}
}