public override bool Equals(object obj)
{
if (obj == null)
{
return(false);
}
EmergencyContact ec = obj as EmergencyContact;
return((ec.RegionCode + " " + ec.ContactNumber) == (RegionCode + " " + ContactNumber));
}
public bool UpdateEmergencyContact(EmergencyContact ec)
{
MySqlConnection conn = null;
try
{
}
catch (MySqlException ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace.ToString());
}
finally
{
if (conn != null && conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
}
return(false);
}
public bool AddEmergencyContact(EmergencyContact emergencyContact)
{
MySqlConnection conn = null;
try
{
conn = ConnectionManager.GetConnection();
MySqlCommand cmd = new MySqlCommand(SET_EMERGENCY_CONTACT, conn);
cmd.Parameters.AddWithValue("@name", emergencyContact.LocationName);
cmd.Parameters.AddWithValue("@region_code", emergencyContact.RegionCode);
cmd.Parameters.AddWithValue("@num", emergencyContact.ContactNumber);
cmd.Parameters.AddWithValue("@lat", emergencyContact.Lat);
cmd.Parameters.AddWithValue("@longi", emergencyContact.Longi);
cmd.Parameters.AddWithValue("@desc", emergencyContact.Desc);
int numOfRows = cmd.ExecuteNonQuery();
if (numOfRows == 1)
{
return(true);
}
}
catch (MySqlException ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace.ToString());
}
finally
{
if (conn != null && conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
}
return(false);
}
