void _initially()
{
// Connect to DB_Server and Load Content...
// System.Threading.Thread th = new System.Threading.Thread(db._verify_db_exists);
// th.Start();
db._verify_db_exists();
if (db.n == "Application Connected to server . . .\nEstablished . . . . .")
{
// tim.Enabled = true;
}
else
{
txt_status.AppendText(db.n);
}
db._load_db();
if (db.m == "\nRecords Loaded, ready ...")
{
txt_status.AppendText(db.m);
lbl_progress.Content = "99%";
MainWindow mw = new MainWindow();
mw.InitializeComponent();
mw.Show();
this.Close();
GC.Collect(); // collect the garbage after the deletion
}
else
{
txt_status.AppendText(db.m + "\nClick on Application Image to reload !");
}
}
public MainWindow()
{
InitializeComponent();
if (Directory.Exists(System.Windows.Forms.Application.StartupPath + "\\temp_data") == true)
{
// Program Temporary folder exists, so we continue execution...
}
else
{
// create a new Temporary Folder for the Program...
Directory.CreateDirectory(System.Windows.Forms.Application.StartupPath + "\\temp_data");
}
// Make sure these license keys are given to avoid any SDK_RELATED error...
this.dynamicDotNetTwain1.LicenseKeys = "3A81B0A193CC694A58736359BAFC2C9C;3A81B0A193CC694A10ABD9F01B81D5DA;3A81B0A193CC694A68D5E9CCC589BDC1;3A81B0A193CC694A85288E31666B404C;3A81B0A193CC694A20B242EC8D2D91B6;3A81B0A193CC694ABDC1C217C3B432EE";
this.dynamicDotNetTwain1.SupportedDeviceType = EnumSupportedDeviceType.SDT_WEBCAM;
this.dynamicDotNetTwain1.IfShowUI = true;
// Set the control for previewing input from camera...
dynamicDotNetTwain1.SetVideoContainer(inmate_image);
// Timer to handle our Time/Date updates...
Timer t = new Timer();
t.Interval = 100;
t.Tick += t_Tick;
t.Start();
panel_enroll.Margin = new Thickness(10, 10, 0, 0);
panel_enroll.Height = 639;
panel_enroll.Width = 1056;
panel_enroll.Visibility = System.Windows.Visibility.Visible;
panel_check_out.Visibility = System.Windows.Visibility.Hidden;
panel_statistics.Visibility = System.Windows.Visibility.Hidden;
// panel_enroll.Visibility = System.Windows.Visibility.Hidden;
// panel_enroll.Visibility = System.Windows.Visibility.Hidden;
// Load States from our Enumaeration
foreach (Enum i in Enum.GetValues(typeof(States.stats)))
{
cbostate.Items.Add(i);
}
// Connect to DB_Server and Load Content...
_my_sql_db db = new _my_sql_db();
db._verify_db_exists();
db._load_db();
//System.Threading.Thread th = new System.Threading.Thread(db._verify_db_exists);
//th.Start();
//db._load_db();
}
/// <summary>
/// Handles our convict registration via the _reg_convict function in _my_sql_db.cs
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
void enroller(object sender, RoutedEventArgs args)
{
if (txt_prison_name.Text != null && txt_con_name.Text != null)
{
_my_sql_db db = new _my_sql_db();
id_gen io = new id_gen();
_app_brain ap = new _app_brain();
System.Drawing.Image _i = System.Drawing.Image.FromFile(System.Windows.Forms.Application.StartupPath + "\\temp_data\\in_use.jpg");
db._verify_db_exists();
db.id = io._trial().ToString();
db.convict_name = txt_con_name.Text;
db.dob = txt_dob.Text;
db.home_address = txt_home_add.Text;
db.city = txt_city.Text;
db.mobile = txt_mobile.Text;
db.gender = cbo_gender.Text;
db.marital = cbo_marital.Text;
db.state = cbostate.Text;
db.lga = cbolga.Text;
db.home_town = txt_hometown.Text;
db.template = "0000SJIDDIAADHFSJKK99793FUU";
db.findex = "4";
db.picture = ap._to_string(_i);
db.crime_type = txt_crime_type.Text;
db.date_of_crime = txt_date_of_crime.Text;
db.crime_location = txt_crime_loca.Text;
db.prison_name = txt_prison_name.Text;
db.prison_number = txt_prison_number.Text;
db.jail_term = txt_jail_term.Text;
db.crime_details = txt_details.Text;
db.next_of_kin_name = txt_next_kin_name.Text;
db.kin_phone = txt_kin_phone.Text;
db.relationship = txt_relationship.Text;
db.kin_address = txt_kin_address.Text;
bool v = db._reg_convict();
if (v == true)
{
//System.Windows.MessageBox.Show("Convict successfully added !!!", "Enroll Convict");
pop_up pop = new pop_up();
pop.lbl_title.Content = "Enroll Convict";
pop.lbl_msg.Text = "\nCoonvict successfully added !!!";
pop.ShowDialog();
txt_con_name.Text = ""; txt_dob.Text = ""; txt_home_add.Text = ""; txt_city.Text = "";
txt_mobile.Text = ""; cbo_gender.SelectedIndex = -1; cbo_marital.SelectedIndex = -1;
txt_relationship.SelectedIndex = -1; cbolga.SelectedIndex = -1;
cbostate.SelectedIndex = -1; cbolga.SelectedIndex = -1; txt_hometown.Text = "";
inmate_image.Source = null; inmate_bio.Source = null; txt_crime_type.Text = "";
txt_date_of_crime.Text = ""; txt_crime_loca.Text = ""; txt_prison_name.Text = "";
txt_prison_number.Text = ""; txt_jail_term.Text = ""; txt_details.Text = "";
txt_next_kin_name.Text = ""; txt_kin_phone.Text = ""; txt_relationship.Text = "";
txt_kin_address.Text = "";
//clear fields
}
else
{ //do nothing for now, coz there was an error
}
db._load_db();
}
else
{
System.Windows.Forms.MessageBox.Show("Please fill in the blanks ...", "Error");
}
}
