public bool InsertSurvey(SurveyEntry newReview)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(Sql_InsertSurvey);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@parkCode", newReview.ParkCode);
cmd.Parameters.AddWithValue("@emailAddress", newReview.EmailAddress);
cmd.Parameters.AddWithValue("@state", newReview.State);
cmd.Parameters.AddWithValue("@activityLevel", newReview.ActivityLevel);
int num = cmd.ExecuteNonQuery();
return(num > 0);
}
}
catch (SqlException ex)
{
throw;
}
}
// GET: Survey/Index
public ActionResult Index()
{
SurveyEntry survey = new SurveyEntry();
survey.ParkList = dalPark.GetAllParks();
return(View("Index", survey));
}
public IntervalProductivityPopUp(SurveyEntry previousSurveyEntry)
{
this.InitializeComponent();
// set default values
_previousSurveyEntry = previousSurveyEntry;
if (_previousSurveyEntry != null && _previousSurveyEntry.TimeStampFinished != null && // if available
_previousSurveyEntry.TimeStampFinished.Day == DateTime.Now.Day) // only if it was answered today
{
var hint = string.Format(CultureInfo.InvariantCulture, "Last entry was: {0} {1}",
_previousSurveyEntry.TimeStampFinished.ToShortDateString(),
_previousSurveyEntry.TimeStampFinished.ToShortTimeString());
if (_previousSurveyEntry.Productivity > 0 && _previousSurveyEntry.Productivity < 7)
{
hint += ", you answered: " + _previousSurveyEntry.Productivity;
}
LastTimeFilledOut.Text = hint;
}
// start timer to close if not responded within a few hours
_closeIfNotAnsweredAfterHoursTimer = new DispatcherTimer();
_closeIfNotAnsweredAfterHoursTimer.Interval = Settings.IntervalCloseIfNotAnsweredInterval;
_closeIfNotAnsweredAfterHoursTimer.Tick += NotAnsweredAfterHours;
_closeIfNotAnsweredAfterHoursTimer.Start();
}
/// <summary>
/// Saves the daily survey result in the db & resets some items
/// </summary>
/// <param name="popup"></param>
private void SaveDailySurvey(DailyProductivityPopUp popup)
{
_lastDailyPopUpResponse = DateTime.Now.Date; // no more daily pop-up for today
_currentSurveyEntry.Productivity = popup.UserSelectedProductivity;
_currentSurveyEntry.TimeStampFinished = DateTime.Now;
Queries.SaveDailyEntry(_currentSurveyEntry);
_currentSurveyEntry = null; // reset
}
/// <summary>
/// Saves the interval-survey results in the db & resets some items
/// </summary>
/// <param name="popup"></param>
private void SaveIntervalSurvey(IntervalProductivityPopUp popup)
{
_timeRemainingUntilNextSurvey = PopUpIntervalInMins; // set new default interval
_currentSurveyEntry.Productivity = popup.UserSelectedProductivity;
_currentSurveyEntry.TimeStampFinished = DateTime.Now;
Queries.SaveIntervalEntry(_currentSurveyEntry);
_currentSurveyEntry = null; // reset
}
public ActionResult SubmitSurvey(SurveyEntry surveyEntry)
{
if (!ModelState.IsValid)
{
surveyEntry.ParkList = dalPark.GetAllParks();
return(View("Index", surveyEntry));
}
dalSurvey.InsertSurvey(surveyEntry);
return(RedirectToAction("Rankings", "Survey"));
}
/// <summary>
/// runs the survey and handles the response
/// </summary>
/// <returns></returns>
private void RunSurvey(SurveyMode mode)
{
try
{
Application.Current.Dispatcher.Invoke(DispatcherPriority.Normal, new Action(
() =>
{
var previousActiveWorkday = Queries.GetPreviousActiveWorkDay();
// if it's the first time the notification is shown
if (_currentSurveyEntry == null)
{
_currentSurveyEntry = new SurveyEntry();
_currentSurveyEntry.TimeStampNotification = DateTime.Now;
if (previousActiveWorkday > DateTime.MinValue)
{
_currentSurveyEntry.PreviousWorkDay = previousActiveWorkday;
}
}
// (re-)set the timestamp of filling out the survey
_currentSurveyEntry.TimeStampStarted = DateTime.Now;
// set previous entry to show previous entry time in popup
var popup = (mode == SurveyMode.IntervalPopUp)
? (Window) new IntervalProductivityPopUp(Queries.GetPreviousIntervalSurveyEntry())
: (Window) new DailyProductivityPopUp(previousActiveWorkday);
// show popup & handle response
if (mode == SurveyMode.DailyPopUp &&
((DailyProductivityPopUp)popup).ShowDialog() == true)
{
HandleDailyPopUpResponse((DailyProductivityPopUp)popup);
}
else if (mode == SurveyMode.IntervalPopUp &&
((IntervalProductivityPopUp)popup).ShowDialog() == true)
{
HandleIntervalPopUpResponse((IntervalProductivityPopUp)popup);
}
else
{
// we get here when DialogResult is set to false (which never happens)
Database.GetInstance().LogErrorUnknown(Name);
// to ensure it still shows some pop-ups later
_timeRemainingUntilNextSurvey = PopUpIntervalInMins;
}
}));
}
catch (ThreadAbortException e) { Database.GetInstance().LogError(Name + ": " + e.Message); }
catch (Exception e) { Database.GetInstance().LogError(Name + ": " + e.Message); }
}
/// <summary>
/// returns the previous survey entry if available
/// (only get interval survey responses)
/// </summary>
/// <returns>previous survey entry or null, if there isn't any</returns>
internal static SurveyEntry GetPreviousIntervalSurveyEntry()
{
var query = "SELECT surveyNotifyTime, surveyStartTime, surveyEndTime, userProductivity FROM '" + Settings.DbTableIntervalPopup + "' ORDER BY time DESC;";
var res = Database.GetInstance().ExecuteReadQuery(query);
if (res == null || res.Rows.Count == 0)
{
return(null);
}
var entry = new SurveyEntry();
if (res.Rows[0]["surveyNotifyTime"] != null)
{
try
{
var val = DateTime.Parse((string)res.Rows[0]["surveyNotifyTime"], CultureInfo.InvariantCulture);
entry.TimeStampNotification = val;
}
catch { } // necessary, if we run it after the DB initialization, there is no value
}
if (res.Rows[0]["surveyStartTime"] != null)
{
try
{
var val = DateTime.Parse((string)res.Rows[0]["surveyStartTime"], CultureInfo.InvariantCulture);
entry.TimeStampStarted = val;
}
catch { } // necessary, if we run it after the DB initialization, there is no value
}
if (res.Rows[0]["surveyEndTime"] != null)
{
try
{
var val = DateTime.Parse((string)res.Rows[0]["surveyEndTime"], CultureInfo.InvariantCulture);
entry.TimeStampFinished = val;
}
catch { } // necessary, if we run it after the DB initialization, there is no value
}
if (res.Rows[0]["userProductivity"] != null)
{
try
{
var val = Convert.ToInt32(res.Rows[0]["userProductivity"], CultureInfo.InvariantCulture);
entry.Productivity = val;
}
catch { } // necessary, if we run it after the DB initialization, there is no value
}
return(entry);
}
/// <summary>
/// Handles the response to the daily popup
/// </summary>
/// <param name="popup"></param>
private void HandleDailyPopUpResponse(DailyProductivityPopUp popup)
{
// user took the survey || user didn't work
if ((popup.UserSelectedProductivity >= 1 && popup.UserSelectedProductivity <= 7) || popup.UserSelectedProductivity == -1)
{
SaveDailySurvey(popup);
}
// something strange happened
else
{
_currentSurveyEntry = null;
_timeRemainingUntilNextSurvey = Settings.IntervalPostponeShortInterval;
}
}
/// <summary>
/// Saves the survey entry to the database
/// </summary>
/// <param name="entry"></param>
internal static void SaveIntervalEntry(SurveyEntry entry)
{
if (entry == null)
{
return;
}
try
{
var query = "INSERT INTO " + Settings.DbTableIntervalPopup + " (time, surveyNotifyTime, surveyStartTime, surveyEndTime, userProductivity) VALUES " +
"(strftime('%Y-%m-%d %H:%M:%S', 'now', 'localtime'), " +
Database.GetInstance().QTime(entry.TimeStampNotification) + ", " +
Database.GetInstance().QTime(entry.TimeStampStarted) + ", " +
Database.GetInstance().QTime(entry.TimeStampFinished) + ", " +
Database.GetInstance().Q(entry.Productivity.ToString(CultureInfo.InvariantCulture)) + ");";
Database.GetInstance().ExecuteDefaultQuery(query);
}
catch { }
}
/// <summary>
/// handles the response to the interval popup
/// </summary>
/// <param name="popup"></param>
private void HandleIntervalPopUpResponse(IntervalProductivityPopUp popup)
{
// user took the survey || user didn't work
if ((popup.UserSelectedProductivity >= 1 && popup.UserSelectedProductivity <= 7) || popup.UserSelectedProductivity == -1)
{
SaveIntervalSurvey(popup);
}
// user postponed the survey
else if (popup.PostPoneSurvey != PostPoneSurvey.None)
{
PostponeIntervalSurvey(popup);
Database.GetInstance().LogInfo(string.Format(CultureInfo.InvariantCulture, "The participant postponed the interval-survey ({0}).", popup.PostPoneSurvey));
}
// something strange happened
else
{
_currentSurveyEntry = null;
_timeRemainingUntilNextSurvey = Settings.IntervalPostponeShortInterval;
}
}
public void SurveyController_SubmitSurvey_SavesRecordAndReturnsRedirect()
{
//Arrange
Mock <ISurveyDAO> mockISurveyDAO = new Mock <ISurveyDAO>();
Mock <IParkDAO> mockIParkDAO = new Mock <IParkDAO>();
SurveyController controller = new SurveyController(mockISurveyDAO.Object, mockIParkDAO.Object);
SurveyEntry parameter = new SurveyEntry
{
ParkCode = ".NET",
EmailAddress = "*****@*****.**",
State = "Paris",
ActivityLevel = "Potatoe"
};
//Act
RedirectToRouteResult result = controller.SubmitSurvey(parameter) as RedirectToRouteResult;
//Assert
Assert.IsNotNull(result);
Assert.AreEqual("Rankings", result.RouteValues["action"]);
mockISurveyDAO.Verify(m => m.InsertSurvey(parameter)); //verify that our test called InsertSurvey on the Mock ISurveyDAO
}
