public void Remove()
{
SQLiteDatabase sqlDatabase = null;
try
{
Globals dbHelp = new Globals();
dbHelp.OpenDatabase();
sqlDatabase = dbHelp.GetSQLiteDatabase();
if (sqlDatabase != null && sqlDatabase.IsOpen)
{
var sql = "DELETE FROM [Health] WHERE HealthID = " + HealthID.ToString();
sqlDatabase.ExecSQL(sql);
Log.Info(TAG, "Remove: Removed Health with ID " + HealthID.ToString() + " successfully");
sqlDatabase.Close();
}
Log.Error(TAG, "Remove: SQLite database is null or was not opened - remove failed");
}
catch (Exception e)
{
Log.Error(TAG, "Remove: Exception - " + e.Message);
if (sqlDatabase != null && sqlDatabase.IsOpen)
{
sqlDatabase.Close();
}
}
}
private void HealthID_Changed(object sender, TextChangedEventArgs e)
{
if (!IsHealthcareIDValid())
{
HealthID.MarkInvalid();
MessageBox.Show("A patient with this Healthcare ID: " + HealthID.TextField.Text + " already exists!", "Invalid Healthcare ID", MessageBoxButton.OK, MessageBoxImage.Exclamation);
HealthID.TextField.Text = "";
HealthID.TextField.Focus();
}
else
{
HealthID.MarkValid();
}
}
/// <summary>
/// Marks invalid/valid feilds by calling their Mark(In)Valid functions
/// returns true if all fields contain valid data, false otherwise.
/// </summary>
/// <returns></returns>
private bool ValidateFields()
{
bool allValid = true;
if (FirstName.TextField.Text == FirstName.Hint)
{
FirstName.MarkInvalid();
allValid = false;
}
else
{
FirstName.MarkValid();
}
if (LastName.TextField.Text == LastName.Hint)
{
LastName.MarkInvalid();
allValid = false;
}
else
{
LastName.MarkValid();
}
if (!IsHealthcareIDValid() || HealthID.TextField.Text == HealthID.Hint)
{
HealthID.MarkInvalid();
allValid = false;
}
else
{
HealthID.MarkValid();
}
if (!Birthdate.DateSelected.HasValue)
{
Birthdate.InputText.MarkInvalid();
allValid = false;
}
else
{
Birthdate.InputText.MarkValid();
}
if (Address.TextField.Text == Address.Hint)
{
Address.MarkInvalid();
allValid = false;
}
else
{
Address.MarkValid();
}
if (City.TextField.Text == City.Hint)
{
City.MarkInvalid();
allValid = false;
}
else
{
City.MarkValid();
}
if (!IsPostalCodeValid())
{
PostalCode.MarkInvalid();
allValid = false;
}
else
{
PostalCode.MarkValid();
}
if (!IsPhoneNumberValid(HomePhone))
{
HomePhone.MarkInvalid();
allValid = false;
}
else
{
HomePhone.MarkValid();
}
//Optional Business Phone, if it is filled in, ensure it is at least a 10 digit number
if (BusinessPhone.TextField.Text != BusinessPhone.Hint && BusinessPhone.TextField.Text.Length < 14)
{
BusinessPhone.MarkInvalid();
allValid = false;
}
else
{
BusinessPhone.MarkValid();
}
//Optional Cell Phone, if it is filled in, ensure it is at least a 10 digit number
if (CellPhone.TextField.Text != CellPhone.Hint && CellPhone.TextField.Text.Length < 14)
{
CellPhone.MarkInvalid();
allValid = false;
}
else
{
CellPhone.MarkValid();
}
if (ContactName.TextField.Text == ContactName.Hint)
{
ContactName.MarkInvalid();
allValid = false;
}
else
{
ContactName.MarkValid();
}
if (ContactRelation.TextField.Text == ContactRelation.Hint)
{
ContactRelation.MarkInvalid();
allValid = false;
}
else
{
ContactRelation.MarkValid();
}
if (!IsPhoneNumberValid(ContactPhone))
{
ContactPhone.MarkInvalid();
allValid = false;
}
else
{
ContactPhone.MarkValid();
}
return(allValid);
}
public void Save()
{
SQLiteDatabase sqlDatabase = null;
try
{
Globals dbHelp = new Globals();
dbHelp.OpenDatabase();
sqlDatabase = dbHelp.GetSQLiteDatabase();
if (sqlDatabase != null)
{
if (sqlDatabase.IsOpen)
{
if (IsNew)
{
ContentValues values = new ContentValues();
values.Put("Aspect", Aspect);
values.Put("Importance", Importance);
values.Put("Type", (int)Type);
values.Put("Action", (int)Action);
values.Put("ActionOf", ActionOf);
HealthID = (int)sqlDatabase.Insert("Health", null, values);
IsNew = false;
IsDirty = false;
}
if (IsDirty)
{
ContentValues values = new ContentValues();
values.Put("Aspect", Aspect);
values.Put("Importance", Importance);
values.Put("Type", (int)Type);
values.Put("Action", (int)Action);
values.Put("ActionOf", ActionOf);
string whereClause = "HealthID = ?";
sqlDatabase.Update("Health", values, whereClause, new string[] { HealthID.ToString() });
IsDirty = false;
}
sqlDatabase.Close();
}
}
}
catch (Exception e)
{
Log.Error(TAG, "Save: Exception - " + e.Message);
if (sqlDatabase != null && sqlDatabase.IsOpen)
{
sqlDatabase.Close();
}
}
}
