public void Test_Delete_DeletesStylistFromDatabase()
{
string name1 = "Rebecca";
Stylist testStylist1 = new Stylist(name1);
testStylist1.Save();
string name2 = "Tony";
Stylist testStylist2 = new Stylist(name2);
testStylist2.Save();
Client testClient1 = new Client("Sam", testStylist1.GetId());
testClient1.Save();
Client testClient2 = new Client("Beth", testStylist2.GetId());
testClient2.Save();
Console.WriteLine(Client.Find(testClient1.GetId()).GetName());
Console.WriteLine(Client.Find(testClient2.GetId()).GetName());
testStylist1.Delete();
List<Stylist> resultStylists = Stylist.GetAll();
List<Stylist> testStylistList = new List<Stylist> {testStylist2};
List<Client> resultClients = Client.GetAll();
List<Client> testClientList = new List<Client> {testClient2};
Assert.Equal(testStylistList, resultStylists);
Assert.Equal(testClientList, resultClients);
}
public void Client_Find_ReturnsClientFromDB()
{
Client newClient = new Client("Tom Smith", "(555)-123-4567", 1);
newClient.Save();
Client foundClient = Client.Find(newClient.GetId());
Assert.Equal(newClient, foundClient);
}
public void Test_Find_FindsCategoryInDatabase()
{
Client testClient = new Client("Rebecca", 1);
testClient.Save();
Client foundClient = Client.Find(testClient.GetId());
Assert.Equal(testClient, foundClient);
}
public void Test_Find_ReturnsASpecificClientObject()
{
//Arrange
Client newClient = new Client("Wendy", "blonde", 3);
newClient.Save();
//Act
Client foundClient = Client.Find(newClient.GetId());
//Assert
Assert.Equal(newClient, foundClient);
}
public override bool Equals(System.Object otherClient)
{
if (!(otherClient is Client))
{
return(false);
}
else
{
Client newClient = (Client)otherClient;
return(this.GetId() == newClient.GetId() &&
this.GetName() == newClient.GetName() &&
this.GetStylistId() == newClient.GetStylistId());
}
}
public override bool Equals(System.Object otherClient)
{
if (!(otherClient is Client))
{
return(false);
}
else
{
Client newClient = (Client)otherClient;
bool idEquality = this.GetId() == newClient.GetId();
bool nameEquality = this.GetName() == newClient.GetName();
bool stylistIdEquality = (this.GetStylistId() == newClient.GetStylistId());
return(idEquality && nameEquality && stylistIdEquality);
}
}
public void DeleteClient(Client toDelete)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM clients WHERE id = @ClientId;", conn);
SqlParameter idParam = new SqlParameter("@ClientId", toDelete.GetId());
cmd.Parameters.Add(idParam);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void Test_SetHairColorAndStylistId_AdjustsDatabaseCorrectly()
{
// Arrange
Client firstClient = new Client("Wendy", "blonde", 3);
firstClient.Save();
//Act
firstClient.SetHairColor("brunette");
firstClient.SetStylistId(2);
Client resultClient = Client.Find(firstClient.GetId());
//Assert
Assert.Equal("brunette", resultClient.GetHairColor());
Assert.Equal(2, resultClient.GetStylistId());
}
