private void list_inmates_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
_my_sql_db m = new _my_sql_db();
try
{
m._view_inmate_data(list_inmates.SelectedItem.ToString());
sel_inmate_name.Text = _cn;
sel_inmate_pri.Text = _pn;
sel_inmate_term.Text = _pno;
sel_inmate_crime.Text = _ct;
_app_brain ap = new _app_brain();
System.Drawing.Image i = ap._fun(_cp);
// sel_inmate_img.Source = (BitmapSource)i;
//MemoryStream mem = new MemoryStream();
//Byte[] buffer = Convert.FromBase64String(_cp);
//mem.Position = 0;
//mem.Write(buffer, 0, buffer.Count());
//if (mem != null)
//{
// System.Windows.Media.Imaging.BitmapImage bi = new BitmapImage();
// bi.StreamSource = mem;
// ImageSource k = (ImageSource)bi;
// sel_inmate_img.Source = k;
//}
}
//try
//{
//
// ImageSourceConverter con = new ImageSourceConverter();
// var s = con.ConvertFrom(i);
// Stream ss;
// ss.Position = 0;
// JpegBitmapDecoder d = new JpegBitmapDecoder(BitmapCreateOptions.None, BitmapCacheOption.Default);
// sel_inmate_img.Source = (ImageSource)s;
//}
//catch (Exception u)
//{
// System.Windows.Forms.MessageBox.Show("Test" + u.Message);
//}
//using (FileStream stream = new FileStream(System.Windows.Forms.Application.StartupPath + "\\temp_data\\in_use.jpg", FileMode.Create)) ;
//System.Windows.Forms.MessageBox.Show(_cp);
//db.picture = ap._to_string(_i);
//sel_inmate_img.Source = System.Windows.Forms.Application.StartupPath + "\\temp_data\\in_img.jpg";
//= (ImageSource)isc.ConvertFromString(_cp);
catch (Exception ex)
{
Console.WriteLine("ERR_AT_LST_INM_SEL_CHGD +++ \n" + ex.Message);
}
}
/// <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");
}
}