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