public Survey Update(Survey survey)
{
this.surveys.Update(survey);
this.surveys.SaveChanges();
return survey;
}
private bool SaveSurvey(Survey survey, int applicantID) {
string param = "EXEC spSaveSurvey '" + applicantID + "', ";
param = param + "'" + survey.QuestionID + "', '" + survey.RateID + "','" + survey.Comment + "'";
conn = new DBConn.DBConn();
conn.execSQLCommand(param);
return true;
}
public static Survey createSurvey(ImportingElement element, int id, string flag)
{
GRASPEntities db = new GRASPEntities();
Survey survey = new Survey();
survey.name = element.refListName;
survey.owner_id = id;
db.Survey.Add(survey);
db.SaveChanges();
if (flag == "select1")
{
foreach (string label in element.select1Labels)
{
int size = FormFieldExport.getSurveyList(survey.id);
SurveyElement se = createSurveyElement(label, size);
createSurveyAssociation(survey.id, se.id);
}
}
if (flag == "survey")
{
foreach (string label in element.surveyValues)
{
int size = FormFieldExport.getSurveyList(survey.id);
SurveyElement se = createSurveyElement(label, size);
createSurveyAssociation(survey.id, se.id);
}
}
return survey;
}
public List<Survey> GetSurveys()
{
List<Survey> lstSurveys = new List<Survey>();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("SELECTSurveys",CommandType.StoredProcedure);
DbDataReader oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
Survey oSurvey = new Survey();
oSurvey.SurveyId = Convert.ToInt32(oDbDataReader["SurveyId"]);
if(oDbDataReader["SurveyGuid"] != DBNull.Value)
oSurvey.SurveyGuid = (Guid) oDbDataReader["SurveyGuid"];
oSurvey.SubmissionGuid = (Guid) oDbDataReader["SubmissionGuid"];
if(oDbDataReader["Voter"] != DBNull.Value)
oSurvey.Voter = Convert.ToString(oDbDataReader["Voter"]);
oSurvey.Vote = Convert.ToInt32(oDbDataReader["Vote"]);
oSurvey.IPAddress = Convert.ToString(oDbDataReader["IPAddress"]);
if(oDbDataReader["DateCreated"] != DBNull.Value)
oSurvey.DateCreated = Convert.ToDateTime(oDbDataReader["DateCreated"]);
lstSurveys.Add(oSurvey);
}
oDbDataReader.Close();
return lstSurveys;
}
public void EditSurvey(Survey surveyToEdit, Survey editingSurvey)
{
var rowIndexOfItemToEdit = this.SurveysPage.Map.KendoGrid.IndexOfGridRowContainingText(surveyToEdit.Name);
this.SurveysPage.Map.AllEditEntryButtons[rowIndexOfItemToEdit].MouseClick();
ExecutionDelayProvider.SleepFor(2000);
Manager.Current.ActiveBrowser.RefreshDomTree();
ExecutionDelayProvider.SleepFor(2000);
this.SurveysPage.Map.Name.MouseClick(MouseClickType.LeftDoubleClick);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.KeyPress(Keys.Back);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(editingSurvey.Name);
this.SurveysPage.Map.ActiveFromLabel.MouseClick();
Manager.Current.ActiveBrowser.Desktop.KeyBoard.KeyPress(Keys.Back);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(editingSurvey.ActiveFrom);
this.SurveysPage.Map.Name.MouseClick();
ExecutionDelayProvider.SleepFor(2000);
this.SurveysPage.Map.ActiveToLabel.MouseClick(MouseClickType.LeftDoubleClick);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.KeyPress(Keys.Back);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(editingSurvey.ActiveTo);
this.SurveysPage.Map.Name.MouseClick();
ExecutionDelayProvider.SleepFor(2000);
Manager.Current.ActiveBrowser.RefreshDomTree();
this.SurveysPage.Map.UpdateItemButton.MouseClick();
Manager.Current.ActiveBrowser.RefreshDomTree();
ExecutionDelayProvider.SleepFor(2000);
}
protected void btnSubmitSurvey_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//if incident selected not "--select incident--"
if (lbIncident.SelectedIndex > 0)
{
Survey survey = new Survey();
Label1.Text = lbIncident.SelectedValue;
survey.IncidentID = Int32.Parse(lbIncident.SelectedValue);
survey.CustomerID = Int32.Parse(tbEnterCustID.Text);
survey.ResponseTime = Convert.ToInt32(rbResponse.SelectedValue);
survey.Resolution = Convert.ToInt32(rbResolution.SelectedValue);
survey.TechEfficiency = Convert.ToInt32(rbTechEfficiency.SelectedValue);
survey.Contact = cbContact.Checked;
if (cbContact.Checked)
{
survey.ContactBy = rbContactBy.Text;
}
survey.Comments = tbComments.Text;
Session["Survey"] = survey;
Response.Redirect("~/SurveyComplete.aspx");
}
//else
//{
// RequiredValFieldIncidentList.
//}
Response.Redirect("~/SurveyComplete.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Sage.Platform.WebPortal.WebPortalPage page = Parent.Page as Sage.Platform.WebPortal.WebPortalPage;
if (page == null)
return;
currentSurvey = page.PageWorkItem.Modules
.Get<Sage.SalesLogix.Web.Modules.WorkSurveyModule>().CurrentWorkSurveyConfig;
if (currentSurvey == null)
return;
SetPageValues();
if (!Page.IsPostBack)
{
FillDelayOptions();
// hide the no thanks button if the survey is required
if (currentSurvey.IsRequired)
rbNo.Visible = false;
// if the title image doesn't exist, hide it so alternate text doesn't show up
if (!File.Exists(Server.MapPath(currentSurvey.SurveyOfferPage.OfferPageImagePath)))
imgTitle.Visible = false;
ddlDelayDays.Attributes.Add("onchange",
"document.getElementById('" + rbLater.ClientID + "').checked='checked';");
}
CreateSurveyScript();
}
public Survey getCurrentSurvey()
{
SqlConnection conn = new SqlConnection(ConnectionString);
string sql = "SELECT * FROM user_survey_polls WHERE active = 1";
SqlCommand cmd = new SqlCommand(sql, conn);
Survey survey = null;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
survey = new Survey((int)reader["id"], (int)reader["survey_num"], (string)reader["description"], (int)reader["active"]);
reader.Close();
return survey;
}
catch
{
throw new Exception();
}
finally
{
conn.Close();
}
}
public Vote(User user, Survey survey, Answer answer)
: this()
{
this.User = user;
this.Survey = survey;
this.Answer = answer;
}
public static TestReferralSurvey BuildAdditionalFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT id_survey_organ, survey_comment, id_survey_type FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1";
NpgsqlCommand person = new NpgsqlCommand(findPatient, connection);
using (NpgsqlDataReader personFromDataBase = person.ExecuteReader())
{
Survey p = new Survey();
while (personFromDataBase.Read())
{
//что делать с DateSpecified и Мисами?
if (personFromDataBase["survey_comment"] != DBNull.Value)
p.Comment = Convert.ToString(personFromDataBase["survey_comment"]);
TestReferralSurvey pers = new TestReferralSurvey(p);
pers.additional = TestAdditional.BuildAdditionalFromDataBaseData(idReferral);
if (personFromDataBase["id_survey_organ"] != DBNull.Value)
pers.surveyOrgan = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_organ"]));
if (personFromDataBase["id_survey_type"] != DBNull.Value)
pers.surveyType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_type"]));
return pers;
}
}
}
return null;
}
public Survey GetSurvey(int SurveyId)
{
Survey oSurvey = new Survey();
DbCommand oDbCommand = DbProviderHelper.CreateCommand("SELECTSurvey",CommandType.StoredProcedure);
oDbCommand.Parameters.Add(DbProviderHelper.CreateParameter("@SurveyId",DbType.Int32,SurveyId));
DbDataReader oDbDataReader = DbProviderHelper.ExecuteReader(oDbCommand);
while (oDbDataReader.Read())
{
oSurvey.SurveyId = Convert.ToInt32(oDbDataReader["SurveyId"]);
if(oDbDataReader["SurveyGuid"] != DBNull.Value)
oSurvey.SurveyGuid = (Guid) oDbDataReader["SurveyGuid"];
oSurvey.SubmissionGuid = (Guid) oDbDataReader["SubmissionGuid"];
if(oDbDataReader["Voter"] != DBNull.Value)
oSurvey.Voter = Convert.ToString(oDbDataReader["Voter"]);
oSurvey.Vote = Convert.ToInt32(oDbDataReader["Vote"]);
oSurvey.IPAddress = Convert.ToString(oDbDataReader["IPAddress"]);
if(oDbDataReader["DateCreated"] != DBNull.Value)
oSurvey.DateCreated = Convert.ToDateTime(oDbDataReader["DateCreated"]);
}
oDbDataReader.Close();
return oSurvey;
}
public void RunGetsSurveyAnswersForIdFromStore()
{
var mockSurveyStore = new Mock<ISurveyStore>();
var mockSurveyAnswerStore = new Mock<ISurveyAnswerStore>();
var mockTenantStore = new Mock<ITenantStore>();
var mockSurveySqlStore = new Mock<ISurveySqlStore>();
var command = new TransferSurveysToSqlAzureCommand(mockSurveyAnswerStore.Object, mockSurveyStore.Object, mockTenantStore.Object, mockSurveySqlStore.Object);
var message = new SurveyTransferMessage { Tenant = "tenant", SlugName = "slugName" };
var survey = new Survey("slugName")
{
Tenant = "tenant",
};
survey.Questions.Add(new Question
{
Text = "What is your favorite food?",
PossibleAnswers = "Coffee\nPizza\nSalad",
Type = QuestionType.MultipleChoice
});
mockSurveyStore.Setup(r => r.GetSurveyByTenantAndSlugName("tenant", "slugName", true)).Returns(survey);
mockSurveyStore.Setup(r => r.GetSurveysByTenant("tenant")).Returns(new List<Survey> { survey });
mockSurveyAnswerStore.Setup(r => r.GetSurveyAnswerIds("tenant", "slugName")).Returns(new List<string> { "id" });
mockSurveyAnswerStore.Setup(r => r.GetSurveyAnswer("tenant", "slugName", "id")).Returns(new SurveyAnswer());
var tenant = new Tenant { SqlAzureConnectionString = "connectionString" };
mockTenantStore.Setup(r => r.GetTenant("tenant")).Returns(tenant);
command.Run(message);
mockSurveyAnswerStore.Verify(r => r.GetSurveyAnswer(message.Tenant, "slugName", "id"));
}
public void DeleteSurvey(Survey survey)
{
var rowIndexOfItemToDelete = this.SurveysPage.Map.KendoGrid.IndexOfGridRowContainingText(survey.Name);
this.SurveysPage.Map.AllDeleteEntryButtons[rowIndexOfItemToDelete].MouseClick();
ExecutionDelayProvider.SleepFor(2000);
Manager.Current.ActiveBrowser.Desktop.KeyBoard.KeyPress(Keys.Enter);
ExecutionDelayProvider.SleepFor(2000);
}
public override void Delete(Survey entity)
{
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
{
base.Delete(entity);
scope.Complete();
}
}
public SurveyPage(Survey survey)
{
//BackgroundColor = Color.FromHex ("#2A2A2A");
InitializeComponent ();
Title = "Survey";
if (Device.OS == TargetPlatform.Android)
NavigationPage.SetTitleIcon(this, "opac.png");
BindingContext = new ViewModels.SurveyViewModel (survey, BackgroundColor);
AnswerList.ItemSelected += AnswerList_ItemSelected;
}
public TestReferralSurvey(Survey r)
{
if (r != null)
survey = r;
else
survey = new Survey();
additional = new TestAdditional(survey.Additional);
if (survey.SurveyOrgan != null)
surveyOrgan = new TestCoding(survey.SurveyOrgan);
if (survey.SurveyType != null)
surveyType = new TestCoding(survey.SurveyType);
}
public void DeleteSurvey(Survey survey)
{
this.Votes.RemoveRange(this.Votes.Where(v => v.Survey.Id == survey.Id));
foreach (Answer a in survey.Answers)
this.Answers.Attach(a);
this.Answers.RemoveRange(survey.Answers);
this.SaveChanges();
Survey surveyDb = this.Surveys.Where(s => s.Id == survey.Id).First<Survey>();
this.Surveys.Attach(surveyDb);
this.Surveys.Remove(surveyDb);
this.SaveChanges();
}
public void AddQuestionCopiesCachedSurveyToTempDataWhenModelIsNotValid()
{
using (var controller = new SurveysController(null, null, null, null, null, null))
{
controller.ModelState.AddModelError("error for test", "invalid model state");
var cachedSurvey = new Survey();
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
var result = controller.AddQuestion(null) as ViewResult;
var cachedSurveyReturnedInTempData = result.TempData[SurveysController.CachedSurvey] as Survey;
Assert.AreSame(cachedSurvey, cachedSurveyReturnedInTempData);
}
}
public void AddQuestionAddsTheNewQuestionToTheCachedSurveyWhenModelIsValid()
{
var cachedSurvey = new Survey();
cachedSurvey.Questions.Add(new Question());
var question = new Question();
using (var controller = new SurveysController(null, null, null, null, null, null))
{
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
controller.AddQuestion(question);
var actualQuestions = (controller.TempData[SurveysController.CachedSurvey] as Survey).Questions;
Assert.AreEqual(2, actualQuestions.Count);
Assert.IsTrue(actualQuestions.Contains(question));
}
}
public void AddSurvey(Survey survey)
{
this.SurveysPage.Map.AddItemButton.MouseClick();
ExecutionDelayProvider.SleepFor(2000);
Manager.Current.ActiveBrowser.RefreshDomTree();
ExecutionDelayProvider.SleepFor(2000);
this.SurveysPage.Map.Name.MouseClick();
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(survey.Name);
this.SurveysPage.Map.ActiveFrom.MouseClick();
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(survey.ActiveFrom);
this.SurveysPage.Map.Name.MouseClick();
this.SurveysPage.Map.ActiveTo.MouseClick();
Manager.Current.ActiveBrowser.Desktop.KeyBoard.TypeText(survey.ActiveTo);
this.SurveysPage.Map.Name.MouseClick();
ExecutionDelayProvider.SleepFor(2000);
Manager.Current.ActiveBrowser.RefreshDomTree();
this.SurveysPage.Map.UpdateItemButton.MouseClick();
}
public string DeleteSurvey(Survey survey)
{
try
{
if (survey == null)
{
throw new ArgumentNullException();
}
using (var db = new SurveyContext())
{
db.DeleteSurvey(survey);
}
return "0";
}
catch (Exception e)
{
return e.Message;
}
}
public async Task<IHttpActionResult> PutSurvey(int id, Survey survey)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != survey.SurveyId)
{
return BadRequest();
}
var dbVersion = db.Surveys
.Include(x => x.Questions)
.Single(c => c.SurveyId == survey.SurveyId);
//update individual properties; had trouble getting the associaed questions updating properly without doing it this way.
dbVersion.Name = survey.Name;
dbVersion.Description = survey.Description;
dbVersion.CompletionMessage = survey.CompletionMessage;
dbVersion.IsClosed = survey.IsClosed;
dbVersion.Questions = survey.Questions;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SurveyExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public ActionResult Create(Survey survey)
{
//Not sure if this is really needed
//ModelState.Clear();
//survey.TransferValidationMessagesTo(ModelState);
if (ModelState.IsValid)
{
_surveyRepository.EnsurePersistent(survey);
Message = "Survey Created Successfully";
return this.RedirectToAction(a => a.Edit(survey.Id));
}
else
{
var viewModel = SurveyViewModel.Create(Repository);
viewModel.Survey = survey;
return View(viewModel);
}
}
public ActionResult SurveyQuestions(int id)
{
Survey survey = db.Surveys.Find(id);
Survey template = new Survey();
template.Id = id;
template.Title = survey.Title;
List<QuestionResponse> qResponses = db.QuestionResponses.Where(x => x.SurveyId == survey.Id).ToList();
List<QuestionResponse> surveyQuestions = new List<QuestionResponse>();
foreach (var item in qResponses)
{
surveyQuestions.Add(item);
}
surveyQuestions.OrderBy(x => x.Id).ToList();
template.Responses = surveyQuestions.OrderByDescending(x => x.Id).ToList();
return Json(template, JsonRequestBehavior.AllowGet);
}
public void DisplayCopiesTheSurveyQuestionTypeToTheQuestionAnswerReturnedInTheContentModel()
{
var survey = new Survey
{
Questions = new List<Question>(
new[]
{
new Question { Type = QuestionType.SimpleText },
})
};
var mockSurveyStore = new Mock<ISurveyStore>();
mockSurveyStore.Setup(r => r.GetSurveyByTenantAndSlugName(It.IsAny<string>(), It.IsAny<string>(), It.IsAny<bool>()))
.Returns(survey);
using (var controller = new SurveysController(mockSurveyStore.Object, default(ISurveyAnswerStore)))
{
var result = controller.Display("tenant", string.Empty) as ViewResult;
var model = result.ViewData.Model as TenantPageViewData<SurveyAnswer>;
Assert.AreEqual(QuestionType.SimpleText, model.ContentModel.QuestionAnswers.First().QuestionType);
}
}
public void NewWhenHttpVerbIsPostSavesCachedSurveyInTempDataWhenModelStateIsNotValid()
{
var cachedSurvey = new Survey();
using (var controller = new SurveysController(new Mock<ISurveyStore>().Object, null, null, null, null, null))
{
controller.ModelState.AddModelError("error for test", "invalid model state");
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
var result = controller.New(new Survey()) as ViewResult;
var model = result.ViewData.Model as TenantPageViewData<Survey>;
Assert.AreSame(cachedSurvey, controller.TempData[SurveysController.CachedSurvey]);
}
}
/// <summary>
/// Create a new <see cref="SampleDataElementNode"/>
/// </summary>
/// <param name="surveyTree">The owning <see cref="SurveyTree{SurveyContextType}"/> container</param>
/// <param name="survey">The <see cref="Survey"/> this node is associated with</param>
/// <param name="contextElement">The parent element, or null for a root expansion context</param>
/// <param name="element">The element to create a node for</param>
/// <returns>A fully initialized <see cref="SampleDataElementNode"/>.</returns>
public static SampleDataElementNode Create(SurveyTree <SurveyContextType> surveyTree, Survey survey, object contextElement, object element)
{
return(new SampleDataElementNode(surveyTree, contextElement, element, InitializeNodeData(element, contextElement, survey), null, null, true));
}
public static Survey CreateSurveyFromForm(SurveyForm thisForm)
{
Survey survey = new Survey();
survey.SurveyAnswers = new List <SurveyAnswer>();
survey.SeqLNr = GetNewSeqLNr();
survey.Dat = DateTime.Now.Date;
survey.Typ = thisForm.Typ;
int subnr = 0;
switch (survey.Typ.ToLower())
{
case "hla":
survey.TypDsc = "Hälsovårdskort";
break;
case "oha":
survey.TypDsc = "Munvårdskort";
break;
}
foreach (var q in thisForm.Questions)
{
subnr++;
SurveyAnswer newAnswer = new SurveyAnswer();
newAnswer.SeqLNr = survey.SeqLNr;
newAnswer.SubNr = subnr;
newAnswer.Dsc = q.Dsc;
newAnswer.KeyWrd = q.KeyWrd;
newAnswer.Man = q.Man;
newAnswer.Multi = q.Multi;
newAnswer.OhaTyp = q.OhaTyp;
newAnswer.SelList = q.SelList;
newAnswer.Sort = q.Sort;
newAnswer.SysVar = q.SysVar;
newAnswer.Txt = q.Txt;
switch (q.OhaTyp.ToLower())
{
case "sel":
newAnswer.PrmDec = q.Multi;
newAnswer.PrmChr = q.Dsc;
string[] parts = q.SelList.Split('¤');
if (parts.Length > 0)
{
for (int i = 0; i < parts.Length; i++)
{
newAnswer.PrmChr += "¤" + parts[i] + "|0";
}
}
break;
case "int":
newAnswer.PrmChr = q.Dsc + "¤0";
break;
case "chr":
newAnswer.PrmChr = q.Dsc + "¤";
break;
case "top":
newAnswer.PrmChr = q.Dsc;
break;
}
survey.SurveyAnswers.Add(newAnswer);
}
return(survey);
}
public PhaseControlViewModel(Survey survey)
{
this.survey = survey;
}
public SurveyCellViewModel(Survey survey, Color backgroundColor)
{
this.survey = survey;
RaisePropertyChanged("Survey");
BackgroundColor = backgroundColor;
}
public async Task <IActionResult> CreateUpdateGrantForm(GrantFormVM data)
{
var a = data;
var userId = User.GetIdentity();
if (!string.IsNullOrEmpty(userId))
{
var user = await _context.ApplicationUser.Where(x => x.Id.Equals(userId)).FirstOrDefaultAsync();
//.Where(x => x.Id.Equals(userId)).FirstOrDefault();
if (user != null && user.CorporateId.HasValue)
{
var company = await _context.Corporates.Where(x => x.Id.Equals(user.CorporateId.Value)).FirstOrDefaultAsync();
if (company != null)
{
if (data.SurveyId == 0)
{
var survQuestions = new List <SurveyQuestion>();
foreach (var quest in data.Questions)
{
var survQuestOpts = new List <SurveyQuestionOption>();
if (quest.Type.ToLower() != "open")
{
foreach (var opt in quest.Options)
{
survQuestOpts.Add(new SurveyQuestionOption()
{
Text = opt
});
}
}
survQuestions.Add(new SurveyQuestion()
{
Type = quest.Type,
Text = quest.Text,
SurveyQuestionOptions = survQuestOpts
});
}
Survey newSurv = new Survey()
{
Title = data.Title,
CorporateId = company.Id,
CreatedOn = DateTime.Now,
CreatedBy = user.UserName,
Month = DateTime.Now.Month,
Year = DateTime.Now.Year,
SurveyQuestions = survQuestions
};
await _context.AddAsync(newSurv);
await _context.SaveChangesAsync();
return(RedirectToAction("ViewGrantForm", "Home", new { area = "Corporate", sid = newSurv.Id }));
}
else
{
var surveyQuesions = await _context.SurveyQuestions.Where(x => x.SurveyId.Equals(data.SurveyId)).ToListAsync();
//remove all and then add
foreach (var quest in surveyQuesions)
{
var questOptions = await _context.SurveyQuestionOptions.Where(x => x.SurveyQuestionId.Equals(quest.Id)).ToListAsync();
_context.SurveyQuestionOptions.RemoveRange(questOptions);
}
_context.SurveyQuestions.RemoveRange(surveyQuesions);
await _context.SaveChangesAsync();
foreach (var quest in data.Questions)
{
var survQuestOpts = new List <SurveyQuestionOption>();
if (quest.Type.ToLower() != "open")
{
foreach (var opt in quest.Options)
{
survQuestOpts.Add(new SurveyQuestionOption()
{
Text = opt
});
}
}
await _context.SurveyQuestions.AddAsync(new SurveyQuestion()
{
Type = quest.Type,
Text = quest.Text,
SurveyQuestionOptions = survQuestOpts,
SurveyId = data.SurveyId,
});
}
await _context.SaveChangesAsync();
return(RedirectToAction("ViewGrantForm", "Home", new { area = "Corporate", sid = data.SurveyId }));
}
}
}
}
return(View());
}
public IActionResult UserSurveyReports(string surveyGuid)
{
SurveyMetrics metric = new SurveyMetrics(_dBContext, _mapper);
string userguid = Request.Headers[Constants.UserToken];
string decyrptstring = Security.Decrypt(userguid);
if (string.IsNullOrEmpty(decyrptstring))
{
return(BadRequest(Messages.UnauthorizedUserError));
}
User user = _dBContext.User.Where(x => x.UserGuid == decyrptstring).FirstOrDefault();
if (user == null)
{
return(BadRequest(Messages.UserNotFoundError));
}
Survey survey = _dBContext.Survey.Where(x => x.CreatedBy == user.Userid && x.SurveyGuid == surveyGuid).FirstOrDefault();
if (survey == null)
{
return(BadRequest(Messages.SurveyNotFoundError));
}
List <SurveyQuestions> surveyQuestions = _dBContext.SurveyQuestions.Where(x => x.StatusId != (int)EnumStatus.Deleted && x.SurveyId == survey.Surveyid).ToList();
List <QuestionType> questionType = _dBContext.QuestionType.ToList();
SurveyMetricViewModel surveyMetric = new SurveyMetricViewModel();
List <QuestionMetricViewModel> questionMetrics = new List <QuestionMetricViewModel>();
foreach (var item in surveyQuestions)
{
QuestionMetricViewModel questionMetric = new QuestionMetricViewModel();
var type = questionType.Where(x => x.TypeId == item.TypeId).Select(x => x.TypeCode).FirstOrDefault();
switch (type)
{
case "radiobuttons":
questionMetric = metric.forCountAndAverage(item.SurveyQuestionId);
break;
case "multiple":
questionMetric = metric.forCountAndAverage(item.SurveyQuestionId);
break;
case "imageradiobuttons":
questionMetric = metric.forCountAndAverage(item.SurveyQuestionId);
break;
case "imagemultiple":
questionMetric = metric.forCountAndAverage(item.SurveyQuestionId);
break;
case "slider":
questionMetric = metric.forSliderAverage(item.SurveyQuestionId);
break;
case "rangeslider":
questionMetric = metric.forSliderAverage(item.SurveyQuestionId);
break;
case "starrating":
questionMetric = metric.forStarRatingAverage(item.SurveyQuestionId);
break;
case "multiplerating":
questionMetric = metric.forMultipleStarRatings(item.SurveyQuestionId);
break;
case "customrating":
questionMetric = metric.forCustomRatings(item.SurveyQuestionId);
break;
default:
break;
}
questionMetric.QuestionType = type;
questionMetric.originalQuestionOptions = _dBContext.SurveyQuestionOptions.Where(x => x.SurveyQuestionId == item.SurveyQuestionId).ToList();
questionMetrics.Add(questionMetric);
}
surveyMetric.Title = survey.Welcometitle;
surveyMetric.Description = survey.Welcomedescription;
surveyMetric.logo = survey.Welcomeimage;
surveyMetric.Questions = questionMetrics;
return(Ok(surveyMetric));
}
public IActionResult SurveyResults(Survey survey)
{
return(View("SurveyResults", survey));
}
public void SaveSurvey(Survey survey)
{
if (string.IsNullOrEmpty(survey.SlugName) && string.IsNullOrEmpty(survey.Title))
{
throw new ArgumentNullException("survey", "The survey for saving has to have the slug or the title.");
}
var slugName = string.IsNullOrEmpty(survey.SlugName) ? GenerateSlug(survey.Title, 100) : survey.SlugName;
var surveyRow = new SurveyRow
{
SlugName = slugName,
Title = survey.Title,
CreatedOn = DateTime.UtcNow,
PartitionKey = survey.Tenant
};
surveyRow.RowKey = string.Format(CultureInfo.InvariantCulture, "{0}_{1}", survey.Tenant, surveyRow.SlugName);
var questionRows = new List <QuestionRow>(survey.Questions.Count);
for (int i = 0; i < survey.Questions.Count; i++)
{
var question = survey.Questions[i];
var questionRow = new QuestionRow
{
Text = question.Text,
Type = Enum.GetName(typeof(QuestionType), question.Type),
PossibleAnswers = question.PossibleAnswers
};
questionRow.PartitionKey = surveyRow.RowKey;
questionRow.RowKey = string.Format(CultureInfo.InvariantCulture, "{0}_{1}", DateTime.UtcNow.GetFormatedTicks(), i.ToString("D3"));
questionRows.Add(questionRow);
}
//// First add the questions
this.questionTable.Add(questionRows);
try
{
//// Then add the survey
//// If this fails, the questions may end up orphan but data will be consistent for the user
this.surveyTable.Add(surveyRow);
if (this.CacheEnabled)
{
TenantCacheHelper.AddToCache(survey.Tenant, slugName, survey);
}
}
catch (DataServiceRequestException ex)
{
TraceHelper.TraceError(ex.TraceInformation());
var dataServiceClientException = ex.InnerException as DataServiceClientException;
if (dataServiceClientException != null)
{
if (dataServiceClientException.StatusCode == 409)
{
this.questionTable.Delete(questionRows);
throw;
}
}
throw;
}
}
public void AddNewSurveyForUser(Survey survey, int userID)
{
survey.UserID = userID;
_context.Survey.InsertOnSubmit(survey);
_context.SubmitChanges();
}
public IActionResult Index()
{
var survey = new Survey();
return(View(survey));
}
public IActionResult Submission(Survey mySurvey)
{
{
return(View("results", mySurvey));
}
}
public async Task Update(Survey survey)
{
var surveyEntiity = _mapper.Map <SurveyEntity>(survey);
await _service.Update(_collectionName, surveyEntiity.Id, surveyEntiity);
}
public IActionResult Index()
{
var model = new Survey();
return(View(model));
}
public void Start()
{
surveyScript = GetComponent <Survey>();
}
public IActionResult AddNewSurvey([FromBody] SurveyViewModel newSurvey)
{
string userId = Request.Headers[Constants.UserToken];
string decyrptstring = Security.Decrypt(userId);
if (decyrptstring == null)
{
return(BadRequest());
}
User user = _dBContext.User.Where(x => x.UserGuid == decyrptstring).FirstOrDefault();
if (user == null)
{
return(BadRequest(Messages.UserNotFoundError));
}
int PublishedStatusId = _dBContext.Status.Where(x => x.Statusname == "Published").Select(x => x.Statusid).FirstOrDefault();
Survey s = _mapper.Map <Survey>(newSurvey);
s.StatusId = PublishedStatusId;
s.CreatedDate = DateTime.UtcNow;
s.CreatedBy = user.Userid;
s.Enddate = DateTime.UtcNow.AddYears(1);
_dBContext.Survey.Add(s);
_dBContext.SaveChanges();
List <SurveyQuestions> qlist = new List <SurveyQuestions>();
int qcount = 0;
foreach (var item in newSurvey.SurveyQuestions)
{
SurveyQuestions question = _mapper.Map <SurveyQuestions>(item);
question.SurveyId = s.Surveyid;
question.CreatedBy = Convert.ToInt32(s.CreatedBy);
question.CreatedDate = DateTime.UtcNow;
question.StatusId = PublishedStatusId;
question.QuestionDisplayOrder = qcount;
qlist.Add(question);
qcount++;
}
_dBContext.SurveyQuestions.AddRange(qlist);
_dBContext.SaveChanges();
for (int i = 0; i < qlist.Count; i++)
{
int qid = qlist[i].SurveyQuestionId;
var options = newSurvey.SurveyQuestions[i].Options;
List <SurveyQuestionOptions> qoplist = new List <SurveyQuestionOptions>();
if (options != null)
{
foreach (var item in options)
{
SurveyQuestionOptions qop = new SurveyQuestionOptions();
qop.SurveyQuestionId = qid;
qop.OptionKey = item.Key;
qop.OptionValue = Convert.ToString(item.Value);
qop.CreatedBy = Convert.ToInt32(s.CreatedBy);
qop.CreatedDate = DateTime.UtcNow;
qoplist.Add(qop);
}
_dBContext.SurveyQuestionOptions.AddRange(qoplist);
}
_dBContext.SaveChanges();
}
return(GetSurvey(s.Surveyid));
}
public SurveyEditPage(Patient patient, Survey survey)
{
InitializeComponent();
_patient = patient;
_survey = survey;
this.Title = _patient.Dsc + " " + _patient.PNR;
foreach (var q in _survey.SurveyAnswers)
{
Label headline = new Label();
headline.Text = q.Dsc;
headline.HorizontalOptions = LayoutOptions.FillAndExpand;
stackMain.Children.Add(headline);
switch (q.OhaTyp.ToLower())
{
case "top":
headline.BackgroundColor = Color.FromRgb(135, 206, 234); // Samma som default Telerik i Carita
headline.FontSize = headline.FontSize * 1.5;
headline.FontAttributes = FontAttributes.Bold;
break;
case "sel":
headline.FontSize = headline.FontSize * 1.25;
string[] sel = q.PrmChr.Split('¤');
if (sel.Length > 1)
{
if (q.PrmDec == 0)
{
q._checks = new List <RadCheckBox>();
for (int i = 0; i < sel.Length - 1; i++)
{
StackLayout stack = new StackLayout();
stack.Orientation = StackOrientation.Horizontal;
string[] vals = sel[i + 1].Split('|');
RadCheckBox button = new RadCheckBox();
q._checks.Add(button);
button.AutomationId = vals[0] + "|" + vals[1];
if (vals[2] == "1")
{
button.IsChecked = true;
}
Label label = new Label();
label.Text = vals[0];
stack.Children.Add(button);
stack.Children.Add(label);
stackMain.Children.Add(stack);
button.IsCheckedChanged += Button_IsCheckedChanged;
}
}
else
{
q._checks = new List <RadCheckBox>();
for (int i = 0; i < sel.Length - 1; i++)
{
StackLayout stack = new StackLayout();
stack.Orientation = StackOrientation.Horizontal;
string[] vals = sel[i + 1].Split('|');
RadCheckBox button = new RadCheckBox();
q._checks.Add(button);
button.AutomationId = vals[0] + "|" + vals[1];
if (vals[2] == "1")
{
button.IsChecked = true;
}
Label label = new Label();
label.Text = vals[0];
stack.Children.Add(button);
stack.Children.Add(label);
stackMain.Children.Add(stack);
}
}
}
break;
case "chr":
headline.FontSize = headline.FontSize * 1.25;
Editor editor = new Editor();
q._editor = editor;
editor.HorizontalOptions = LayoutOptions.FillAndExpand;
editor.HeightRequest = 80;
editor.Text = q.TextBoxText;
stackMain.Children.Add(editor);
break;
case "int":
headline.FontSize = headline.FontSize * 1.25;
RadNumericInput numeric = new RadNumericInput();
q._numeric = numeric;
numeric.Value = q.NumericValue;
numeric.HorizontalOptions = LayoutOptions.Start;
stackMain.Children.Add(numeric);
break;
case "tooth":
headline.FontSize = headline.FontSize * 1.25;
q._images = new List <Image>();
Grid outerGrid = new Grid();
outerGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
outerGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
outerGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
outerGrid.RowDefinitions.Add(new RowDefinition()
{
Height = GridLength.Auto
});
outerGrid.RowDefinitions.Add(new RowDefinition()
{
Height = GridLength.Auto
});
outerGrid.RowDefinitions.Add(new RowDefinition()
{
Height = GridLength.Auto
});
Label newLabel;
newLabel = new Label()
{
Text = "ÖK", HorizontalTextAlignment = TextAlignment.Center
};
Grid.SetColumn(newLabel, 1);
Grid.SetRow(newLabel, 0);
outerGrid.Children.Add(newLabel);
newLabel = new Label()
{
Text = "UK", HorizontalTextAlignment = TextAlignment.Center
};
Grid.SetColumn(newLabel, 1);
Grid.SetRow(newLabel, 2);
outerGrid.Children.Add(newLabel);
newLabel = new Label()
{
Text = "HÖ", VerticalTextAlignment = TextAlignment.Center
};
Grid.SetColumn(newLabel, 0);
Grid.SetRow(newLabel, 1);
outerGrid.Children.Add(newLabel);
newLabel = new Label()
{
Text = "VÄ", VerticalTextAlignment = TextAlignment.Center
};
Grid.SetColumn(newLabel, 2);
Grid.SetRow(newLabel, 1);
outerGrid.Children.Add(newLabel);
StackLayout innerStack = new StackLayout()
{
Orientation = StackOrientation.Vertical
};
Grid.SetColumn(innerStack, 1);
Grid.SetRow(innerStack, 1);
outerGrid.Children.Add(innerStack);
Grid newGrid = new Grid()
{
ColumnSpacing = 0, RowSpacing = 0
};
newGrid.RowDefinitions.Add(new RowDefinition());
for (int i = 0; i < 16; i++)
{
newGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
}
Image newImg;
for (int i = 0; i < 16; i++)
{
newImg = new Image()
{
Source = ImageSource.FromResource("CaritaUAT.Icons.t" + i.ToString() + ".png", typeof(Patient).GetTypeInfo().Assembly)
};
Grid.SetColumn(newImg, i);
newGrid.Children.Add(newImg);
switch (q.PrmChr.Substring(i, 1))
{
case "0":
// Vit
newImg.BackgroundColor = Color.White;
break;
case "1":
// Röd
newImg.BackgroundColor = Color.Red;
break;
case "2":
// Blå
newImg.BackgroundColor = Color.Blue;
break;
case "3":
// Svart
newImg.BackgroundColor = Color.Black;
break;
}
TapGestureRecognizer newTap = new TapGestureRecognizer()
{
NumberOfTapsRequired = 1
};
newTap.Tapped += NewTap_Tapped;
newImg.GestureRecognizers.Add(newTap);
q._images.Add(newImg);
}
innerStack.Children.Add(newGrid);
newGrid = new Grid()
{
ColumnSpacing = 0, RowSpacing = 0
};
newGrid.RowDefinitions.Add(new RowDefinition());
for (int i = 0; i < 16; i++)
{
newGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
}
for (int i = 0; i < 16; i++)
{
newImg = new Image()
{
Source = ImageSource.FromResource("CaritaUAT.Icons.t" + (i + 16).ToString() + ".png", typeof(Patient).GetTypeInfo().Assembly)
};
Grid.SetColumn(newImg, i);
newGrid.Children.Add(newImg);
switch (q.PrmChr.Substring(i + 16, 1))
{
case "0":
// Vit
newImg.BackgroundColor = Color.White;
break;
case "1":
// Röd
newImg.BackgroundColor = Color.Red;
break;
case "2":
// Blå
newImg.BackgroundColor = Color.Blue;
break;
case "3":
// Svart
newImg.BackgroundColor = Color.Black;
break;
}
TapGestureRecognizer newTap = new TapGestureRecognizer()
{
NumberOfTapsRequired = 1
};
newTap.Tapped += NewTap_Tapped;
newImg.GestureRecognizers.Add(newTap);
q._images.Add(newImg);
}
innerStack.Children.Add(newGrid);
stackMain.Children.Add(outerGrid);
newGrid = new Grid();
newGrid.RowDefinitions.Add(new RowDefinition());
newGrid.RowDefinitions.Add(new RowDefinition());
newGrid.RowDefinitions.Add(new RowDefinition());
newGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
newGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
BoxView newBox;
newBox = new BoxView()
{
BackgroundColor = Color.Red, WidthRequest = 16, HeightRequest = 16
};
Grid.SetRow(newBox, 0);
Grid.SetColumn(newBox, 0);
newGrid.Children.Add(newBox);
newBox = new BoxView()
{
BackgroundColor = Color.Blue, WidthRequest = 16, HeightRequest = 16
};
Grid.SetRow(newBox, 1);
Grid.SetColumn(newBox, 0);
newGrid.Children.Add(newBox);
newBox = new BoxView()
{
BackgroundColor = Color.Black, WidthRequest = 16, HeightRequest = 16
};
Grid.SetRow(newBox, 2);
Grid.SetColumn(newBox, 0);
newGrid.Children.Add(newBox);
newLabel = new Label()
{
Text = "Avtagbart"
};
Grid.SetRow(newLabel, 0);
Grid.SetColumn(newLabel, 1);
newGrid.Children.Add(newLabel);
newLabel = new Label()
{
Text = "Fastsittande tänder"
};
Grid.SetRow(newLabel, 1);
Grid.SetColumn(newLabel, 1);
newGrid.Children.Add(newLabel);
newLabel = new Label()
{
Text = "Saknad tand"
};
Grid.SetRow(newLabel, 2);
Grid.SetColumn(newLabel, 1);
newGrid.Children.Add(newLabel);
stackMain.Children.Add(newGrid);
break;
}
}
}
public IActionResult GetSurveyUserFeedback(string surveyUserGuid)
{
SurveyViewModel surview = new SurveyViewModel();
string userguid = Request.Headers[Constants.UserToken];
string decyrptstring = Security.Decrypt(userguid);
if (string.IsNullOrEmpty(decyrptstring))
{
return(BadRequest(Messages.UnauthorizedUserError));
}
User user = _dBContext.User.Where(x => x.UserGuid == decyrptstring).FirstOrDefault();
if (user == null)
{
return(BadRequest(Messages.UserNotFoundError));
}
SurveyUser surveyuser = _dBContext.SurveyUser.Where(x => x.SurveyUserGuid == surveyUserGuid).FirstOrDefault();
if (surveyuser == null)
{
return(BadRequest(Messages.SurveyUserNotFoundError));
}
Survey survey = _dBContext.Survey.Where(x => x.CreatedBy == user.Userid && x.Surveyid == surveyuser.SurveyId).FirstOrDefault();
if (survey == null)
{
return(BadRequest(Messages.SurveyNotFoundError));
}
surview = _mapper.Map <SurveyViewModel>(survey);
List <SurveyQuestions> surveyQuestions = _dBContext.SurveyQuestions.Where(x => x.StatusId != (int)EnumStatus.Deleted && x.SurveyId == survey.Surveyid).ToList();
List <QuestionType> questiontypes = _dBContext.QuestionType.ToList();
List <SurveyQuestionsViewModel> viewquestions = new List <SurveyQuestionsViewModel>();
foreach (var item in surveyQuestions)
{
SurveyQuestionsViewModel viewquestion = _mapper.Map <SurveyQuestionsViewModel>(item);
List <SurveyUserQuestionOptions> surveyuserquestionoptions = new List <SurveyUserQuestionOptions>();
List <string> selectedoptions = new List <string>();
string optiontypevalue = null;
List <SurveyQuestionOptions> options = new List <SurveyQuestionOptions>();
options = _dBContext.SurveyQuestionOptions.Where(x => x.SurveyQuestionId == item.SurveyQuestionId).OrderBy(x => x.OptionKey).ToList();
surveyuserquestionoptions = _dBContext.SurveyUserQuestionOptions.Where(x => x.SurveyQuestionId == item.SurveyQuestionId && x.SurveyUserId == surveyuser.SurveyUserId).ToList();
if (questiontypes != null)
{
optiontypevalue = questiontypes.FirstOrDefault(x => x.TypeId == item.TypeId).TypeValue;
}
if (surveyuserquestionoptions != null)
{
foreach (var itemq in surveyuserquestionoptions)
{
string option = null;
option = itemq.SurveyQuestionOptionId;
selectedoptions.Add(option);
}
}
Dictionary <string, object> dict = new Dictionary <string, object>();
foreach (var opt in options)
{
dict.Add(opt.OptionKey, opt.OptionValue);
}
viewquestion.Options = dict;
viewquestion.ObjectOptions = options;
viewquestion.questiontype = optiontypevalue;
viewquestion.selectedValues = selectedoptions;
viewquestions.Add(viewquestion);
}
surview.SurveyQuestions = viewquestions;
return(Ok(surview));
}
public Flow(string name, Survey survey)
{
this.name = name;
this.inputSurvey = survey;
}
public MainWindow()
{
InitializeComponent();
Survey = StoreFitsData.Survey;
this.DataContext = Survey;
}
/// <summary>
///
/// </summary>
/// <param name="survey"></param>
/// <param name="code"></param>
/// <returns></returns>
public async Task <Shortcode> GetShortcodeForSurveyAsync(Survey survey, string code)
{
return(await _appContext.Shortcodes
.Where(s => s.Survey == survey && s.Code == code).FirstOrDefaultAsync());
}
private void ProcessSurvey(IServiceScope scope, ApplicationDbContext context, Survey item)
{
try
{
var survey = item;
context.Surveys.Add(survey);
context.Entry(survey).State = EntityState.Added;
context.SaveChanges();
var x = this.Queue.DequeueAsync(new CancellationToken()).Result;
}
catch (Exception e)
{
log.Trace($"Error in item {e} - {item}");
}
}
public void NewWhenHttpVerbIsPostReturnsRedirectToMySurveysWhenModelStateIsValid()
{
var cachedSurvey = new Survey();
cachedSurvey.Questions.Add(new Question());
using (var controller = new SurveysController(new Mock<ISurveyStore>().Object, null, null, null, null, null))
{
controller.TenantName = "Tenant";
controller.Tenant = new Tenant() { SubscriptionKind = SubscriptionKind.Standard };
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
var result = controller.New(new Survey()) as RedirectToRouteResult;
Assert.AreEqual("Index", result.RouteValues["action"]);
Assert.AreEqual(null, result.RouteValues["controller"]);
}
}
protected void DvItemCommand(object sender, DetailsViewCommandEventArgs e)
{
string returnURL = "~/ControlRoom/Modules/Setup/SurveyList.aspx";
if (e.CommandName.ToLower() == "back")
{
Response.Redirect(returnURL);
}
if (e.CommandName.ToLower() == "refresh")
{
try
{
odsData.DataBind();
dv.DataBind();
dv.ChangeMode(DetailsViewMode.Edit);
var masterPage = (IControlRoomMaster)Master;
if (masterPage != null)
{
masterPage.PageMessage = SRPResources.RefreshOK;
}
}
catch (Exception ex)
{
var masterPage = (IControlRoomMaster)Master;
masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message);
}
}
if (e.CommandName.ToLower() == "add" || e.CommandName.ToLower() == "addandback")
{
try
{
var obj = new Survey();
//obj.GenNotificationFlag = ((CheckBox)((DetailsView)sender).FindControl("TabContainer1").FindControl("TabPanel2").FindControl("GenNotificationFlag")).Checked;
obj.Name = ((TextBox)((DetailsView)sender).FindControl("Name")).Text;
obj.LongName = ((TextBox)((DetailsView)sender).FindControl("LongName")).Text;
obj.Description = ((TextBox)((DetailsView)sender).FindControl("Description")).Text;
obj.Preamble = ((CKEditor.NET.CKEditorControl)((DetailsView)sender).FindControl("Preamble")).Text;
obj.Status = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("Status")).SelectedValue);
//obj.TakenCount = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("TakenCount")).Text);
//obj.PatronCount = FormatHelper.SafeToInt(((TextBox)((DetailsView)sender).FindControl("PatronCount")).Text);
//obj.CanBeScored = ((CheckBox)((DetailsView)sender).FindControl("CanBeScored")).Checked;
if (obj.IsValid(BusinessRulesValidationMode.INSERT))
{
obj.Insert();
if (e.CommandName.ToLower() == "addandback")
{
Response.Redirect(returnURL);
}
lblPK.Text = obj.SID.ToString();
Session["SID"] = obj.SID;
odsData.DataBind();
dv.DataBind();
dv.ChangeMode(DetailsViewMode.Edit);
var masterPage = (IControlRoomMaster)Master;
masterPage.PageMessage = SRPResources.AddedOK;
}
else
{
var masterPage = (IControlRoomMaster)Master;
string message = String.Format(SRPResources.ApplicationError1, "<ul>");
foreach (BusinessRulesValidationMessage m in obj.ErrorCodes)
{
message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage);
}
message = string.Format("{0}</ul>", message);
masterPage.PageError = message;
}
}
catch (Exception ex)
{
var masterPage = (IControlRoomMaster)Master;
masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message);
}
}
if (e.CommandName.ToLower() == "save" || e.CommandName.ToLower() == "saveandback" || e.CommandName.ToLower() == "questions")
{
try
{
var obj = new Survey();
int pk = int.Parse(lblPK.Text);
obj.Fetch(pk);
obj.Name = ((TextBox)((DetailsView)sender).FindControl("Name")).Text;
obj.LongName = ((TextBox)((DetailsView)sender).FindControl("LongName")).Text;
obj.Description = ((TextBox)((DetailsView)sender).FindControl("Description")).Text;
obj.Preamble = ((CKEditor.NET.CKEditorControl)((DetailsView)sender).FindControl("Preamble")).Text;
obj.Status = FormatHelper.SafeToInt(((DropDownList)((DetailsView)sender).FindControl("Status")).SelectedValue);
if (obj.IsValid(BusinessRulesValidationMode.UPDATE))
{
obj.Update();
if (e.CommandName.ToLower() == "saveandback")
{
Response.Redirect(returnURL);
}
if (e.CommandName.ToLower() == "questions")
{
Response.Redirect("~/ControlRoom/Modules/Setup/SurveyQuestionList.aspx");
}
odsData.DataBind();
dv.DataBind();
dv.ChangeMode(DetailsViewMode.Edit);
var masterPage = (IControlRoomMaster)Master;
masterPage.PageMessage = SRPResources.SaveOK;
}
else
{
var masterPage = (IControlRoomMaster)Master;
string message = String.Format(SRPResources.ApplicationError1, "<ul>");
foreach (BusinessRulesValidationMessage m in obj.ErrorCodes)
{
message = string.Format(String.Format("{0}<li>{{0}}</li>", message), m.ErrorMessage);
}
message = string.Format("{0}</ul>", message);
masterPage.PageError = message;
}
}
catch (Exception ex)
{
var masterPage = (IControlRoomMaster)Master;
masterPage.PageError = String.Format(SRPResources.ApplicationError1, ex.Message);
}
}
if (e.CommandName.ToLower() == "results")
{
Response.Redirect("SurveyResults.aspx");
}
if (e.CommandName.ToLower() == "embed")
{
Response.Redirect("SurveyEmbedCode.aspx");
}
}
public void NewWhenHttpVerbIsPostSavedTenantNameIsSameAsControllerWhenModelStateIsValid()
{
var mockSurveyStore = new Mock<ISurveyStore>();
var cachedSurvey = new Survey();
cachedSurvey.Questions.Add(new Question());
using (var controller = new SurveysController(mockSurveyStore.Object, null, null, null, null, null))
{
controller.TenantName = "Tenant";
controller.Tenant = new Tenant() { SubscriptionKind = SubscriptionKind.Standard };
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
controller.New(new Survey());
}
mockSurveyStore.Verify(r => r.SaveSurvey(It.Is<Survey>(s => s.Tenant == "Tenant")), Times.Once());
}
public void Results_PublicResultsAnonymousUser_ReturnsViewWithViewModelWithNoComments()
{
var id = Guid.NewGuid();
var survey = new Survey()
{
Id = id, PublicResults = true, Owner = new ApplicationUser()
{
UserName = "******"
}
};
var moods = new[] { new Models.Mood()
{
Id = 1
}, new Models.Mood()
{
Id = 2
} };
var answer1 = new Answer()
{
MoodId = 1, SurveyId = id, Details = "I am very angry"
};
var answer2 = new Answer()
{
MoodId = 2, SurveyId = id, Details = "I am very happy"
};
var answers = new List <Answer>()
{
answer1, answer2
};
var surveysMock = new Mock <ISurveyService>();
surveysMock.Setup(s => s.FindAsync(id.ToString())).ReturnsAsync(survey);
var dbMock = new Mock <IApplicationDBContext>();
var moodDataMock = new Mock <DbSet <Models.Mood> >().SetupData(moods);
var answerDataMock = new Mock <DbSet <Answer> >().SetupData(answers);
dbMock.Setup(db => db.Moods).Returns(moodDataMock.Object);
dbMock.Setup(db => db.Answers).Returns(answerDataMock.Object);
var securityMock = new Mock <ISecurity>();
securityMock.SetupGet(s => s.UserName).Returns("Peter");
securityMock.SetupGet(s => s.IsAuthenticated).Returns(true);
var subject = new AnswerController(dbMock.Object, surveysMock.Object, Mock.Of <IDateTimeService>(), securityMock.Object);
var result = subject.Results(id.ToString()).Result;
Assert.IsInstanceOfType(result, typeof(ViewResult));
var model = (result as ViewResult).Model as ResultsViewModel;
Assert.IsNotNull(model);
Assert.AreSame(survey, model.Survey);
Assert.AreEqual(2, model.Answers.Count());
Assert.AreSame(answer1, model.Answers.ToList()[0]);
Assert.AreSame(answer2, model.Answers.ToList()[1]);
Assert.IsNull(model.Answers.ToList()[0].Details);
Assert.IsNull(model.Answers.ToList()[1].Details);
}
/// <summary>
/// Initialize the node answer cache
/// </summary>
/// <param name="element">The element to query</param>
/// <param name="contextElement">The context element for this node</param>
/// <param name="survey">The <see cref="Survey"/>s to initialize the node for</param>
/// <returns>Packed bitfield integer containing all current answers</returns>
private static int InitializeNodeData(object element, object contextElement, Survey survey)
{
int data = 0;
int questionCount = survey.Count;
for (int i = 0; i < questionCount; ++i)
{
SurveyQuestion currentQuestion = survey[i];
int currentAnswer = currentQuestion.Question.AskQuestion(element, contextElement);
data |= (currentAnswer << currentQuestion.Shift) & currentQuestion.Mask;
}
return(data);
}
public async Task <IActionResult> Post([FromBody] Survey value)
{
_surveys.Add(value);
return(Ok());
}
public ActionResult Delete(Survey survey)
{
_db.Entry(survey).State = EntityState.Deleted;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public void NewWhenHttpVerbIsPostReturnsTitleInTheModelWhenModelStateIsNotValid()
{
var survey = new Survey();
using (var controller = new SurveysController(new Mock<ISurveyStore>().Object, null, null, null, null, null))
{
controller.ModelState.AddModelError("error for test", "invalid model state");
controller.TempData[SurveysController.CachedSurvey] = new Survey();
var result = controller.New(survey) as ViewResult;
var model = result.ViewData.Model as TenantMasterPageViewData;
Assert.AreSame("New Survey", model.Title);
}
}
public Survey4(Survey s)
{
InitializeComponent();
survey = s;
}
public void NewWhenHttpVerbIsPostSavesCachedSurveyInTempDataWhenCachedSurveyHasNoQuestions()
{
var cachedSurvey = new Survey { Questions = new List<Question>() };
using (var controller = new SurveysController(new Mock<ISurveyStore>().Object, null, null, null, null, null))
{
controller.TempData[SurveysController.CachedSurvey] = cachedSurvey;
var result = controller.New(new Survey()) as ViewResult;
var model = result.ViewData.Model as TenantPageViewData<Survey>;
Assert.AreSame(cachedSurvey, controller.TempData[SurveysController.CachedSurvey]);
}
}
public IActionResult SubmitSurvey(string guid, string session, QuestionAnswersRequestViewModel data)
{
List <QuestionAnswersViewModel> jObject = data.data;
Survey sur = _dBContext.Survey.Where(x => x.SurveyGuid == guid).FirstOrDefault();
if (sur == null)
{
return(BadRequest(Messages.SurveyNotFoundError));
}
if (sur.Enddate < DateTime.UtcNow)
{
return(BadRequest(Messages.SurveyEnded));
}
var surveyUsers = _dBContext.SurveyUser.Where(x => x.SurveyId == sur.Surveyid && x.SurveyUserGuid.Equals(session)).FirstOrDefault();
if (surveyUsers == null)
{
return(BadRequest(Messages.SurveyWasNotStartedByUser));
}
if (surveyUsers.CompletedDatetime != null)
{
return(BadRequest(Messages.SurveyWasAlreadySubmitted));
}
List <SurveyQuestions> questions = _dBContext.SurveyQuestions.Where(x => x.SurveyId == sur.Surveyid && x.StatusId != (int)EnumStatus.Deleted).ToList();
List <QuestionType> lstQuestionTypes = _dBContext.QuestionType.ToList();
List <SurveyUserQuestionOptions> lstSurveyUserQuestionOptions = new List <SurveyUserQuestionOptions>();
for (int i = 0; i < questions.Count; i++)
{
SurveyUserQuestionOptions surveyUserQuestionOption = new SurveyUserQuestionOptions();
surveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
surveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
surveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
QuestionAnswersViewModel requestViewModel = jObject.Where(x => x.key == questions[i].SurveyQuestionId.ToString()).FirstOrDefault();
List <SurveyQuestionOptions> surveyQuestionOptions = _dBContext.SurveyQuestionOptions.Where(x => x.SurveyQuestionId == surveyUserQuestionOption.SurveyQuestionId).OrderBy(x => x.OptionKey).ToList();
var questionTypeCode = lstQuestionTypes.Where(x => x.TypeId == questions[i].TypeId).FirstOrDefault().TypeCode;
bool addToList = true;
int tempNumber = 0;
switch (questionTypeCode)
{
case "essay":
surveyUserQuestionOption.CustomAnswer = requestViewModel.text;
break;
case "radiobuttons":
surveyUserQuestionOption.SurveyQuestionOptionId = requestViewModel.number.ToString();
break;
case "imageradiobuttons":
surveyUserQuestionOption.SurveyQuestionOptionId = requestViewModel.number.ToString();
break;
case "multiple":
foreach (var item in requestViewModel.selected)
{
SurveyUserQuestionOptions tempSurveyUserQuestionOption = new SurveyUserQuestionOptions();
tempSurveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
tempSurveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
tempSurveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
tempSurveyUserQuestionOption.SurveyQuestionOptionId = item;
lstSurveyUserQuestionOptions.Add(tempSurveyUserQuestionOption);
}
addToList = false;
break;
case "imagemultiple":
foreach (var item in requestViewModel.selected)
{
SurveyUserQuestionOptions tempSurveyUserQuestionOption = new SurveyUserQuestionOptions();
tempSurveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
tempSurveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
tempSurveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
tempSurveyUserQuestionOption.SurveyQuestionOptionId = item;
lstSurveyUserQuestionOptions.Add(tempSurveyUserQuestionOption);
}
addToList = false;
break;
case "slider":
surveyUserQuestionOption.SurveyQuestionOptionId = requestViewModel.number.ToString();
break;
case "rangeslider":
int j = 0;
foreach (var item in requestViewModel.selected)
{
SurveyUserQuestionOptions tempSurveyUserQuestionOption = new SurveyUserQuestionOptions();
tempSurveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
tempSurveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
tempSurveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
tempSurveyUserQuestionOption.SurveyQuestionOptionId = item;
tempSurveyUserQuestionOption.CustomAnswer = j == 0 ? "min" : "max";
lstSurveyUserQuestionOptions.Add(tempSurveyUserQuestionOption);
j++;
}
addToList = false;
break;
case "starrating":
surveyUserQuestionOption.SurveyQuestionOptionId = requestViewModel.number.ToString();
break;
case "multiplerating":
foreach (var item in requestViewModel.selected)
{
SurveyUserQuestionOptions tempSurveyUserQuestionOption = new SurveyUserQuestionOptions();
tempSurveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
tempSurveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
tempSurveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
tempSurveyUserQuestionOption.SurveyQuestionOptionId = surveyQuestionOptions[tempNumber].SurveyQuestionOptionId.ToString();
tempSurveyUserQuestionOption.CustomAnswer = item;
lstSurveyUserQuestionOptions.Add(tempSurveyUserQuestionOption);
tempNumber++;
}
addToList = false;
break;
case "customrating":
var surveyQuestionOptionsValues = surveyQuestionOptions.Where(x => x.OptionKey.StartsWith("value")).OrderBy(x => x.OptionKey).ToList();
foreach (var item in requestViewModel.selected)
{
SurveyUserQuestionOptions tempSurveyUserQuestionOption = new SurveyUserQuestionOptions();
tempSurveyUserQuestionOption.SurveyUserId = surveyUsers.SurveyUserId;
tempSurveyUserQuestionOption.SurveyQuestionId = questions[i].SurveyQuestionId;
tempSurveyUserQuestionOption.InsertedDatetime = DateTime.UtcNow;
tempSurveyUserQuestionOption.SurveyQuestionOptionId = surveyQuestionOptionsValues[tempNumber].SurveyQuestionOptionId.ToString();
tempSurveyUserQuestionOption.CustomAnswer = item;
lstSurveyUserQuestionOptions.Add(tempSurveyUserQuestionOption);
tempNumber++;
}
addToList = false;
break;
default:
surveyUserQuestionOption.CustomAnswer = requestViewModel.text;
break;
}
if (addToList)
{
lstSurveyUserQuestionOptions.Add(surveyUserQuestionOption);
}
}
_dBContext.SurveyUserQuestionOptions.AddRange(lstSurveyUserQuestionOptions);
surveyUsers.CompletedDatetime = DateTime.UtcNow;
_dBContext.Update(surveyUsers);
_dBContext.SaveChanges();
return(Ok());
}
public string GetStorageKeyFor(Survey survey)
{
var slugName = string.IsNullOrEmpty(survey.SlugName) ? GenerateSlug(survey.Title, 100) : survey.SlugName;
return(string.Format(CultureInfo.InvariantCulture, "{0}_{1}", survey.Tenant, slugName));
}
private async void SaveData_Activated(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(questionEntry.Text) || questionEntry.Text.Contains("~"))
{
checkinputs.Text = Lang.Resource.check_inputsSignin3;
return;
}
Text_Question question = new Text_Question(TypeQuestion.Text, questionEntry.Text);
question.Initialize(TypeQuestion.Text, questionEntry.Text, switchAnswer.IsToggled, " ");
// Store Data in File Of Survey
folder = FileSystem.Current.LocalStorage;
username = await controlFile.GetUserName();
folder = await folder.CreateFolderAsync("foldersurveys" + username, CreationCollisionOption.OpenIfExists);
file = await folder.CreateFileAsync("filesurveys" + username, CreationCollisionOption.OpenIfExists);
string content = await file.ReadAllTextAsync();
ListSurveys = Serializable_Survey.deserialize(content);
if (_questionSelected != null)
{
foreach (Survey S in ListSurveys)
{
if (S.Id == survey.Id)
{
Text_Question questionText = new Text_Question(TypeQuestion.Text, questionEntry.Text);
questionText.Initialize(TypeQuestion.Text, questionEntry.Text, switchAnswer.IsToggled, " ");
(S.Questions_Property.ElementAt(_index) as Text_Question).Edit_Question(questionText);
survey = S;
break;
}
}
}
else
{
foreach (Survey S in ListSurveys)
{
if (S.Id == survey.Id)
{
S.Questions_Property.Add(question);
survey = S;
break;
}
}
}
if (CheckNetwork.Check_Connectivity())
{
SurveysServices S_S = new SurveysServices();
S_S.Set_UrlApi("EditSurveys/" + username);
await S_S.PutSurveysAsync(survey);
}
content = Serializable_Survey.serialize(ListSurveys.ToList());
await file.WriteAllTextAsync(content);
await Navigation.PopModalAsync();
}