private void AddResidentBtn_Click(object sender, EventArgs e)
{
var form = new CreateResidentForm();
var result = form.ShowDialog();
var ssn = form.SSN;
if (result == DialogResult.OK)
{
try
{
Resident.AddResident(ssn, form.ResidentName, form.StartDate, form.EndDate, dataWrapper);
}
catch (Exception ex)
{
MessageBox.Show("An error occurred when adding a resident:\n\n" + ex.Message);
}
InitUI();
ResidentListBox.SelectedItem = ssn.ToString();
}
}
private void Save_Button(object sender, RoutedEventArgs e)
{
string lastname = v_lastname.Text;
string firstname = v_firstname.Text;
string middlename = v_middlename.Text;
string gender = v_gender.Text;
string birthdate = v_birthdate.Text;
string birthplace = v_birthplace.Text;
string civil = v_civilstatus.Text;
string address = v_homeaddress.Text;
string mobile = v_mobilenumber.Text;
string image = ImageStr;
var btnStr = ResidentButton.Content as string;
if (btnStr.Contains("Update"))
{
var updateInfo = $"UPDATE bds.residentinfo SET lastname = '{lastname}'," +
$"firstname = '{firstname}', middlename = '{middlename}', gender = '{gender}'," +
$"birthdate = '{birthdate}',birthplace = '{birthplace}',civilstatus = '{civil}',houseaddress = '{address}',mobilenumber = '{mobile}' ,image = '{image}'" +
$"WHERE id = '{ResidentId}'";
var count = DBOperation.ExecuteNonQuery(updateInfo);
if (count > 0)
{
Resident resident = new Resident()
{
ResidentId = ResidentId,
LastName = lastname,
FirstName = firstname,
MiddleName = middlename,
Gender = gender,
BirthDate = DateTime.Parse(birthdate),
BirthPlace = birthplace,
CivilStatus = civil,
HouseAddress = address,
MobileNumber = mobile,
Image = image
};
Resident.UpdateResident(ResidentId, resident);
MessageBox.Show("Updated", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
Close();
}
else
{
MessageBox.Show("Failed, Check all the fields.");
}
}
else
{
Guid guid = Guid.NewGuid();
string insertQuery = $"INSERT INTO bds.residentinfo " +
$"(id,firstname,middlename,lastname,gender,birthdate,birthplace,civilstatus,houseaddress,mobilenumber,image) VALUES " +
$"('{guid}','{firstname}','{middlename}','{lastname}','{gender}'" +
$",'{birthdate}','{birthplace}','{civil}','{address}','{mobile}','{image}')";
var count = DBOperation.ExecuteNonQuery(insertQuery);
if (count > 0)
{
Resident resident = new Resident()
{
ResidentId = guid,
LastName = lastname,
FirstName = firstname,
MiddleName = middlename,
Gender = gender,
BirthDate = v_birthdate.DisplayDate,
BirthPlace = birthplace,
CivilStatus = civil,
HouseAddress = address,
MobileNumber = mobile,
Image = image
};
Resident.AddResident(resident);
MessageBox.Show("Saved", "Info", MessageBoxButton.OK, MessageBoxImage.Information);
Close();
}
else
{
MessageBox.Show("Failed, Check all the fields.");
}
}
}
