//DISPLAY VICTIMS DETAILS CONSTRUCTOR public VictimsDetailsForm(Victim victim) { this.victim = victim; InitializeComponent(); SetVictimDetails(victim); DisableControls(); }
public static Victim[] GetAllVictims() { List<Victim> victims = new List<Victim>(); try { //select sql String select_sql = "SELECT * FROM " + TABLE_NAME; sql_command = new MySqlCommand(); sql_command.Connection = (MySqlConnection)database.OpenConnection(); sql_command.CommandText = select_sql; sql_command.Prepare(); //get results in enum object data_reader = database.Select(sql_command); //loop thru em while (data_reader.Read()) { //create new student int id = data_reader.GetInt32(ID); String name = data_reader.GetString(NAME); StolenItem[] items_stolen = null; bool is_a_student = data_reader.GetBoolean(IS_A_STUDENT); String gender = data_reader.GetString(GENDER); String d_o_b = data_reader.GetString(DOB); int crime_id = data_reader.GetInt32(CRIME_ID); Victim victim = new Victim(id, name, d_o_b, items_stolen, gender, is_a_student, crime_id); //add student to list victims.Add(victim); } } catch (Exception e) { Debug.WriteLine(e.Message); } finally { CloseDatabaseConnection(); } //return array of results return victims.ToArray(); }
public static bool Update(Victim victim) { try { String update_sql = "UPDATE " + TABLE_NAME + " SET NAME=@name ,DOB=@dob,IS_A_STUDENT=@student,GENDER=@gender,CRIME_ID=@crime_id WHERE ID=@id"; //Sql command sql_command = new MySqlCommand(); sql_command.Connection = (MySqlConnection)database.OpenConnection(); sql_command.CommandText = update_sql; sql_command.Parameters.AddWithValue("@id", victim.id); sql_command.Parameters.AddWithValue("@name", victim.name); sql_command.Parameters.AddWithValue("@dob", victim.date_of_birth); sql_command.Parameters.AddWithValue("@student", victim.is_a_student); sql_command.Parameters.AddWithValue("@gender", victim.gender); sql_command.Parameters.AddWithValue("@crime_id", victim.crime_id); sql_command.Prepare(); //execute command database.Update(sql_command); return true; } catch (Exception) { return false; } finally { CloseDatabaseConnection(); } }
public static bool Save(Victim victim) { try { String insert_sql = "INSERT INTO " + TABLE_NAME + " (NAME,DATE_OF_BIRTH,IS_A_STUDENT,GENDER,CRIME_ID) VALUES(@name,@dob,@is_student,@gender,@crime_id)"; //Sql command sql_command = new MySqlCommand(); sql_command.Connection = (MySqlConnection)database.OpenConnection(); sql_command.CommandText = insert_sql; sql_command.Parameters.AddWithValue("@name", victim.name); sql_command.Parameters.AddWithValue("@dob", victim.date_of_birth); sql_command.Parameters.AddWithValue("@is_student", "" + victim.is_a_student); sql_command.Parameters.AddWithValue("@gender", victim.gender); sql_command.Parameters.AddWithValue("@crime_id", victim.crime_id); sql_command.Prepare(); database.Insert(sql_command); victim.id = Convert.ToInt32(sql_command.LastInsertedId); return true; } catch (Exception) { return false; } finally { CloseDatabaseConnection(); } }
//SETS TEXT OF CONTROLS WHEN DISPLAYING DETAILS OF VICTIMS private void SetVictimDetails(Victim victim) { if (victim == null) { throw new ArgumentNullException(); } //SET HIS PERSONAL DETAILS this.name_text_box.Text = victim.name; this.date_of_birth.Text = victim.date_of_birth; this.gender_comoboBox.Text = victim.gender; this.is_a_student_comboBox.Text = victim.is_a_student.ToString(); //SET THE ITEMS STOLEN FIELD for(int i=0;i<victim.items_stolen.Length;i++) { if (i == 0) { this.items_lost_textbox.Text += victim.items_stolen[i].name_of_item; continue; } this.items_lost_textbox.Text += "," + victim.items_stolen[i].name_of_item; } }
//SAVES THE VICTIMS DETAILS AND THE CRIMES AGAINIST HIM IN THE DATABASE private void SaveVictimDetails() { //get victim details button_save.Enabled = false; button_another_victim.Enabled = false; button_another_crime.Enabled = false; //get victim details String name = name_text_box.Text; String d_o_b = date_of_birth.Text; String gender = gender_comoboBox.Text; bool is_a_student = is_a_student_comboBox.Text.Equals("Yes") ? true : false; //save perp if (close_after_saving) { //PerpetratorsManager.Save(perpetrator); //set the perp id in the crime // crime.perpetrator_id = perpetrator.id; //save crime // CrimesManager.Save(crime); } StolenItem[] items_lost = GetItemsLost(); //create victims object victim = new Victim(name, d_o_b, items_lost, gender, is_a_student, crime.id); //save victim //VictimsManager.Save(victim); //SAVE EACH STOLEN ITEM IN THE DATABASE foreach (var item in items_lost) { //item.victims_id = victim.id; //StolenItemsManager.Save(item); } }