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