public static List <Nutcracker> GetAll() { List <Nutcracker> allNutcrackers = new List <Nutcracker> { }; SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM nutcrackers;", conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { int nutcrackerId = rdr.GetInt32(0); string nutcrackerName = rdr.GetString(1); Nutcracker newNutcracker = new Nutcracker(nutcrackerName, nutcrackerId); allNutcrackers.Add(newNutcracker); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(allNutcrackers); }
public static Nutcracker Find(int id) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM nutcrackers WHERE id = @NutcrackerId;", conn); SqlParameter nutcrackerIdParameter = new SqlParameter(); nutcrackerIdParameter.ParameterName = "@NutcrackerId"; nutcrackerIdParameter.Value = id.ToString(); cmd.Parameters.Add(nutcrackerIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); int foundNutcrackerId = 0; string foundNutcrackerName = null; while (rdr.Read()) { foundNutcrackerId = rdr.GetInt32(0); foundNutcrackerName = rdr.GetString(1); } Nutcracker foundNutcracker = new Nutcracker(foundNutcrackerName, foundNutcrackerId); if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(foundNutcracker); }
public void Test_Equal_ReturnsTrueIfSameName() { //Arrange, Act Nutcracker nutcracker1 = new Nutcracker("Phil"); Nutcracker nutcracker2 = new Nutcracker("Phil"); //Assert Assert.Equal(nutcracker1, nutcracker2); }
public void Test_Find_FindsNutcrackerInDatabase() { //Arrange Nutcracker testNutcracker = new Nutcracker("Phil"); testNutcracker.Save(); //Act Nutcracker foundNutcracker = Nutcracker.Find(testNutcracker.GetId()); //Assert Assert.Equal(testNutcracker, foundNutcracker); }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Post["/"] = _ => { string userInput = Request.Form["name"]; Nutcracker newNutcracker = new Nutcracker(userInput); newNutcracker.Save(); string newName = newNutcracker.GetName(); List <Nutcracker> allNutcrackers = Nutcracker.GetAll(); return(View["index.cshtml", allNutcrackers]); }; }
public override bool Equals(System.Object otherNutcracker) { if (!(otherNutcracker is Nutcracker)) { return(false); } else { Nutcracker newNutcracker = (Nutcracker)otherNutcracker; bool idEquality = (this.GetId() == newNutcracker.GetId()); bool nameEquality = (this.GetName() == newNutcracker.GetName()); return(idEquality && nameEquality); } }
public void Test_Save_AssignsIdToObject() { //Arrange Nutcracker testNutcracker = new Nutcracker("Phil"); //Act testNutcracker.Save(); Nutcracker savedNutcracker = Nutcracker.GetAll()[0]; int result = savedNutcracker.GetId(); int testId = testNutcracker.GetId(); //Assert Assert.Equal(testId, result); }
public void Test_Save_SavesToDatabase() { //Arrange Nutcracker testNutcracker = new Nutcracker("Phil"); //Act testNutcracker.Save(); List <Nutcracker> result = Nutcracker.GetAll(); List <Nutcracker> testList = new List <Nutcracker> { testNutcracker }; //Assert Assert.Equal(testList, result); }
public void Dispose() { Nutcracker.DeleteAll(); }
public void Test_DatabaseEmptyAtFirst() { int result = Nutcracker.GetAll().Count; Assert.Equal(0, result); }