private void fmprisoner_b_add_Click(object sender, RoutedEventArgs e)
{
prisoner prisoner = new prisoner();
prisoner.firstname = firstname.Text.ToString();
prisoner.middlename = middlename.Text.ToString();
prisoner.lastname = lastname.Text.ToString();
prisoner.address = address.Text.ToString();
prisoner.age = age.Text.ToString();
prisoner.gender = gender.Text.ToString();
prisoner.birthdate = birthdate.DisplayDate.ToString("yyyy-MM-dd");
prisoner.height = height.Text.ToString();
prisoner.weight = weight.Text.ToString();
prisoner.citizenship = citizenship.Text.ToString();
prisoner.religion = religion.Text.ToString();
prisoner.datein = datein.DisplayDate.ToString("yyyy-MM-dd");
prisoner.civilstatus = civilstatus.Text.ToString();
prisoner.jailstatus = jailstatus.Text.ToString();
prisoner.add();
this.Close();
prisonermain pm = new prisonermain();
//pm.Close();
pm.Show();
loading l = new loading();
l.Show();
MessageBox.Show("Successfully inserted!");
}
private void fmprisoner_b_cancel_Click(object sender, RoutedEventArgs e)
{
this.Close();
prisonermain pm = new prisonermain();
loading l = new loading();
l.Show();
pm.Show();
}
//DELETE BUTTON
private void Button_Click_1(object sender, RoutedEventArgs e)
{
DataGrid dataGrid = datagrid_prisoner;
DataGridRow Row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex);
DataGridCell RowAndColumn = (DataGridCell)dataGrid.Columns[0].GetCellContent(Row).Parent;
((TextBlock)RowAndColumn.Content).Text = id.Text;
con.Open();
SqlCommand command = con.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "delete from prisoner where id = '" + id.Text + "'";
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successfully Deleted!");
edit.Visibility = Visibility.Hidden;
datagrid_prisoner.Visibility = Visibility.Visible;
//audittrail
//dashboard d = new dashboard();
//audittrail au = new audittrail();
//au.users = d.username.Text.ToString();
//au.activity = "deleted prisoner information";
//au.dateOfActivity = DateTime.Now.ToString();
//au.timeOfActivity = DateTime.Now.ToString("G");
//au.add();
parchive ar = new parchive();
ar.firstname = firstname.Text.ToString();
ar.middlename = middlename.Text.ToString();
ar.lastname = lastname.Text.ToString();
ar.address = address.Text.ToString();
ar.age = age.Text.ToString();
ar.gender = gender.Text.ToString();
ar.birthdate = birthdate.DisplayDate.ToString("yyyy-MM-dd");
ar.height = height.Text.ToString();
ar.weight = weight.Text.ToString();
ar.citizenship = citizenship.Text.ToString();
ar.religion = religion.Text.ToString();
ar.datein = datein.DisplayDate.ToString("yyyy-MM-dd");
ar.civilstatus = civilstatus.Text.ToString();
ar.jailstatus = jailstatus.Text.ToString();
ar.add();
this.Close();
prisonermain pm = new prisonermain();
pm.Show();
loading l = new loading();
l.Show();
}
//SELECT ROW AND VISIBILITY OF DELETE BUTTON
private void datagrid_case_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
prisonermain pms = new prisonermain();
DataGrid gd = (DataGrid)sender;
DataRowView row_selected = gd.SelectedItem as DataRowView;
if (row_selected != null)
{
pms.id.Text = row_selected["id"].ToString();
}
}
//EDIT-CANCELBUTTON
private void add_cancel_prisoner_Click(object sender, RoutedEventArgs e)
{
edit.Visibility = Visibility.Hidden;
datagrid_prisoner.Visibility = Visibility.Visible;
prisoner p = new prisoner();
p.refreshTB_prisoner();
this.Close();
prisonermain pm = new prisonermain();
pm.Show();
loading l = new loading();
l.Show();
}
//UPDATE PRISONER
private void update_prisoner_Click(object sender, RoutedEventArgs e)
{
try
{
DataGrid dataGrid = datagrid_prisoner;
DataGridRow Row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex);
DataGridCell RowAndColumn = (DataGridCell)dataGrid.Columns[0].GetCellContent(Row).Parent;
((TextBlock)RowAndColumn.Content).Text = id.Text;
con.Open();
SqlCommand command = con.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "update prisoner set lastname='" + lastname.Text.ToString() + "', firstname= '" + firstname.Text.ToString() + "', middlename = '" + middlename.Text.ToString() + "', address = '" + address.Text.ToString() + "', age = '" + age.Text.ToString() + "', gender = '" + gender.Text.ToString() + "', birthdate = '" + birthdate.DisplayDate.ToString("yyyy-MM-dd") + "', height = '" + height.Text.ToString() + "', weight = '" + weight.Text.ToString() + "', citizenship= '" + citizenship.Text.ToString() + "', religion= '" + religion.Text.ToString() + "', datein= '" + datein.Text.ToString() + "', civilstatus = '" + civilstatus.Text.ToString() + "', jailstatus = '" + jailstatus.Text.ToString() + "' where id = '" + id.Text + "'";
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successfully Updated!");
edit.Visibility = Visibility.Hidden;
datagrid_prisoner.Visibility = Visibility.Visible;
MainWindow d = new MainWindow();
audittrail au = new audittrail();
string user = d.id_login.Text.ToString();
au.users = user;
au.activity = "update prisoner information";
au.dateOfActivity = DateTime.Now.ToString();
au.timeOfActivity = DateTime.Now.ToString("G");
au.add();
this.Close();
prisonermain pm = new prisonermain();
pm.Show();
loading l = new loading();
l.Show();
}
catch
{
MessageBox.Show("Invalid Inputs");
}
}
private void train_detect_Click(object sender, RoutedEventArgs e)
{
SqlConnection cons = new SqlConnection(@"Data Source=DESKTOP-RVI30EH\SQLEXPRESS;Initial Catalog=jms;Integrated Security=True");
string query = "select * from " + type;
SqlCommand coms = new SqlCommand(query, cons);
SqlDbConnection con = new SqlDbConnection();
cons.Open();
//getting sql data from case registration prisoner to prisoner main
SqlDataReader read = coms.ExecuteReader();
string firstname;
while (read.Read())
{
if (read["firstname"].ToString() == face_persons.Text.ToString())
{
firstname = read["firstname"].ToString();
string identifier = read["id"].ToString();
frame_active = false;
MessageBox.Show("A face is detected");
this.Close();
if (type == "prisoner")
{
prisonermain pm = new prisonermain();
pm.Show();
pm.datagrid_prisoner.Visibility = Visibility.Hidden;
pm.edit.Visibility = Visibility.Visible;
pm.firstname.Text = read["firstname"].ToString();
pm.middlename.Text = read["middlename"].ToString();
pm.birthdate.Text = read["birthdate"].ToString();
pm.lastname.Text = read["lastname"].ToString();
pm.address.Text = read["address"].ToString();
pm.age.Text = read["age"].ToString();
pm.gender.Text = read["gender"].ToString();
pm.weight.Text = read["weight"].ToString();
pm.height.Text = read["height"].ToString();
pm.citizenship.Text = read["citizenship"].ToString();
pm.religion.Text = read["religion"].ToString();
pm.datein.Text = read["datein"].ToString();
pm.civilstatus.Text = read["civilstatus"].ToString();
pm.jailstatus.Text = read["jailstatus"].ToString();
}
if (type == "visitor")
{
visitormain pm = new visitormain();
pm.Show();
pm.datagrid_visitor.Visibility = Visibility.Hidden;
pm.edit_visitor.Visibility = Visibility.Visible;
pm.id.Text = read["id"].ToString();
pm.relation.Text = read["relation"].ToString();
pm.lastname.Text = read["lastname"].ToString();
pm.firstname.Text = read["firstname"].ToString();
pm.middlename.Text = read["middlename"].ToString();
pm.address0.Text = read["address"].ToString();
pm.gender.Text = read["gender"].ToString();
pm.relation.Text = read["relation"].ToString();
}
break;
}
//else
//{
// MessageBox.Show("FACE NOT FOUND ON '"+ type +"' LISTS");
//}
}
read.Close();
cons.Close();
}
//EDIT A PRISONER
private void datagrid_case_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
prisonermain pms = new prisonermain();
pms.Show();
pms.datagrid_prisoner.Visibility = Visibility.Hidden;
pms.edit.Visibility = Visibility.Visible;
pms.bail.Visibility = Visibility.Hidden;
pms.hearing_schedule.Visibility = Visibility.Hidden;
pms.cell_transfer.Visibility = Visibility.Hidden;
pms.cell_registration.Visibility = Visibility.Hidden;
pms.case_registration.Visibility = Visibility.Visible;
pms.save_case.Visibility = Visibility.Hidden;
pms.update_case.Visibility = Visibility.Visible;
DataGrid gd = (DataGrid)sender;
DataRowView row_selected = gd.SelectedItem as DataRowView;
if (row_selected != null)
{
SqlConnection cons = new SqlConnection(@"Data Source=DESKTOP-RVI30EH\SQLEXPRESS;Initial Catalog=jms;Integrated Security=True");
//pm.inmate_name.Text = row_selected["inmatename"].ToString();
pms.inmatenum.Text = row_selected["inmatenum"].ToString();
pms.casenum.Text = row_selected["casenum"].ToString();
pms.offense1.Text = row_selected["offense"].ToString();
pms.datefiled.Text = row_selected["datefiled"].ToString();
pms.datesen.Text = row_selected["datesen"].ToString();
pms.senstatus.Text = row_selected["senstatus"].ToString();
pms.senreceive.Text = row_selected["senreceive"].ToString();
pms.sendue.Text = row_selected["sendue"].ToString();
string identifier = row_selected["inmatenum"].ToString();
string query = "select * from prisoner where id = '" + identifier + "'";
SqlCommand coms = new SqlCommand(query, cons);
SqlDbConnection con = new SqlDbConnection();
con.Adaptor(query);
DataTable dt = con.Fill();
cons.Open();
//getting sql data from case registration prisoner to prisoner main
SqlDataReader read = coms.ExecuteReader();
while (read.Read())
{
pms.id.Text = (read["id"].ToString());
pms.firstname.Text = (read["firstname"].ToString());
pms.lastname.Text = (read["lastname"].ToString());
pms.birthdate.Text = (read["birthdate"].ToString());
pms.middlename.Text = (read["middlename"].ToString());
pms.address.Text = (read["address"].ToString());
pms.age.Text = (read["age"].ToString());
pms.gender.Text = (read["gender"].ToString());
pms.weight.Text = (read["weight"].ToString());
pms.height.Text = (read["height"].ToString());
pms.citizenship.Text = (read["citizenship"].ToString());
pms.religion.Text = (read["religion"].ToString());
pms.datein.Text = (read["datein"].ToString());
pms.civilstatus.Text = (read["civilstatus"].ToString());
pms.jailstatus.Text = (read["jailstatus"].ToString());
}
read.Close();
cons.Close();
}
}
