public HomeModule() { Get["/"] = _ => { string path = "/blazon/per+pale+per+fess+sable+a+chief+or+and+purpure+overall+a+bend+argent+and+vert+11+mullets+argent+overall+a+lozenge+azure/shieldShape/1"; return Response.AsRedirect(path); }; Post["/blazon"] =_=> { string input = Request.Form["blazon-string"]; string shieldShape = Request.Form["shield-shape"]; string formattedBlazon = string.Join("+",Parser.FormatBlazon(input)); string path = "/blazon/"+formattedBlazon+"/shieldShape/"+shieldShape; return Response.AsRedirect(path); }; Get["/blazon/{blazon}/shieldShape/{shieldShape}"]= parameter => { int shieldNumber = parameter.shieldShape; string input = parameter.blazon; string newBlazon = input.Replace("+"," "); Division div = new Division(GetShieldPoly(shieldNumber)); dynamic Model = new ExpandoObject(); Model.outputString = Parser.Parse(newBlazon, div); Model.html = GenerateHTML(div); Model.shieldShape = parameter.shieldShape; Model.newBlazon = newBlazon; Model.allBlazons = SaveBlazon.GetAll(); return View["index.cshtml", Model]; }; Post["/save"]= _ => { string blazonName = Request.Form["blazon-name"]; string blazonBlazon = Request.Form["blazon-blazon"]; int blazonShape = (int)Request.Form["shield-shape"]; SaveBlazon newSaveBlazon = new SaveBlazon(blazonName, blazonBlazon, blazonShape); newSaveBlazon.Save(); string formattedBlazon = blazonBlazon.Replace(" ", "+"); string path = "/blazon/"+formattedBlazon+"/shieldShape/"+blazonShape; return Response.AsRedirect(path); }; Post["/delete"]= _ => { SaveBlazon.DeleteAll(); string path = "/blazon/per+pale+per+fess+sable+a+chief+or+and+purpure+overall+a+bend+argent+and+vert+11+mullets+argent+overall+a+lozenge+azure/shieldShape/1"; return Response.AsRedirect(path); }; }
public static SaveBlazon Find(int id) { DBObjects dbo = DBObjects.CreateCommand("SELECT * FROM blazons WHERE id=@Id;", new List<string> {"@Id"}, new List<object> {id}); SqlDataReader rdr = dbo.RDR; rdr = dbo.CMD.ExecuteReader(); int foundSavedBlazonId = 0; string foundSavedBlazonName = null; string foundSavedBlazonBlazon = null; int foundSavedBlazonShape = 0; while (rdr.Read()) { foundSavedBlazonId = rdr.GetInt32(0); foundSavedBlazonName = rdr.GetString(1); foundSavedBlazonBlazon = rdr.GetString(2); foundSavedBlazonShape = rdr.GetInt32(3); } SaveBlazon foundSavedBlazon = new SaveBlazon(foundSavedBlazonName, foundSavedBlazonBlazon, foundSavedBlazonShape, foundSavedBlazonId); dbo.Close(); return foundSavedBlazon; }
public static List<SaveBlazon> GetAll() { DBObjects dbo = DBObjects.CreateCommand("SELECT * FROM blazons;"); SqlDataReader rdr = dbo.RDR; rdr = dbo.CMD.ExecuteReader(); List<SaveBlazon> allBlazons = new List<SaveBlazon>{}; while(rdr.Read()) { int blazonId = rdr.GetInt32(0); string blazonName = rdr.GetString(1); string blazonBlazon = rdr.GetString(2); int blazonShape = rdr.GetInt32(3); SaveBlazon newSavedBlazon = new SaveBlazon(blazonName, blazonBlazon, blazonShape, blazonId); allBlazons.Add(newSavedBlazon); } dbo.Close(); return allBlazons; }