public void Test_Find_FindsClassInDatabase() { Class testClass = new Class("Knight"); testClass.Save(); Class foundClass = Class.Find(testClass.GetId()); Assert.Equal(testClass, foundClass); }
public void Test_Delete_DeletesClassFromDatabase() { Class testClass1 = new Class("Knight"); testClass1.Save(); Class testClass2 = new Class("Berserker"); testClass2.Save(); Class.Delete(testClass1.GetId()); List<Class> testList = new List<Class>{testClass2}; List<Class> resultList = Class.GetAll(); Assert.Equal(testList, resultList); }
public void Test_Update_UpdatesClassWithNewValues() { Class testClass = new Class("Knight"); testClass.Save(); testClass.SetName("Berserker"); testClass.Update(); Class resultClass = Class.Find(testClass.GetId()); Class test = new Class("Berserker", testClass.GetId()); Assert.Equal(test, resultClass); }
public void AddClass(Class newClass) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO classes_items (class_id, item_id) VALUES (@ClassId, @ItemId);", conn); SqlParameter classIdParameter = new SqlParameter(); classIdParameter.ParameterName = "@ClassId"; classIdParameter.Value = newClass.GetId(); SqlParameter itemIdParameter = new SqlParameter(); itemIdParameter.ParameterName = "@ItemId"; itemIdParameter.Value = this.GetId(); cmd.Parameters.Add(classIdParameter); cmd.Parameters.Add(itemIdParameter); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }