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