private void BindData()
{
var _VoteQuestion = new VoteQuestion();
rptList.DataSource = _VoteQuestion.GetList(AppUtils.Request("id"));
rptList.DataBind();
}
public VoteListPage(int argc)
{
InitializeComponent();
ARGC = argc;
Console.WriteLine(ARGC);
var VoteQuestionQuery = App.database.GetVoteQuestions(1);
Console.WriteLine("Questions Read, Nr: " + VoteQuestionQuery.Count());
var VoteQuestionList = new List <VoteQuestion>();
TGR = new TapGestureRecognizer();
TGR.Tapped += (s, e) => {
IsEnabled = false;
LoadVoteQuestion(s, e);
IsEnabled = true;
};
foreach (VoteQuestionTable VQ in VoteQuestionQuery)
{
var VoteQ = new VoteQuestion(VQ);
VoteQuestionList.Add(VoteQ);
Console.WriteLine("Question Nr: " + VoteQ.VQ.Question);
VotesGrid.RowDefinitions.Add(new RowDefinition {
Height = GridLength.Auto
});
VotesGrid.RowSpacing = 5;
VotesGrid.Children.Add(VoteQ.Box, 0, 3, Rownr, Rownr + 1);
VotesGrid.Children.Add(VoteQ.Label, 0, 3, Rownr, Rownr + 1);
Rownr++;
}
}
public static VoteQuestion GetVoteQuestionBySlug(this AppDbContext context, string slug)
{
VoteQuestion voteQuestion =
context.VoteQuestions.Include(x => x.Options).FirstOrDefault(x => x.Slug == slug);
return(voteQuestion);
}
public void Test_41247396()
{
Mapper.Initialize(config => {
config.CreateMap <VoteAnswerOption, VoteAnswerOptionViewModel>().ReverseMap();
config.CreateMap <VoteQuestion, CreateVoteQuestionViewModel>()
.ForMember(dest => dest.PossibleAnswers,
opts => opts.MapFrom(src => src.VoteAnswerOptions));
config.CreateMap <CreateVoteQuestionViewModel, VoteQuestion>()
.ForMember(dest => dest.VoteAnswerOptions,
opts => opts.MapFrom(src => src.PossibleAnswers));
});
var voteQuestion = new VoteQuestion {
VoteAnswerOptions = new List <VoteAnswerOption> {
new VoteAnswerOption {
Answer = "Correct"
}
}
};
var newQuestion = Mapper.Map <VoteQuestion, CreateVoteQuestionViewModel>(voteQuestion);
newQuestion.PossibleAnswers.Count.Should().Be(1);
newQuestion.PossibleAnswers.Single().Answer.Should().Be("Correct");
var vm = new CreateVoteQuestionViewModel {
PossibleAnswers = new List <VoteAnswerOptionViewModel> {
new VoteAnswerOptionViewModel {
Answer = "Spot on"
}
}
};
var q = Mapper.Map <CreateVoteQuestionViewModel, VoteQuestion>(vm);
q.VoteAnswerOptions.Count.Should().Be(1);
q.VoteAnswerOptions.Single().Answer.Should().Be("Spot on");
}
public void VoteOnQuestion(VoteQuestion v)
{
Question q = _ctx.Questions.FirstOrDefault(x => x.Id == v.QuestionId);
q.Popularity += v.Value;
_ctx.Questions.Update(q);
_ctx.SaveChanges();
}
public static void UpdateVoteQuestion(this AppDbContext context, ViewModels.VoteQuestion voteQuestion)
{
VoteQuestion _voteQuestion = context.VoteQuestions.FirstOrDefault(x => x.Slug == voteQuestion.slug);
_voteQuestion.Question = voteQuestion.question;
_voteQuestion.Title = voteQuestion.title;
context.VoteQuestions.Update(_voteQuestion);
context.SaveChanges();
}
public static void VoteQuestionNew()
{
Guid subId = SessionHelper.GetSession(SessionKey.SubDomain) == string.Empty ? Guid.Empty : new Guid(SessionHelper.GetSession(SessionKey.SubDomain));
VoteQuestion item = new VoteQuestion();
item.Id = Guid.NewGuid();
item.SubDomainId = subId;
PSCDialog.DataShare = new VoteQuestionArgs(item, false);
}
/// <summary>
/// Update region
/// </summary>
/// <param name="context"></param>
/// <param name="regionInfo"></param>
public static void UpdateSeedVoteQuestionInfo(this AppDbContext context, ViewModels.VoteQuestion voteQuestionInfo)
{
VoteQuestion voteQuestion = context.GetVoteQuestionBySlug(voteQuestionInfo.slug);
if (voteQuestion == null)
{
context.AddInitialVoteQuestion(voteQuestionInfo);
}
else
{
voteQuestion.Question = voteQuestionInfo.question;
voteQuestion.Title = voteQuestionInfo.title;
// update the options.
if (voteQuestion.Options != null)
{
// first pass to add new items.
foreach (var option in voteQuestionInfo.options)
{
VoteOption voteOption = voteQuestion.Options.FirstOrDefault(x => x != null && x.Option.Equals(option.option));
if (voteOption == null)
{
voteQuestion.Options.Add(option.ToModel());
}
else
{
voteOption.DisplayOrder = option.displayOrder;
}
}
List <VoteOption> itemsToRemove = new List <VoteOption>();
// second pass to identify items that are no longer present.
foreach (var option in voteQuestion.Options)
{
if (option != null)
{
if (voteQuestionInfo.options.FirstOrDefault(x => x != null && x.option.Equals(option.Option)) == null)
{
itemsToRemove.Add(option);
}
}
}
// third pass to remove the items.
foreach (var option in itemsToRemove)
{
voteQuestion.Options.Remove(option);
}
}
context.VoteQuestions.Update(voteQuestion);
context.SaveChanges();
}
}
public IActionResult VoteQuestion([FromForm] VoteQuestion r)
{
_service.VoteOnQuestion(r);
var origQ = _service.GetQuestionById(r.QuestionId);
var qResponses = _service.GetRelatedResponses(origQ.Id);
var viewQuestion = new QuestionForView
{
Id = origQ.Id,
Title = origQ.Title,
Body = origQ.Body,
UserId = origQ.UserId,
Popularity = origQ.Popularity,
Responses = qResponses
};
return(View("Details", viewQuestion));
}
/// <summary>
/// Adds a jurisdiction to the system, only if it does not exist.
/// </summary>
private static void AddInitialVoteQuestion(this AppDbContext context, ViewModels.VoteQuestion initialVoteQuestion)
{
VoteQuestion voteQuestion = context.GetVoteQuestionBySlug(initialVoteQuestion.slug);
if (voteQuestion != null)
{
return;
}
voteQuestion = new VoteQuestion
(
initialVoteQuestion.question,
initialVoteQuestion.slug,
initialVoteQuestion.title,
initialVoteQuestion.options
);
context.AddVoteQuestion(voteQuestion);
}
protected void btAdd_Click(object sender, EventArgs e)
{
var _VoteQuestion = new VoteQuestion();
int voteID = AppUtils.Request("id");
if (txtAddName.Text.Trim().Length > 0 && txtAddCount.Text.Trim().Length > 0)
{
_VoteQuestion.VoteID = voteID;
_VoteQuestion.Name = txtAddName.Text.Trim();
_VoteQuestion.Count = Convert.ToInt32(txtAddCount.Text);
_VoteQuestion.Add();
}
for (int i = 0; i < rptList.Items.Count; i++)
{
CheckBox cbxCheck = (CheckBox)rptList.Items[i].FindControl("cbxCheck");
TextBox txtUpdateName = (TextBox)rptList.Items[i].FindControl("txtName");
TextBox txtUpdateCount = (TextBox)rptList.Items[i].FindControl("txtCount");
Label lblQuestionID = (Label)rptList.Items[i].FindControl("lblQuestionID");
_VoteQuestion.QuestionID = Convert.ToInt32(lblQuestionID.Text);
if (cbxCheck.Checked)
{
_VoteQuestion.Delete();
}
else
{
_VoteQuestion = _VoteQuestion.Get();
_VoteQuestion.Name = txtUpdateName.Text.Trim();
_VoteQuestion.Count = Convert.ToInt32(txtUpdateCount.Text);
_VoteQuestion.Update();
}
}
BindData();
txtAddName.Text = "";
txtAddCount.Text = "0";
}
private void CheckAnswer()
{
VoteQuestion selectQuestion = questions[selectQuestionId];
supportRateHumanOld = supportRateHuman;
supportRateOrcOld = supportRateOrc;
supportRateElfOld = supportRateElf;
supportRateDwalfOld = supportRateDwalf;
supportRateHuman = GetNewSupportRate(supportRateHuman, MathTool.GetRandom(selectQuestion.EffHumanMin, selectQuestion.EffHumanMax));
supportRateOrc = GetNewSupportRate(supportRateOrc, MathTool.GetRandom(selectQuestion.EffOrcMin, selectQuestion.EffOrcMax));
supportRateElf = GetNewSupportRate(supportRateElf, MathTool.GetRandom(selectQuestion.EffElfMin, selectQuestion.EffElfMax));
supportRateDwalf = GetNewSupportRate(supportRateDwalf, MathTool.GetRandom(selectQuestion.EffDwalfMin, selectQuestion.EffDwalfMax));
supportRateTotal = countHuman * supportRateHuman + supportRateOrc * countOrc + supportRateElf * countElf + supportRateDwalf * countDwalf;
supportRateTotal /= (countHuman + countOrc + countElf + countDwalf);
round++;
if (round >= 10)
{
score = (int)(supportRateTotal * 100);
EndGame();
}
}
/// <summary>
/// Returns a specific VoteQuestion
/// </summary>
/// <param name="name">The name of the VoteQuestion</param>
/// <returns>The VoteQuestion, or null if it does not exist.</returns>
public static VoteQuestion GetVoteQuestionById(this AppDbContext context, string id)
{
VoteQuestion voteQuestion = context.VoteQuestions.Include(x => x.Options).FirstOrDefault(x => x.Id == new Guid(id));
return(voteQuestion);
}
public static void AddVoteQuestion(this AppDbContext context, VoteQuestion voteQuestion)
{
// create a new jurisdiction.
context.VoteQuestions.Add(voteQuestion);
context.SaveChanges();
}
public static void VoteQuestionAdd()
{
VoteQuestion question = ((VoteQuestionArgs)PSCDialog.DataShare).VoteQuestion;
VoteQuestionList.AddDB(question);
}
private void LoadData()
{
string subName = Request.Url.Host.Replace(ConfigurationManager.AppSettings["DomainName"], "");
if (subName.Length > 0)
{
subName = subName.Substring(0, subName.Length - 1);
}
SubDomain subDomain = subName == string.Empty ? SubDomain.GetSubByName("HomePage") : SubDomain.GetSubByName(subName);
if (subDomain == null)
{
voteQuestion = VoteQuestion.GetVoteQuestionActive();
}
else
{
voteQuestion = VoteQuestion.GetVoteQuestionBySubDomainActive(subDomain.Id);
}
VoteQuestionName = voteQuestion.Name;
ListVoteAnswer = VoteAnswerCollection.GetVoteAnswerCollectionByVoteQuestion(voteQuestion);
rblVoteAnswer.DataSource = ListVoteAnswer;
rblVoteAnswer.DataBind();
rblVoteAnswer.SelectedIndex = 0;
TotalVoteNumber = ListVoteAnswer.Sum(item => item.Number);
/**/
lb_TongSoPhieu.Text = "Tổng số phiếu: " + TotalVoteNumber;
lb_XemKetQua_CauHoi.Text = voteQuestion.Name;
gv_KetQua.DataSource = ListVoteAnswer;
gv_KetQua.DataBind();
}
protected override void DeleteData()
{
//using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString))
//{
// SqlCommand com = new SqlCommand();
// com.Connection = con;
// con.Open();
// com.CommandType = System.Data.CommandType.Text;
// com.Parameters.AddWithValue("@dataId", Portlet.PortletInstance.Id);
// com.CommandText = "Delete Vote Where DataId=@dataId";
//}
}
protected string ComputePercent(int SoPhieu)
{
if (TotalVoteNumber == 0)
{
return("00.00 %");
}
float percent = (float)SoPhieu / TotalVoteNumber * 100;
return(percent.ToString("00.00") + " %");
}
protected void ibt_Chon_Click(object sender, ImageClickEventArgs e)
{
if (rblVoteAnswer.SelectedIndex != -1)
{
if (Request.Cookies["Vote"] != null)
{
return;
}
HttpCookie httpCookie = new HttpCookie("Vote", "");
httpCookie.Expires = DateTime.Now.AddSeconds(60);
Response.Cookies.Add(httpCookie);
Guid selectedVote = new Guid((string)rblVoteAnswer.SelectedValue);
VoteAnswer voteAnswer = ListVoteAnswer.Where(item => ((VoteAnswer)item).Id == selectedVote).Single();
voteAnswer.Number = voteAnswer.Number + 1;
voteAnswer.Update();
TotalVoteNumber = TotalVoteNumber + 1;
/**/
lb_TongSoPhieu.Text = "Tổng số phiếu: " + TotalVoteNumber;
gv_KetQua.DataSource = ListVoteAnswer;
gv_KetQua.DataBind();
Response.Redirect(Request.Url.ToString());
}
