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