//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);
}
}
