public override bool Equals(object obj) { if (obj == null) { return(false); } AdminAlert adminAlert = obj as AdminAlert; return(adminAlert.Id.Equals(Id)); }
public bool AddAdminAlert(AdminAlert adminAlert) { MySqlConnection conn = null; try { conn = ConnectionManager.GetConnection(); MySqlCommand cmd = new MySqlCommand(INSERT_ADMIN_ALERT, conn); cmd.Parameters.AddWithValue("@id", adminAlert.Id.ToString()); cmd.Parameters.AddWithValue("@email", adminAlert.Email); cmd.Parameters.AddWithValue("@creation_date", adminAlert.CreationDate.ToString("yyyy-MM-dd HH:mm:ss.fff")); cmd.Parameters.AddWithValue("@lat", adminAlert.Lat); cmd.Parameters.AddWithValue("@longi", adminAlert.Longi); cmd.Parameters.AddWithValue("@alert", adminAlert.Alert); cmd.Parameters.AddWithValue("@parent_id", adminAlert.ParentId.ToString()); cmd.Parameters.AddWithValue("@child_id", adminAlert.ChildId.ToString()); int rowsAffected = cmd.ExecuteNonQuery(); if (rowsAffected > 1) { throw new Exception("repeated id"); } return(true); } catch (MySqlException e) { System.Diagnostics.Debug.WriteLine(e.Message.ToString()); } finally { if (conn != null && conn.State != System.Data.ConnectionState.Closed) { conn.Close(); } } return(false); }