public static List <Bartender> GetAll() { List <Bartender> allBartenders = new List <Bartender> { }; SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM bartenders ORDER BY name;", conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { int bartenderId = rdr.GetInt32(0); string bartenderName = rdr.GetString(1); Bartender newBartender = new Bartender(bartenderName, bartenderId); allBartenders.Add(newBartender); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(allBartenders); }
public override bool Equals(System.Object otherBartender) { if (!(otherBartender is Bartender)) { return(false); } else { Bartender newBartender = (Bartender)otherBartender; bool idEquality = this.GetId() == newBartender.GetId(); bool nameEquality = this.GetName() == newBartender.GetName(); return(idEquality && nameEquality); } }
public List <Bartender> GetBartender() { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT bartenders.* FROM patrons JOIN orders ON (patrons.id = orders.patrons_id) JOIN bartenders ON (orders.bartenders_id = bartenders.id) WHERE patrons.id = @PatronId;", conn); SqlParameter patronIdParameter = new SqlParameter(); patronIdParameter.ParameterName = "@PatronId"; patronIdParameter.Value = this.GetId().ToString(); cmd.Parameters.Add(patronIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); List <Bartender> bartenders = new List <Bartender> { }; while (rdr.Read()) { int bartenderId = rdr.GetInt32(0); string bartenderName = rdr.GetString(1); Bartender newBartender = new Bartender(bartenderName, bartenderId); bartenders.Add(newBartender); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(bartenders); }
public static Bartender Find(int id) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM bartenders WHERE id = @BartenderId", conn); SqlParameter bartenderIdParameter = new SqlParameter(); bartenderIdParameter.ParameterName = "@BartenderId"; bartenderIdParameter.Value = id.ToString(); cmd.Parameters.Add(bartenderIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); int foundBartenderId = 0; string foundBartenderName = null; while (rdr.Read()) { foundBartenderId = rdr.GetInt32(0); foundBartenderName = rdr.GetString(1); } Bartender foundBartender = new Bartender(foundBartenderName, foundBartenderId); if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(foundBartender); }