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 update_cell_Click(object sender, RoutedEventArgs e)
{
try
{
DataGrid dataGrid = datagrid_cell;
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 cell set cell='" + cellnum.Text.ToString() + "', description= '" + description.Text.ToString() + "', num_inmates = '" + num_inmates.Text.ToString() + "', status = '" + status.Text.ToString() + "' where id = '" + id.Text + "'";
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successfully Updated!");
edit.Visibility = Visibility.Hidden;
datagrid_cell.Visibility = Visibility.Visible;
cellmain cm = new cellmain();
cm.Show();
loading l = new loading();
l.Show();
this.Close();
}
catch
{
MessageBox.Show("Invalid Inputs");
}
cellmain CM = new cellmain();
CM.Show();
this.Close();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
DataGrid dataGrid = datagrid_escort;
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 escort where id = '" + id.Text + "'";
command.ExecuteNonQuery();
con.Close();
MessageBox.Show("Successfully Deleted!");
edit.Visibility = Visibility.Hidden;
datagrid_escort.Visibility = Visibility.Visible;
this.Close();
escort es = new escort();
loading l = new loading();
l.Show();
es.Show();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
this.Close();
escort es = new escort();
loading l = new loading();
l.Show();
es.Show();
}
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_cell_Click(object sender, RoutedEventArgs e)
{
edit.Visibility = Visibility.Hidden;
datagrid_cell.Visibility = Visibility.Visible;
cell p = new cell();
cellmain cm = new cellmain();
cm.Show();
loading l = new loading();
l.Show();
this.Close();
}
//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();
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
es.lastname = lastname.Text.ToString();
es.firstname = firstname.Text.ToString();
es.position = position.Text.ToString();
es.escort = p_id.Text.ToString();
if (lastname.Text.ToString() != "" && firstname.Text.ToString() != "" && position.Text.ToString() != "" && p_id.Text.ToString() != "")
{
es.add();
MessageBox.Show("Succesfully inserted!");
this.Close();
escort escort = new escort();
escort.Show();
loading l = new loading();
l.Show();
}
else
{
MessageBox.Show("INVALID INPUTS!");
}
}
//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");
}
}
