public void DeleteInvitee(Invitee newInvitee) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"DELETE FROM events_invitees WHERE events_id = (@eventId) AND invitees_id = (@inviteeId);"; MySqlParameter inviteeIdParameter = new MySqlParameter(); inviteeIdParameter.ParameterName = "@inviteeId"; inviteeIdParameter.Value = newInvitee.GetId(); cmd.Parameters.Add(inviteeIdParameter); MySqlParameter eventIdParameter = new MySqlParameter(); eventIdParameter.ParameterName = "@eventId"; eventIdParameter.Value = this._id; cmd.Parameters.Add(eventIdParameter); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public void AddInvitee(Invitee newInvitee) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO events_invitees (events_id, invitees_id) VALUES (@eventId, @inviteeId);"; MySqlParameter inviteeIdParameter = new MySqlParameter(); inviteeIdParameter.ParameterName = "@inviteeId"; inviteeIdParameter.Value = newInvitee.GetId(); cmd.Parameters.Add(inviteeIdParameter); MySqlParameter eventIdParameter = new MySqlParameter(); eventIdParameter.ParameterName = "@eventId"; eventIdParameter.Value = this._id; cmd.Parameters.Add(eventIdParameter); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public List <Invitee> GetInvitees() { List <Invitee> allEventInvitees = new List <Invitee> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM invitees WHERE id IN (SELECT invitees_id FROM events_invitees WHERE events_id = @eventId);"; MySqlParameter eventId = new MySqlParameter(); eventId.ParameterName = "@eventId"; eventId.Value = this._id; cmd.Parameters.Add(eventId); var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int inviteeId = rdr.GetInt32(0); string inviteeName = rdr.GetString(1); string inviteeEmailAddress = rdr.GetString(2); Invitee newInvitee = new Invitee(inviteeName, inviteeEmailAddress, inviteeId); allEventInvitees.Add(newInvitee); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allEventInvitees); }
public static List <Invitee> GetAll() { List <Invitee> allInvitees = new List <Invitee> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM invitees;"; var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int inviteeId = rdr.GetInt32(0); string inviteeName = rdr.GetString(1); string inviteeEmailAddress = rdr.GetString(2); Invitee newInvitee = new Invitee(inviteeName, inviteeEmailAddress, inviteeId); allInvitees.Add(newInvitee); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allInvitees); }
public static Invitee Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM invitees WHERE id = (@searchId);"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterName = "@searchId"; searchId.Value = id; cmd.Parameters.Add(searchId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int inviteeId = 0; string inviteeName = ""; string inviteeEmailAddress = ""; while (rdr.Read()) { inviteeId = rdr.GetInt32(0); inviteeName = rdr.GetString(1); inviteeEmailAddress = rdr.GetString(2); } Invitee newInvitee = new Invitee(inviteeName, inviteeEmailAddress, inviteeId); conn.Close(); if (conn != null) { conn.Dispose(); } return(newInvitee); }
public override bool Equals(System.Object otherInvitee) { if (!(otherInvitee is Invitee)) { return(false); } else { Invitee newInvitee = (Invitee)otherInvitee; bool idEquality = this.GetId().Equals(newInvitee.GetId()); bool inviteeNameEquality = this.GetInviteeName().Equals(newInvitee.GetInviteeName()); bool inviteeEmailAddressEquality = this.GetInviteeEmailAddress().Equals(newInvitee.GetInviteeEmailAddress()); return(idEquality && inviteeNameEquality && inviteeEmailAddressEquality); } }