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(); }
//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(); }
private void restore_Click(object sender, RoutedEventArgs e) { string ident = p.id.Text; DataGrid dataGrid = datagrid_archive; DataGridRow Row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex); DataGridCell RowAndColumn = (DataGridCell)dataGrid.Columns[0].GetCellContent(Row).Parent; ((TextBlock)RowAndColumn.Content).Text = ident; con.Open(); SqlCommand command = con.CreateCommand(); command.CommandType = CommandType.Text; restore res = new restore(); res.firstname = p.firstname.Text.ToString(); res.middlename = p.middlename.Text.ToString(); res.lastname = p.lastname.Text.ToString(); res.address = p.address.Text.ToString(); res.age = p.age.Text.ToString(); res.gender = p.gender.Text.ToString(); res.birthdate = p.birthdate.DisplayDate.ToString("yyyy-MM-dd"); res.height = p.height.Text.ToString(); res.weight = p.weight.Text.ToString(); res.citizenship = p.citizenship.Text.ToString(); res.religion = p.religion.Text.ToString(); res.datein = p.datein.DisplayDate.ToString("yyyy-MM-dd"); res.civilstatus = p.civilstatus.Text.ToString(); res.jailstatus = p.jailstatus.Text.ToString(); res.add(); command.CommandText = "delete from archive_prisoner where id = '" + ident + "'"; command.ExecuteNonQuery(); con.Close(); MessageBox.Show("Successfully Deleted!"); this.Close(); 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(); } }