public HomeModule() { Get["/"] = _ => { List <Bills_PC> AllPokemon = Bills_PC.GetAll(); return(View["index.cshtml", AllPokemon]); }; Post["/pc"] = _ => { Bills_PC newEntry = new Bills_PC(Request.Form["dex-no"], Request.Form["name"], Request.Form["nick-name"], Request.Form["lv"]); newEntry.Save(); List <Bills_PC> AllPokemon = Bills_PC.GetAll(); return(View["index.cshtml", AllPokemon]); }; Post["/DeleteAll"] = _ => { Bills_PC.DeleteAll(); List <Bills_PC> AllPokemon = Bills_PC.GetAll(); return(View["index.cshtml", AllPokemon]); }; Post["/release"] = _ => { foreach (string pokemon in Request.Form["pokemon"]) { Bills_PC.DeleteOne(pokemon); } List <Bills_PC> AllPokemon = Bills_PC.GetAll(); return(View["index.cshtml", AllPokemon]); }; }
public static List <Bills_PC> GetAll() { List <Bills_PC> allBills_PCs = new List <Bills_PC> { }; SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Bills_PC;", conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { int dex = rdr.GetInt32(0); string name = rdr.GetString(1); string nickName = rdr.GetString(2); int lv = rdr.GetInt32(3); Bills_PC newBill = new Bills_PC(dex, name, nickName, lv); allBills_PCs.Add(newBill); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(allBills_PCs); }
public void Test_DatabaseEmptyAtFirst() { //Arrange, Act int result = Bills_PC.GetAll().Count; int resultTest = 0; //Assert Assert.Equal(resultTest, result); }
public void Test_Save() { Bills_PC testPokemon = new Bills_PC(001, "Bulbasaur", "Sprite", 11); testPokemon.Save(); List <Bills_PC> result = Bills_PC.GetAll(); Console.WriteLine(result[0].GetDex() + " " + result[0].GetName() + " " + result[0].GetNick() + " " + result[0].GetLv()); string resultTest = "Bulbasaur"; Assert.Equal(resultTest, result[0].GetName()); }
public void Dispose() { Bills_PC.DeleteAll(); }