/// <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"); } }