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