public ActionResult Downvote(int listID, int voteType) { DbConnection1530 dbcon = new DbConnection1530(); dbcon.DownvoteListing(listID); return(null); }
private static void Main(string[] args) { Console.WriteLine("Driver Program to test core features of the program"); DbConnection1530 dbcon = new DbConnection1530(); dbcon.SearchMapListings();//Return all Dictionary <string, string> queryParams = new Dictionary <string, string>(); queryParams["Image"] = "1";//Add as many parameters as you would like Console.WriteLine("Testing with Dictionary"); var list = dbcon.SearchMapListings(queryParams); Console.WriteLine("Done Testing"); }
/** * if (x == 0 && reader[x] != DBNull.Value) * { * result += reader[x]; * } else if (reader[x] != DBNull.Value) * { * result += "~" + reader[x]; * } * // Debug.WriteLine(reader.GetName(x) + " : " + reader[x]); * } * * result += "|"; **/ public ActionResult GrabListings() { DbConnection1530 db = new DbConnection1530(); List <MapListing> listings = db.SearchMapListings(); string combinedMapString = ""; foreach (MapListing item in listings) { combinedMapString = combinedMapString + String.Format("{0}~{1}~{2}~{3}~{4}|", item.Image, item.Xcord, item.YCord, item.Description, item.Upvotes); } string ser = JsonConvert.SerializeObject(combinedMapString); Debug.WriteLine(ser); return(Content(ser)); }
public ActionResult InsertListing(string Type, string Lat, string Lng, string Tags, string Details) { Dictionary <string, string> entries = new Dictionary <string, string>(); if (Lat.Equals("")) { Lat = "45"; Lng = "-75"; } entries["Xcoord"] = Lat; entries["Ycoord"] = Lng; entries["Description"] = Details; entries["Image"] = Type; entries["Upvotes"] = "0"; entries["Downvotes"] = "0"; entries["Creator"] = "*****@*****.**"; entries["Tags"] = "None"; DbConnection1530 dbcon = new DbConnection1530(); dbcon.InsertMapListing(entries); return(null); }
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true //var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false); Dictionary <string, string> userSearch = new Dictionary <string, string>(); userSearch.Add("email", model.Email); userSearch.Add("password", model.Password); DbConnection1530 dbconn = new DbConnection1530(); Boolean found = dbconn.SearchUser(userSearch); System.Diagnostics.Debug.WriteLine("found?!!" + found); HttpSessionStateBase session = Session; System.Diagnostics.Debug.WriteLine("loggedin?!!" + session["LoggedIn"]); if (found) { session["LoggedIn"] = "true"; return(RedirectToLocal(returnUrl)); } else { ModelState.AddModelError("", "Invalid login attempt."); } return(View(model)); }
public void DbConnectionTest() { DbConnection1530 connection = new DbConnection1530(); Assert.IsTrue(true); }