public static Stylist Find(int id)
{
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM stylists WHERE id = @StylistId;", conn);
SqlParameter stylistIdParameter = new SqlParameter();
stylistIdParameter.ParameterName = "@StylistId";
stylistIdParameter.Value = id.ToString();
cmd.Parameters.Add(stylistIdParameter);
rdr = cmd.ExecuteReader();
int foundStylistId = 0;
string foundStylistName = null;
while(rdr.Read())
{
foundStylistId = rdr.GetInt32(0);
foundStylistName = rdr.GetString(1);
}
Stylist foundStylist = new Stylist(foundStylistName, foundStylistId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return foundStylist;
}
public static List<Stylist> GetAll()
{
List<Stylist> allStylists = new List<Stylist>{};
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM stylists;", conn);
rdr = cmd.ExecuteReader();
while(rdr.Read())
{
int stylistId = rdr.GetInt32(0);
string stylistName = rdr.GetString(1);
Stylist newStylist = new Stylist(stylistName, stylistId);
allStylists.Add(newStylist);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return allStylists;
}
public void Test_Equals_ObjectEqualsOverride()
{
Stylist firstStylist = new Stylist("Rebecca");
Stylist secondStylist = new Stylist("Rebecca");
Assert.Equal(firstStylist, secondStylist);
}
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 Test_Find_FindsCategoryInDatabase()
{
Stylist testStylist = new Stylist("Rebecca");
testStylist.Save();
Stylist foundStylist = Stylist.Find(testStylist.GetId());
Assert.Equal(testStylist, foundStylist);
}
public void Test_Find_ReturnsASpecificStylistObject()
{
//Arrange
Stylist newStylist = new Stylist("Tracy", 17);
newStylist.Save();
//Act
Stylist foundStylist = Stylist.Find(newStylist.GetId());
//Assert
Assert.Equal(newStylist, foundStylist);
}
public void Test_GetAll_RetrievesAllStylistsFromDatabase()
{
Stylist firstStylist = new Stylist("Rebecca");
Stylist secondStylist = new Stylist("Tony");
firstStylist.Save();
secondStylist.Save();
List<Stylist> testList = new List<Stylist>{firstStylist, secondStylist};
List<Stylist> result = Stylist.GetAll();
Assert.Equal(testList, result);
}
public void Test_GetClients_FindsClientsByStylistId()
{
//Arrange
Stylist newStylist = new Stylist("Tracy", 18);
newStylist.Save();
Client firstClient = new Client("Jasper", "brunette", newStylist.GetId());
firstClient.Save();
Client secondClient = new Client("Wendy", "blonde", 2);
secondClient.Save();
List<Client> expectedResult = new List<Client> {firstClient};
//Act
List<Client> result = newStylist.GetClients();
//Assert
Assert.Equal(expectedResult, result);
}
public void Test_Delete_DeletesStylistAndClientsByStylistId()
{
//Arrange
Stylist firstStylist = new Stylist("Tracy", 17);
firstStylist.Save();
Stylist secondStylist = new Stylist("Chad", 10);
secondStylist.Save();
Client firstClient = new Client("Jasper", "brunette", firstStylist.GetId());
firstClient.Save();
Client secondClient = new Client("Wendy", "blonde", secondStylist.GetId());
secondClient.Save();
List<Stylist> expectedStylist = new List<Stylist>{firstStylist};
List<Client> expectedResult = new List<Client> {firstClient};
//Act
secondStylist.Delete();
List<Stylist> resultingStylist = Stylist.GetAll();
List<Client> result = Client.GetAll();
//Assert
Assert.Equal(expectedStylist, resultingStylist);
Assert.Equal(expectedResult, result);
}
public void Test_SetPrice_AdjustsDatabaseCorrectly()
{
// Arrange
Stylist firstStylist = new Stylist("Tracy", 17);
firstStylist.Save();
//Act
firstStylist.SetPrice(15);
Stylist resultStylist = Stylist.Find(firstStylist.GetId());
//Assert
Assert.Equal(15, resultStylist.GetPrice());
}
public void Test_Save_SavesCorrectObjectToDatabase()
{
//Arrange
Stylist newStylist = new Stylist("Tracy", 17);
//Act
newStylist.Save();
Stylist savedStylist = Stylist.GetAll()[0];
//Assert
Assert.Equal(newStylist, savedStylist);
}
public void Test_GetClients_RetrievesAllClientsWithStylist()
{
Stylist testStylist = new Stylist("Rebecca");
testStylist.Save();
Client firstClient = new Client("Sam", testStylist.GetId());
firstClient.Save();
Client secondClient = new Client("Beth", testStylist.GetId());
secondClient.Save();
List<Client> testClientList = new List<Client> {firstClient, secondClient};
List<Client> resultClientList = testStylist.GetClients();
Assert.Equal(testClientList, resultClientList);
}
public void Test_Update_UpdatesStylistInDatabase()
{
string name = "Rebecca";
Stylist testStylist = new Stylist(name);
testStylist.Save();
string newName = "Becky";
testStylist.Update(newName);
string result = testStylist.GetName();
Assert.Equal(newName, result);
}
public void Test_Save_SavesStylistToDatabase()
{
Stylist testStylist = new Stylist("Rebecca");
testStylist.Save();
List<Stylist> result = Stylist.GetAll();
List<Stylist> testList = new List<Stylist>{testStylist};
Assert.Equal(testList, result);
}
public void Dispose()
{
Stylist.DeleteAll();
}
