public bail(int id) { SqlDbConnection con = new SqlDbConnection(); con.Adaptor("select * from bail where id=" + id.ToString()); DataTable dt = con.Fill(); this.id = dt.Rows[0].Field <int>("id"); this.inmatename = dt.Rows[0].Field <String>("inmatename"); this.inmatenum = dt.Rows[0].Field <String>("inmatenumber"); this.offense = dt.Rows[0].Field <String>("offense"); this.cases = dt.Rows[0].Field <String>("cases"); this.datebailed = dt.Rows[0].Field <String>("datebailed"); this.bond = dt.Rows[0].Field <String>("bond"); this.court = dt.Rows[0].Field <String>("court"); this.approved = dt.Rows[0].Field <String>("approved"); }
private void Button_Click_1(object sender, RoutedEventArgs e) { string query = "select * from jailofficer where lastname = '" + lastname.Text.ToString() + "'"; SqlCommand coms = new SqlCommand(query, con); SqlDbConnection cons = new SqlDbConnection(); cons.Adaptor(query); DataTable dt = cons.Fill(); con.Open(); SqlDataReader reads = coms.ExecuteReader(); while (reads.Read()) { string fn = (reads["firstname"].ToString()); string ln = (reads["lastname"].ToString()); string mn = (reads["middlename"].ToString()); string p = (reads["position"].ToString()); if (firstname.Text != fn && lastname.Text != ln && middlename.Text != mn && position.Text != p) { if (position.Text != "" && lastname.Text != "" && firstname.Text != "" && address0.Text != "" && address1.Text != "" && birthdate.Text != "" && age.Text != "" && username.Text != "" && password.Password != "") { MD5 md5Hash = MD5.Create(); // Create a new instance of the MD5CryptoServiceProvider object. MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider(); // Convert the input string to a byte array and compute the hash. byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(password.Password)); // Create a new Stringbuilder to collect the bytes // and create a string. StringBuilder sBuilder = new StringBuilder(); // Loop through each byte of the hashed data // and format each one as a hexadecimal string. for (int i = 0; i < data.Length; i++) { sBuilder.Append(data[i].ToString("x2")); } string address = address0.Text.ToString() + " " + address1.Text.ToString(); string cmnd = "insert into jailofficer values('" + position.Text.ToString() + "', '" + lastname.Text.ToString() + "', '" + firstname.Text.ToString() + "',' " + middlename.Text.ToString() + "',"; cmnd += " '" + address.ToString() + "','" + birthdate.Text.ToString() + "','" + age.Text.ToString() + "','" + username.Text.ToString() + "','" + password.Password.ToString() + "','" + "" + "','" + "" + "','" + "" + "','" + "" + "')"; con.Open(); SqlCommand command = con.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = cmnd; command.ExecuteNonQuery(); con.Close(); this.Close(); position.Text = ""; lastname.Text = ""; firstname.Text = ""; middlename.Text = ""; address0.Text = ""; address1.Text = ""; birthdate.Text = ""; age.Text = ""; username.Text = ""; password.Password = ""; xpassword.Password = ""; registers.IsEnabled = false; MessageBox.Show("Congratulations, You have an Account!"); } else { MessageBox.Show("INVALID INPUTS!"); } } else { MessageBox.Show("THIS VISITOR IS ALREADY IN THE DATABASE"); position.Text = ""; lastname.Text = ""; firstname.Text = ""; middlename.Text = ""; address0.Text = ""; address1.Text = ""; birthdate.Text = ""; age.Text = ""; username.Text = ""; password.Password = ""; xpassword.Password = ""; registers.IsEnabled = false; } } reads.Close(); con.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(); } }