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