public void DeletePoll()
{
bool cp = true, cpp;
DBInterface.CreatePoll(p, out string sad, out string meh);
cpp = DBInterface.DeletePoll(sad);
Assert.AreEqual(cp, cpp);
}
public void GetPoll()
{
DBInterface.CreatePoll(p, out string sad, out string meh);
pr = DBInterface.GetPoll(sad);
Assert.IsNotNull(pr);
Assert.AreEqual(p.Question, pr.Question);
Assert.AreEqual(p.Disabled, pr.Disabled);
Assert.AreEqual(p.Tripcode, pr.Tripcode);
Assert.AreEqual(p.EndDate, pr.EndDate);
Assert.AreEqual(p.AnswerType, pr.AnswerType);
//Assert.AreEqual(p.DateCreated, pr.DateCreated);
Assert.AreEqual(p.PollID, pr.PollID);
//Assert.AreEqual(p.Answers, pr.Answers);
}
protected void Page_Load(object sender, EventArgs e)
{
//Get data from Request.Form in the form of "action", "data[PollQuestion]" or "data[doot][index]"
Response.ContentType = "application/json";
string action = Request.Form["action"];
string resp;
switch (action)
{
//Server receives:
//{
// "action":"add_poll",
// "data":{
// "PollQuestion": (string),
// "EndDate": (datetime?),
// "AnswerType": (int),
// "Answers": [
// (string = answer text),
// (string = answer text),
// (string = answer text),
// (string = answer text)
// ]
// }
//}
//Server sends:
//{
// "Success":(string = "true" or "false", if operation was successful),
// "Error":[
// (string = error),
// (string = error),
// (string = error)
// ],
// "data":{
// "PollID":(string),
// "TripCode":(string)
// }
//}
case "add_poll":
{
Poll newPoll = new Poll();
newPoll.Question = Request.Form["data[PollQuestion]"];
newPoll.AnswerType = Convert.ToInt32(Request.Form["data[AnswerType]"]); //TryParse
newPoll.Answers = new List <PollAnswer>();
int answerIndex = 0;
//Testing
string answers = Request.Form[$"data[Answers][]"];
if (!string.IsNullOrEmpty(answers))
{
foreach (string s in answers.Split(','))
{
newPoll.Answers.Add(new PollAnswer(HexToUnicode(s)));
}
}
DateTime endDate;
if (DateTime.TryParse(Request.Form["data[EndDate]"], out endDate))
{
newPoll.EndDate = endDate;
}
else
{
newPoll.EndDate = null;
}
string id, trip;
if (DBInterface.CreatePoll(newPoll, out id, out trip))
{
resp = "{" +
"\"Success\":true," +
"\"Error\":[]," +
"\"data\":{" +
$"\"PollID\":\"{id}\"," +
$"\"TripCode\":\"{trip}\"" +
"}" +
"}";
Response.Write(resp);
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]," + //Todo: Populate errors & add try-catches
"\"data\":{" +
$"\"PollID\":null," +
$"\"TripCode\":null" +
"}" +
"}";
Response.Write(resp);
}
}
break;
//Server receives:
//{
// "action":"close_poll",
// "data":(string = PollID)
//}
//Server sends:
//{
// "Success":(string = "true" or "false", if operation was successful),
// "Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//}
case "close_poll":
{
if (DBInterface.ClosePoll(Request.Form["data"]))
{
resp = "{" +
"\"Success\":true," +
"\"Error\":[]" +
"}";
Response.Write(resp);
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]" + //Todo: Populate errors & add try-catches
"}";
Response.Write(resp);
}
}
break;
//Server receives:
//{
// "action":"edit_poll",
// "data":{
// "PollID": (string),
// "PollQuestion": (string),
// "EndDate": (datetime?),
// "AnswerType": (int),
// "Answers": [
// (string = answer text),
// (string = answer text),
// (string = answer text),
// (string = answer text)
// ]
// }
//}
//Server sends:
// {
// "Success":(string = "true" or "false", if operation was successful),
// "Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//}
case "edit_poll":
{
Poll newPoll = new Poll();
newPoll.PollID = Request.Form["data[PollID]"];
newPoll.Question = Request.Form["data[PollQuestion]"];
newPoll.AnswerType = Convert.ToInt32(Request.Form["data[AnswerType]"]); //TryParse
newPoll.Answers = new List <PollAnswer>();
string[] answers = Request.Form["data[Answers]"].Split(',');
foreach (string answer in answers)
{
newPoll.Answers.Add(new PollAnswer(answer));
}
DateTime endDate;
if (DateTime.TryParse(Request.Form["data[EndDate]"], out endDate))
{
newPoll.EndDate = endDate;
}
else
{
//Todo: Throw a fit
}
string id, trip;
if (DBInterface.EditPoll(newPoll))
{
resp = "{" +
"\"Success\":true," +
"\"Error\":[]" +
"}";
Response.Write(resp);
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]" + //Todo: Populate errors & add try-catches
"}";
Response.Write(resp);
}
}
break;
//Server receives:
//{
// "action":"delete_poll",
// "data":(string = PollID)
//}
//Server sends:
//{
// "Success":(string = "true" or "false", if operation was successful),
// "Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//}
case "delete_poll":
{
if (DBInterface.DeletePoll(Request.Form["data"]))
{
resp = "{" +
"\"Success\":true," +
"\"Error\":[]" +
"}";
Response.Write(resp);
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]" + //Todo: Populate errors & add try-catches
"}";
Response.Write(resp);
}
}
break;
//Server receives:
//{
// "action":"vote",
// "data":{
// "PollID":(string = PollID),
// "AnswerID":(string = Answer ID)
// }
//}
//Server sends:
//{
// "Success":(string = "true" or "false", if operation was successful),
// "Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//}
case "vote":
{
string id = Request.Form["data[PollID]"];
int answerId;
if (!string.IsNullOrEmpty(Request.Form["data[AnswerID]"]))
{
answerId = Convert.ToInt32(Request.Form["data[AnswerID]"]);
if (DBInterface.Vote(id, answerId))
{
resp = "{" +
"\"Success\":true," +
"\"Error\":[]" +
"}";
Response.Write(resp);
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]" + //Todo: Populate errors & add try-catches
"}";
Response.Write(resp);
}
}
else
{
resp = "{" +
"\"Success\":false," +
"\"Error\":[]" + //Todo: Populate errors & add try-catches
"}";
Response.Write(resp);
}
}
break;
//Server receives:
//{
// "action":"get_poll",
// "data":{ "PollID":(string = PollID) }
//}
//Server sends:
//"Success":(string = "true" or "false", if operation was successful),
//"Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//"Poll":{
// "PollQuestion": (string),
// "EndDate": (datetime?),
// "AnswerType": (int),
// "AnswerCount": (int),
// "Answers": [
// { "ID": (int), "Text": (string), "Votes": (int) },
// { "ID": (int), "Text": (string), "Votes": (int) },
// { "ID": (int), "Text": (string), "Votes": (int) }
// ]
//}
case "get_poll":
Poll poll = DBInterface.GetPoll(Request.Form["data[PollID]"]);
if (poll != null)
{
StringBuilder sb = new StringBuilder("{\"Success\":true,\"Error\":[]}");
sb.Append($"\"Poll\":{PollToJson(poll)}");
resp = sb.ToString();
}
else
{
resp = $"{{\"Success\":false,\"Error\":[\"Poll #{Request.Form["data[PollID]"]} was not found.\"]}}";
}
Response.Write(resp);
break;
//Server receives:
//{
// "action":"get_poll_history",
// "data":{ "PollCount":(int = Number of polls to get) }
//}
//Server sends:
//"Success":(string = "true" or "false", if operation was successful),
//"Error":[
// (string = error),
// (string = error),
// (string = error)
// ]
//"Polls":[
// {
// "PollID": (string),
// "PollQuestion": (string),
// "EndDate": (datetime?),
// "AnswerType": (int),
// "AnswerCount": (int),
// "Answers": [
// { "ID": (int), "Text": (string), "Votes": (int) },
// { "ID": (int), "Text": (string), "Votes": (int) },
// { "ID": (int), "Text": (string), "Votes": (int) }
// ]
// },
// (etc...)
//]
case "get_poll_history":
List <Poll> polls = DBInterface.GetRecentPolls(int.Parse(Request.Form["data[PollCount]"]));
if (polls != null)
{
StringBuilder sb = new StringBuilder("{\"Success\":true,\"Error\":[], ");
sb.Append("\"Polls\":[");
foreach (Poll topPoll in polls)
{
sb.Append(PollToJson(topPoll) + ",");
}
if (polls.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]}");
resp = sb.ToString();
}
else
{
resp = $"{{\"Success\":false,\"Error\":[\"Poll #{Request.Form["data[PollID]"]} was not found.\"]}}";
}
Response.Write(resp);
break;
default:
resp = $"{{\"Success\":false,\"Error\":[\"Invalid command: '{action}'\"]}}";
break;
}
}
public void CreatePoll()
{
DBInterface.CreatePoll(p, out string sad, out string meh);
}