Task<StacManResponse<Answer>> IQuestionMethods.GetAnswers(string site, IEnumerable<int> ids, string filter = null, int? page = null, int? pagesize = null, DateTime? fromdate = null, DateTime? todate = null, Answers.Sort? sort = null, DateTime? mindate = null, DateTime? maxdate = null, int? min = null, int? max = null, Order? order = null)
{
var filterObj = ValidateAndGetFilter(filter);
ValidateString(site, "site");
ValidateEnumerable(ids, "ids");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder(String.Format("/questions/{0}/answers", String.Join(";", ids)), useHttps: false);
ub.AddParameter("site", site);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, filterObj, "/questions/{ids}/answers");
}
public static Answers KamalsAnswers()
{
Answers answers = new Answers();
answers.AddAnswer(KamalsGoodAnswer(UserMother.Kamal));
answers.AddAnswer(KamalsBadAnswer(UserMother.Kamal));
return answers;
}
Task<StacManResponse<Answer>> IAnswerMethods.GetAll(string site, string filter = null, int? page = null, int? pagesize = null, DateTime? fromdate = null, DateTime? todate = null, Answers.Sort? sort = null, DateTime? mindate = null, DateTime? maxdate = null, int? min = null, int? max = null, Order? order = null)
{
var filterObj = ValidateAndGetFilter(filter);
ValidateString(site, "site");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder("/answers", useHttps: false);
ub.AddParameter("site", site);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, filterObj, "/answers");
}
protected void Page_Load(object sender, EventArgs e)
{
_session = SamplePortal.Factory.GetWorkSession(this.Session);
if (_session == null)
Response.Redirect("Default.aspx");
_ansPath = _session.AnswerCollection.FilePath;
_ansFilename = Path.GetFileName(_ansPath);
if (!IsPostBack) // first arrival on this page
{
// Set the max length on the title and description fields. These were previously set in the ASPX page,
// but ASP.NET drops them for multi-line fields when rendering the page.
// So we set them manually here using values configurable in the web.config.
txtTitle.Attributes.Add("maxlength", Settings.MaxTitleLength.ToString());
txtDescription.Attributes.Add("maxlength", Settings.MaxDescriptionLength.ToString());
ViewState["answers"] = HotDocs.Sdk.Server.InterviewResponse.GetAnswers(Request.Form); // get the answers from the browser
if (_session.AnswerCollection.FilePath.Length > 0)
{
using (Answers answers = new Answers())
{
DataView ansData = answers.SelectFile(_ansFilename);
// pre-populate answer set title and description
txtTitle.Text = ansData[0]["Title"].ToString();
txtDescription.Text = ansData[0]["Description"].ToString();
}
}
}
}
public Question(int id = 0, string text = null, Domain domain = 0, int difficulty = 0, Answers answers = null)
{
this.id = id;
this.text = text;
this.domain = domain;
this.answers = answers;
this.difficulty = difficulty;
}
protected void ansGrid_DeleteCommand(object source, DataGridCommandEventArgs e)
{
string answerFileName = e.Item.Cells[2].Text;
using (Answers answers = new Answers())
{
answers.DeleteAnswerFile(answerFileName);
}
System.IO.File.Delete(System.IO.Path.Combine(Settings.AnswerPath, answerFileName));
BindData(null);
}
private void AddOfficeFields(IDictionary electionsRecord, string electionKey)
{
var reportData =
Elections.GetElectionReportData(electionKey)
.Rows.OfType <DataRow>()
.Where(r => !IsNullOrWhiteSpace(r.PoliticianKey()))
.ToList();
var reportGroups =
reportData
.OrderBy(r => r.AlternateOfficeLevel())
.ThenBy(r => r.OfficeLevel())
.ThenBy(r => r.DistrictCode())
.ThenBy(r => r.OfficeOrderWithinLevel())
.ThenBy(r => r.OfficeLine1())
.ThenBy(r => r.OrderOnBallot())
.GroupBy(r => r.OfficeKey());
List <DataRow> issues = null;
if (_Bio || _Reasons || _Issues)
{
var politicians =
reportData.Select(r => r.PoliticianKey())
.Union(
reportData.Where(r => !IsNullOrWhiteSpace(r.RunningMateKey()))
.Select(r => r.RunningMateKey()))
.Distinct();
issues =
Answers.GetActiveDataByPoliticianKeys(politicians)
.Rows.OfType <DataRow>()
.ToList();
}
var officesArray = new ArrayList();
electionsRecord.Add("offices", officesArray);
foreach (var officeGroup in reportGroups)
{
var officeRow = officeGroup.First();
var officeRecord = new Hashtable();
officesArray.Add(officeRecord);
AddField(officeRecord, "officeKey", officeRow.OfficeKey());
AddField(officeRecord, "officeLine1", officeRow.OfficeLine1());
AddField(officeRecord, "officeLine2", officeRow.OfficeLine2());
AddField(officeRecord, "isRunningMateOffice", officeRow.IsRunningMateOffice());
if (_Candidates)
{
var candidatesArray = new ArrayList();
officeRecord.Add("candidates", candidatesArray);
AddCandidateFields(candidatesArray, officeGroup, issues);
}
}
}
public ActionResult Post(int questionId, [FromBody] Answers answer)
{
MySql.Data.MySqlClient.MySqlConnection connection = null;
string _connectionString;
_connectionString = context.connectionString;
try
{
connection = new MySql.Data.MySqlClient.MySqlConnection();
connection.ConnectionString = _connectionString;
connection.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
Console.WriteLine(ex.Message);
}
if (questionId <= 0 || answer.UserId <= 0 || answer.Description.Length == 0 || answer.Author.Length == 0)
{
return(BadRequest("Request not valid"));
}
String sqlString = String.Format("insert into answers(questionId, userId, description, rating, date, author) values ({0}, {1}, '{2}', '{3}', '{4}', '{5}')",
questionId, answer.UserId, answer.Description.Replace("\'", "\\'"), answer.Rating != null ? answer.Rating : 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), answer.Author);
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, connection);
try
{
cmd.ExecuteNonQuery();
}
catch (MySql.Data.MySqlClient.MySqlException sqlEx)
{
Console.WriteLine(sqlEx.Message);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
long id = cmd.LastInsertedId;
if (id < 0)
{
return(BadRequest("Answer not submited"));
}
else
{
return(Ok(id));
}
}
public override void Initialize(string[] answerSet, int answerCount)
{
MaxAnswer = answerCount;
for (int i = 0; i < AnswerButtons.Length; i++)
{
int maxNumber = answerSet.Length;
if (maxNumber % 4 != 0)
{
maxNumber += 2;
}
if (i < answerSet.Length)
{
AnswerButtons[i].gameObject.SetActive(true);
//최적화 문제 있음
AnswerButtons[i].GetComponentInChildren <Text>().text = answerSet[i];
}
else
{
if (i < maxNumber)
{
AnswerButtons[i].gameObject.SetActive(true);
}
else
{
AnswerButtons[i].gameObject.SetActive(false);
}
}
}
//선택 및 모양 초기화
Answers.Clear();
foreach (Button target in AnswerButtons)
{
target.colors = new ColorBlock()
{
normalColor = Color.black,
highlightedColor = Color.black,
pressedColor = Color.gray,
selectedColor = Color.black,
disabledColor = Color.gray,
colorMultiplier = 1,
fadeDuration = 0.1f
};
}
CurrentPage = 0;
IsMoving = false;
InitializePagePosition(); //currentPage 값이 이상할 수 있으니 움직임과 상관 없이 위치 결정
}
/// <summary>
/// Gets the view model for an answer.
/// </summary>
/// <param name="answer">The answer.</param>
/// <returns></returns>
/// <exception cref="CustomException"></exception>
public AnswersViewModel GetViewModel(Answers answer)
{
try {
AnswersViewModel avm = new AnswersViewModel();
avm.AnswerId = answer.AnswerId;
avm.AnswerType = answer.AnswerType;
avm.AnswerValue = answer.AnswerValue;
return(avm);
}
catch (Exception ex) {
throw new CustomException(ex.Message);
}
}
public static bool ExecuteRule(RuleBase rule, Answers answers, Bundle bundle)
{
if (rule is IAnswerParameter)
{
return(((IAnswerParameter)rule).Execute(answers));
}
if (rule is IBundleParameter)
{
return(((IBundleParameter)rule).Execute(bundle));
}
throw new Exception("Unrecognized rule parameter type.");
}
/// <summary>
/// Returns the check box status to the event subscribers
/// once the survey's page get posted
/// </summary>
protected override PostedAnswerDataCollection GetPostedAnswerData()
{
int answerFileCount = new Answers().GetAnswerFileCount(this.GroupGuid);
if (this.Mandatory && (answerFileCount == 0))
{
this.OnInvalidAnswer(new AnswerItemInvalidEventArgs(string.Format(ResourceManager.GetString("UploadFileRequiredMessage", base.LanguageCode), this.Text)));
}
PostedAnswerDataCollection datas = new PostedAnswerDataCollection();
datas.Add(new PostedAnswerData(this, this.AnswerId, base.SectionContainer.SectionNumber, this.GroupGuid, AnswerTypeMode.ExtendedType | AnswerTypeMode.Upload | AnswerTypeMode.Mandatory));
return(datas);
}
public Question ToEntity()
{
var result = new Question();
result.Answers = Answers.Select(a => a.ToEntity()).ToList();
result.CanSkip = CanSkip;
result.Enquiry = Enquiry;
result.Id = Id;
result.IsSingleSelect = IsSingleSelect;
result.IsUserMeta = IsUserMeta;
result.QuizId = QuizId;
return(result);
}
public IActionResult Answer(string text, int Id)
{
var repo = new UserRepository(_connectionString);
var a = repo.GetByEmail(User.Identity.Name);
var answer = new Answers
{
QuestionsId = Id,
UserId = a.Id,
Text = text
};
repo.AddAnswer(answer);
return(Redirect($"/home/home"));
}
public Question Selection(string answer)
{
//if that answer is in the dictionary of answers
if (Answers.ContainsKey(answer))
{
//return the next question
Question questionToReturn = Answers[answer];
questionToReturn.SetPrevious(this);
return(questionToReturn);
}
Console.WriteLine("Invalid Selection");
return(this);
}
TestAnswerPostModel getEditableAnswer(bool isAuto)
{
var answersList = Answers?.Select(
a => new TestAnswerDetailsPostModel(
Answers[0].Id, isAuto ? _emptyEditableAnswer : Answers[0].ContentToAnswer)).ToList();
if (answersList != null && answersList.Count > 0 &&
string.IsNullOrWhiteSpace(answersList[0].Content))
{
return(null);
}
return(composeAnswer(answersList));
}
public int SameAnswerCount()
{
var distinctAnswers = Answers.Distinct();
var allAnsweredSameCount = 0;
foreach (var answer in distinctAnswers)
{
if (Answers.Count(x => x == answer) == PeopleCount)
{
allAnsweredSameCount++;
}
}
return(allAnsweredSameCount);
}
protected void ButtonDeleteQuestion_Click(object sender, EventArgs e)
{
try
{
// checks
CheckForDangerousInput();
var questionKey = TextBox_Delete_QuestionKey.Text.Trim();
if (!Questions.QuestionKeyExists(questionKey))
{
throw new ApplicationException("The QuestionKey is not valid.");
}
var count = Answers.CountByQuestionKey(questionKey);
if (count > 0)
{
throw new ApplicationException(
$"There are {count} answers. These need to be reassigned or" +
" deleted before this question can be deleted.");
}
// Msg needs to come before question is deleted
Msg.Text =
Ok($"The question ({Questions.GetQuestion(questionKey)})" +
" has been deleted.");
Questions.DeleteByQuestionKey(questionKey);
RenumberQuestions();
CreateQuestionsReport();
// Reset Tables Not Visible
if (Questions.CountByIssueKey(_IssueKey) == 0)
{
Table_Question_Edit.Visible = false;
Table_Question_Add.Visible = false;
Table_Question.Visible = false;
Table_Delete_Question.Visible = false;
Table_Questions_Report.Visible = false;
}
TextBox_Delete_QuestionKey.Text = Empty;
}
catch (Exception ex)
{
Msg.Text = Fail(ex.Message);
LogAdminError(ex);
}
}
public void Set()
{
Dictionary <String, Double> dic = TeacherCheckManagerx.GetFinalScore();
if (dic == null)
{
return;
}
Answers.ForEach(s =>
{
s.FinalScore = dic[s.AnswerId];
});
}
/// <summary>
/// from json object, gets all neighborhoods without blanks or duplicates
/// </summary>
/// <param name="myAnswers">json data converted in objects</param>
/// <returns>list of neighborhoods no duplicates no blanks</returns>
static List <string> AllInOneQuery(Answers myAnswers)
{
var noBlanksOrDuplicates = (from result in myAnswers.Features
where result.Properties.Neigborhood != ""
select result.Properties.Neigborhood)
.GroupBy(x => x).Select(x => x.First()).ToList <string>();
foreach (var item in noBlanksOrDuplicates)
{
Console.WriteLine(item);
}
return(noBlanksOrDuplicates);
}
public void DeleteAnswer()
{
if (SelectedAnswer != null)
{
Answer answer = SelectedAnswer.ToPoco();
AnswerRepository.Delete(answer.AnswerID);
SelectedQuestion.Answers.Remove(answer);
Answers.Remove(SelectedAnswer);
AnswerRepository.Save();
RaisePropertyChanged("Answers");
}
}
public static int UpdateAnswer(Answers answer)
{
string connectionString = WebConfigurationManager.ConnectionStrings["DealQuestionAnswerDBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
string query = "update Answers set Answer=@ans where Id=@id";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@ans", answer.Answer);
cmd.Parameters.AddWithValue("@id", answer.Id);
con.Open();
return(cmd.ExecuteNonQuery());
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Answers answers = db.Answers.Find(id);
if (answers == null || answers.UserID != User.Identity.GetUserId() || !User.IsInRole("Administrator"))
{
return(HttpNotFound());
}
return(View(answers));
}
public async Task <bool> DeleteAnswers(Guid id)
{
Answers answers = await db.answers.FindAsync(id);
try {
db.answers.Remove(answers);
await db.SaveChangesAsync();
return(true);
}
catch (SqlException ex) {
throw ex;
}
}
static void Main(string[] args)
{
Console.WriteLine("数字を入力してくれ");
try
{
string input = Console.ReadLine();
Answers answers = new Answers();
answers.OutputEvenOrOdd(int.Parse(input));
}
catch
{
Console.WriteLine("数字を入力しろと言ったはずだが???");
}
}
private void AnswerUser(string Message, int ImageId, int UserId)
{
EGalleryEntities db = new EGalleryEntities();
Users user = db.Users.Find(UserId);
Answers answer = new Answers()
{
UserId = user.Id,
PictureId = ImageId,
Text = user.Nick + ", your image: " + Message + "."
};
db.Answers.Add(answer);
db.SaveChanges();
}
/// <summary>
/// Открывает диалог выбора файлов с ответами к тестам
/// </summary>
private void AddAnswer_Click(object sender, RoutedEventArgs e)
{
OpenFile("Text documents (.txt)|*.txt", (name) =>
{
Answers.Add(name);
var fileName = System.IO.Path.GetFileNameWithoutExtension(name);
AnswerList.Items.Add(new ListBoxItem
{
Height = 20,
Content = $"{Answers.Count}: {fileName}"
});
testCount.Text = $"{Tests.Count} : {Answers.Count}";
});
}
public void AddChild(SurveyObjectBase item)
{
var child = item as Answer;
if (item != null)
{
Answers.Add((Answer)item);
item.Parent = this;
}
else
{
throw new Exception($"Item with type {item.GetType().Name} cannot be child of type Question");
}
}
public ActionResult DeleteConfirmed(int id)
{
QAnswers[] qAnswers = db.QAnswers.Where(x => x.AId == id).ToArray();
foreach (QAnswers qA in qAnswers)
{
db.QAnswers.Remove(qA);
db.SaveChanges();
}
Answers answers = db.Answers.Find(id);
db.Answers.Remove(answers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Answer/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Answers answer = db.Answers.Find(id);
if (answer == null)
{
return(HttpNotFound());
}
return(View(answer));
}
public ActionResult EditAnswer(Answers answer)
{
if (ModelState.IsValid)
{
AnswersRepository.SaveAnswer(answer);
TempData["message"] = string.Format("Изменения в ответе были сохранены");
return(RedirectToAction("Index"));
}
else
{
// Что-то не так со значениями данных
return(View(answer));
}
}
private void addAnswers(List <Answer> allAnswers)
{
foreach (Answer a in allAnswers)
{
AnswerView av = new AnswerView();
av.AnsweredById = a.AnsweredBy.Id;
av.AnsweredByName = a.AnsweredBy.FirstName + " " + a.AnsweredBy.LastName;
av.AnswerId = a.AnswerId;
av.AnswerText = a.AnswerText;
av.AnsweredDate = a.CreatedAt;
av.Votes = a.Votes;
Answers.Add(av);
}
}
// GET: Answers/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Answers answers = await db.Answers.FindAsync(id);
if (answers == null)
{
return(HttpNotFound());
}
return(View(answers));
}
private async Task ReceiveAnswer(CommandEventArgs e, Answers userAnswer)
{
var response = userAnswer == Answers.Betray
? ":no_entry: `You betrayed nadeko` - you monster."
: ":ok: `You cooperated with nadeko.` ";
var currentAnswer = NextAnswer;
var nadekoResponse = currentAnswer == Answers.Betray
? ":no_entry: `aww Nadeko betrayed you` - she is so cute"
: ":ok: `Nadeko cooperated.`";
NextAnswer = userAnswer;
if (userAnswer == Answers.Betray && currentAnswer == Answers.Betray)
{
NadekoPoints--;
UserPoints--;
}
else if (userAnswer == Answers.Cooperate && currentAnswer == Answers.Cooperate)
{
NadekoPoints += 2;
UserPoints += 2;
}
else if (userAnswer == Answers.Betray && currentAnswer == Answers.Cooperate)
{
NadekoPoints -= 3;
UserPoints += 3;
}
else if (userAnswer == Answers.Cooperate && currentAnswer == Answers.Betray)
{
NadekoPoints += 3;
UserPoints -= 3;
}
await e.Channel.SendMessage($"**ROUND {++round}**\n" +
$"{response}\n" +
$"{nadekoResponse}\n" +
$"--------------------------------\n" +
$"Nadeko has {NadekoPoints} points." +
$"You have {UserPoints} points." +
$"--------------------------------\n")
.ConfigureAwait(false);
if (round < 10) return;
if (nadekoPoints == userPoints)
await e.Channel.SendMessage("Its a draw").ConfigureAwait(false);
else if (nadekoPoints > userPoints)
await e.Channel.SendMessage("Nadeko won.").ConfigureAwait(false);
else
await e.Channel.SendMessage("You won.").ConfigureAwait(false);
nadekoPoints = 0;
userPoints = 0;
round = 0;
}
public async Task <IHttpActionResult> DeleteAnswers(int id)
{
Answers answers = await db.Answers.FindAsync(id);
if (answers == null)
{
return(NotFound());
}
db.Answers.Remove(answers);
await db.SaveChangesAsync();
return(Ok(answers));
}
public override void CreateAnswers(StreamReader reader)
{
FrequencyQueriesAnswer ans = new FrequencyQueriesAnswer()
{
answer = new List <int>()
};
while (!reader.EndOfStream)
{
ans.answer.Add(Convert.ToInt32(reader.ReadLine()));
}
Answers.Add(ans);
}
public void SaveResultToFile(Student student, TestUnit testUnit, Answers answers, long time, int mark)
{
string fileText = $"Выполнил студент {student.FIO} из группы {student.Group}\r\n";
var i = 1;
foreach (var task in testUnit.Tasks)
{
fileText += $"{i}. {task.TaskDescription} - {answers.AnswersList[i-1].ChosenAnswer}\r\n";
i++;
}
fileText += $"Оценка - {mark}";
Directory.CreateDirectory("./StudentsTests");
File.WriteAllText($"./StudentsTests/{DateTime.Now.ToString().Replace(":", "-")} {student.FIO}.txt", fileText);
}
public void BtnClicked(Answers ans)
{
if (ans == null)
{
HideStoryTeller();
}
if (storyTextObj != null)
{
storyTextObj.text = storyTextObj.text + "\n" + ans.text;
GoStoryBottom();
if ((ans.nextEventName == null) || (ans.nextEventName == ""))
{
SetEndBtn();
}
}
}
private Answers GetAnswer(Questions question)
{
string selectedAnswer = GetAnswer();
Answers answer = new Answers();
answer.QuestionID = question.QuestionID;
answer.UserID = SessionCache.CurrentUser.Author_ID;
answer.Answer = selectedAnswer;
answer.TimeStamp = DateTime.Now;
//===========================================
answer.Time = GetTime(); //Need to change with the actual time//int.Parse(txtTime.Text);
//=============================================
answer.Correct = selectedAnswer == question.CorrectAnswer ? 1 : 0;
answer.CorrectAnswer = question.CorrectAnswer;
return answer;
}
Task<StacManResponse<Answer>> IAnswerMethods.GetByIds(string site, IEnumerable<int> ids, string filter, int? page, int? pagesize, DateTime? fromdate, DateTime? todate, Answers.Sort? sort, DateTime? mindate, DateTime? maxdate, int? min, int? max, Order? order)
{
ValidateString(site, "site");
ValidateEnumerable(ids, "ids");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder(Version, String.Format("/answers/{0}", String.Join(";", ids)), useHttps: false);
ub.AddParameter("site", site);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, HttpMethod.GET, "/answers/{ids}");
}
public void ImportAnswer(Post parent, Answers a)
{
Post post = postRepository.FindOne(new { type = PostType.answer, sitename = currentSite, siteid = a.answer_id });
if (post == null)
{
post = new Post();
}
post.body = a.body;
post.community = parent.community;
post.lastactivity = a.last_activity_date.FromUnixTime();
post.lastedit = a.last_edit_date > a.creation_date ? a.last_edit_date.FromUnixTime() : a.creation_date.FromUnixTime();
post.parent = parent;
post.score = a.score;
post.siteid = a.answer_id;
post.sitename = currentSite;
string strip = Regex.Replace(a.body, "<.*?>", string.Empty);
strip = strip.Replace("\r", "").Replace("\n", "");
string[] elementWords = strip.Split(new char[] { ' ' });
int i = 0;
StringBuilder sb = new StringBuilder();
while (i < elementWords.Length)
{
if (i != 0)
{
sb.Append(" ");
}
if (sb.Length + elementWords[i].Length < 250)
{
sb.Append(elementWords[i]);
}
else
{
sb.Append("...");
break;
}
i++;
}
post.summary = sb.ToString();
post.tags.Clear();
foreach (Tag t in parent.tags)
{
post.tags.Add(t);
}
post.type = PostType.answer;
post.user = userimport.Import(userRepository, currentSite, a.owner);
postRepository.SaveOrUpdate(post);
foreach (Comments c in a.comments)
{
ImportComment(post, c);
}
}
private AnswerTotal ModifyAnswerTotal(Answers answer, AnswerTotal answerTotal)
{
if(answer.Answer == "A")
{
answerTotal.A++;
}
if (answer.Answer == "BA")
{
answerTotal.B++;
}
if (answer.Answer == "C")
{
answerTotal.C++;
}
if (answer.Answer == "D")
{
answerTotal.D++;
}
answerTotal.Total++;
return answerTotal;
//UPDATE tbl_AnswerTotal SET [" & varAnswer & "] = [" & varAnswer & "] +1, [Total] = [Total] + 1 WHERE [QuestionID]=" & varID & ";"
}
public object Any(Answers request)
{
TableRepository tableRepository = new TableRepository();
CloudTable questionTable = tableRepository.GetTable(Tables.Questions);
Guid questionId = Guid.Parse(request.Id);
TableQuery<QuestionEntry> questionQuery = questionTable.CreateQuery<QuestionEntry>();
QuestionEntry questionEntry = (from k in questionQuery
where k.RowKey == questionId.ToString()
select k).SingleOrDefault();
if (questionEntry == null)
throw HttpError.NotFound("Such question do not exist");
questionEntry.Views++;
tableRepository.InsertOrMerge(questionEntry, Tables.Questions);
CloudTable answerTable = tableRepository.GetTable(Tables.Answers);
TableQuery<AnswerEntry> answerQuery = answerTable.CreateQuery<AnswerEntry>();
AnswerEntry[] answerEntries = (from k in answerQuery
where k.PartitionKey == questionId.ToString()
select k).ToArray();
UserQuestionEntry userQuestionEntry = UserSession.IsAuthenticated
? tableRepository.Get<UserQuestionEntry>(Tables.UserQuestion, questionId, UserSession.GetUserId())
: null;
HashSet<string> votesUp = new HashSet<string>(userQuestionEntry?.VotesUp?.Split('|') ?? new string[] { });
HashSet<string> votesDown = new HashSet<string>(userQuestionEntry?.VotesDown?.Split('|') ?? new string[] { });
Func<Guid, VoteKind> getVoteKind = ownerId =>
{
if (votesUp.Contains(ownerId.ToString()))
return VoteKind.Up;
if (votesDown.Contains(ownerId.ToString()))
return VoteKind.Down;
return VoteKind.None;
};
AnswersResponse answersResponse = new AnswersResponse
{
Id = questionEntry.GetId(),
Creation = questionEntry.Creation,
Owner = CreateUserCard(tableRepository, questionEntry.GetOwnerId()),
Detail = questionEntry.Detail,
Tags = questionEntry.Tags.SplitAndTrimOn(new char[] { ',' }),
Title = questionEntry.Title,
Views = questionEntry.Views,
Votes = questionEntry.Votes,
SelectedAnswer = questionEntry.SelectedAnswer,
Answers = answerEntries.Select(k => new AnswerResult
{
Owner = CreateUserCard(tableRepository, k.GetAnswerOwnerId()),
Creation = k.Creation,
Content = k.Content,
Votes = k.Votes,
VoteKind = getVoteKind(k.GetAnswerOwnerId())
}).ToArray()
};
// quest user vote for this question
answersResponse.VoteKind = getVoteKind(questionId);
answersResponse.Love = userQuestionEntry?.Love ?? false;
return answersResponse;
}
public ActionResult AddingTasks(System.Collections.Generic.List<string> Answers, System.Collections.Generic.List<string> Tags, string Category, string Difficulty, string HTML, string Name, int? id)
{
ApplicationDbContext DB = new ApplicationDbContext();
if (Answers != null && Difficulty != null && Category != null && HTML != null)
{
if (Answers.Count > 0)
{
if (id == null)
{
UserTask NewTask = new UserTask();
NewTask.TaskName = Name;
NewTask.TaskDifficulty = Difficulty;
NewTask.TaskCategory = Category;
NewTask.TaskText = HTML;
NewTask.TaskRating = 0;
NewTask.SolveCount = 0;
NewTask.UserID = DB.Users.First(c => c.UserName == User.Identity.Name).Id;
DB.Tasks.Add(NewTask);
DB.Entry(NewTask).State = System.Data.Entity.EntityState.Added;
int NewTaskID = DB.Tasks.ToList().Last(c => c.UserTaskID > 0).UserTaskID + 1;
for (int i = 0; i < Tags.Count; i++)
{
string CurrentTag = Tags[i];
Tags NewTag = new Tags();
NewTag.TagText = Tags[i];
NewTag.TaskID = NewTaskID;
DB.Tags.Add(NewTag);
}
for (int i = 0; i < Answers.Count; i++)
{
string CurrentAnswer = Answers[i];
Answers NewAnswer = new Answers();
NewAnswer.AnswerText = Answers[i];
NewAnswer.TaskID = NewTaskID;
DB.Answers.Add(NewAnswer);
DB.Entry(NewAnswer).State = System.Data.Entity.EntityState.Added;
}
}
else
{
DB.Tags.RemoveRange(DB.Tags.Where(c => c.TaskID == id));
DB.Answers.RemoveRange(DB.Answers.Where(c => c.TaskID == id));
for (int i = 0; i < Tags.Count; i++)
{
string CurrentTag = Tags[i];
Tags NewTag = new Tags();
NewTag.TagText = Tags[i];
NewTag.TaskID = (int)id;
DB.Tags.Add(NewTag);
DB.Entry(NewTag).State = System.Data.Entity.EntityState.Added;
}
for (int i = 0; i < Answers.Count; i++)
{
string CurrentAnswer = Answers[i];
Answers NewAnswer = new Answers();
NewAnswer.AnswerText = Answers[i];
NewAnswer.TaskID = (int)id;
DB.Answers.Add(NewAnswer);
DB.Entry(NewAnswer).State = System.Data.Entity.EntityState.Added;
}
DB.Tasks.First(c=>c.UserTaskID == id).TaskName = Name;
DB.Tasks.First(c => c.UserTaskID == id).TaskDifficulty = Difficulty;
DB.Tasks.First(c => c.UserTaskID == id).TaskCategory = Category;
DB.Tasks.First(c => c.UserTaskID == id).TaskText = HTML;
}
DB.SaveChanges();
}
}
return RedirectToAction("Index", "Home");
}
private void button2_Click(object sender, EventArgs e)
{
String file = openFileDialog1.FileName;
String text = richTextBox1.Text;
String domainname = null;
bool isGraphic = checkBox1.Checked;
Domain domain = 0;
Answers answers = new Answers();
answers[1] = textBox1.Text;
answers[2] = textBox2.Text;
answers[3] = textBox3.Text;
answers[4] = textBox4.Text;
switch (comboBox1.SelectedIndex)
{
case 0: answers.CorrectAnswer = textBox1.Text;
break;
case 1: answers.CorrectAnswer = textBox2.Text;
break;
case 2: answers.CorrectAnswer = textBox3.Text;
break;
case 3: answers.CorrectAnswer = textBox4.Text;
break;
default:
answers.CorrectAnswer = textBox1.Text;
break;
}
foreach (Control c in this.Controls)
if (c is RadioButton) if (((RadioButton)c).Checked == true) domainname = ((RadioButton)c).Text;
switch (domainname)
{
case "hidro":
domain = Domain.Hidrografie;
break;
case "rel":
domain = Domain.Relief;
break;
case "res":
domain = Domain.Resurse;
break;
case "admin":
domain = Domain.Administrativ;
break;
default:
domain = Domain.None;
break;
}
Question question = new Question(0, text, domain, 0, answers);
if (!String.IsNullOrEmpty(richTextBox1.Text) &&
!String.IsNullOrEmpty(textBox1.Text) &&
!String.IsNullOrEmpty(textBox2.Text) &&
!String.IsNullOrEmpty(textBox3.Text) &&
!String.IsNullOrEmpty(textBox4.Text))
{
if (isGraphic)
DatabaseAbstractionLayer.DAL.UploadQuestion(question, isGraphic, file);
else DatabaseAbstractionLayer.DAL.UploadQuestion(question);
MessageBox.Show("Intrebare adaugata!");
this.Close();
}
else MessageBox.Show("Toate campurile trebuie completate!");
}
private List<Answers> GetAnswersFromTask(string RawVariants)
{
MatchCollection answers = Regex.Matches(RawVariants, @"'(?<aid>\d+)'.*?""(?<atext>.*?)""", RegexOptions.Singleline);
List<Answers> AnswerList = new List<Answers>();
foreach (Match item in answers)
{
Answers NewAnswer = new Answers();
NewAnswer.AID = Convert.ToInt32(item.Groups["aid"].Value);
NewAnswer.AnswerText = item.Groups["atext"].Value.Trim();
AnswerList.Add(NewAnswer);
}
return AnswerList;
}
public static OneBasedArray<Question> GetQuestions()
{
OneBasedArray<Question> questionList = new OneBasedArray<Question>(30);
int id = 0;
int difficultyPercent = 0;
bool isGraphic = false;
string text = string.Empty;
Domain domain = Domain.None;
byte[] imageData;
Image image = null;
// Open connection
if (OpenConnection() == true)
{
// Create command and assign the query and connection from the constructor
try
{
using (var command = new MySqlCommand("GetQuestions", connection) { CommandType = CommandType.StoredProcedure })
{
command.Parameters.AddWithValue("@user", PersistentData.user);
int j = 1;
MySqlDataReader myReader = command.ExecuteReader();
while (myReader.Read())
{
id = myReader.GetInt32(0);
text = myReader.GetString(1);
domain = myReader.GetDomain(2);
difficultyPercent = myReader.GetInt32(3);
isGraphic = myReader.GetBoolean(4);
if (isGraphic)
imageData = (byte[])myReader[5];
else imageData = null;
image = Utils.Converters.ByteArrayToImage(imageData);
Answers answers = new Answers();
answers.CorrectAnswer = myReader.GetString(6);
int i = 1;
while (i <= PersistentData.MAX_ANSWERS)
{
answers[i] = myReader.GetString(6 + i);
i++;
}
if (!isGraphic)
questionList[j] = new Question(id, text, domain, difficultyPercent, answers);
else
questionList[j] = new GraphicQuestion(id, text, image, domain, difficultyPercent, answers);
j++;
}
}
}
catch (MySqlException ex)
{
Debug.ExitWithErrorMessage(ex.Message, ex.Number);
}
// Close connection
CloseConnection();
}
else Debug.ExitWithErrorMessage("Connection failed to open using DAL method.");
return questionList;
}
Task<StacManResponse<Answer>> IUserMethods.GetMyTopAnswers(string site, string access_token, IEnumerable<string> tags, string filter = null, int? page = null, int? pagesize = null, DateTime? fromdate = null, DateTime? todate = null, Answers.Sort? sort = null, DateTime? mindate = null, DateTime? maxdate = null, int? min = null, int? max = null, Order? order = null)
{
var filterObj = ValidateAndGetFilter(filter);
ValidateString(site, "site");
ValidateString(access_token, "access_token");
ValidateEnumerable(tags, "tags");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder(String.Format("/me/tags/{0}/top-answers", String.Join(";", tags)), useHttps: true);
ub.AddParameter("site", site);
ub.AddParameter("access_token", access_token);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, filterObj, "/_users/tags/{tags}/top-answers");
}
/// <summary>
/// Creates new course and opens it.
/// </summary>
public static void CreateNew()
{
FFDebug.EnterMethod(Cattegory.Course, State.ToString());
if ((State & CourseStates.Opened) > 0 && !Close())
{
return;
}
__FullPath = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString());
Directory.CreateDirectory(__FullPath);
__Manifest = new ManifestType("New Course") { version = CourseUpgradeManager.LastVersion };
__Manifest.ResolveTree(__Manifest);
__Organization = __Manifest.organizations.Organizations[0];
__Manifest.organizations.@default = __Organization.identifier;
Answers = new Answers();
Save();
if (Open(__FullPath))
{
State = CourseStates.Opened;
}
FFDebug.LeaveMethod(Cattegory.Course, MethodBase.GetCurrentMethod());
}
Task<StacManResponse<Answer>> IUserMethods.GetMyAnswers(string site, string access_token, string filter, int? page, int? pagesize, DateTime? fromdate, DateTime? todate, Answers.Sort? sort, DateTime? mindate, DateTime? maxdate, int? min, int? max, Order? order)
{
ValidateString(site, "site");
ValidateString(access_token, "access_token");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder(Version, "/me/answers", useHttps: true);
ub.AddParameter("site", site);
ub.AddParameter("access_token", access_token);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, HttpMethod.GET, "/_users/answers");
}
Task<StacManResponse<Answer>> IUserMethods.GetTopAnswers(string site, int id, IEnumerable<string> tags, string filter, int? page, int? pagesize, DateTime? fromdate, DateTime? todate, Answers.Sort? sort, DateTime? mindate, DateTime? maxdate, int? min, int? max, Order? order)
{
ValidateString(site, "site");
ValidateEnumerable(tags, "tags");
ValidatePaging(page, pagesize);
ValidateSortMinMax(sort, mindate: mindate, maxdate: maxdate, min: min, max: max);
var ub = new ApiUrlBuilder(Version, String.Format("/users/{0}/tags/{1}/top-answers", id, String.Join(";", tags.Select(HttpUtility.UrlEncode))), useHttps: false);
ub.AddParameter("site", site);
ub.AddParameter("filter", filter);
ub.AddParameter("page", page);
ub.AddParameter("pagesize", pagesize);
ub.AddParameter("fromdate", fromdate);
ub.AddParameter("todate", todate);
ub.AddParameter("sort", sort);
ub.AddParameter("min", mindate);
ub.AddParameter("max", maxdate);
ub.AddParameter("min", min);
ub.AddParameter("max", max);
ub.AddParameter("order", order);
return CreateApiTask<Answer>(ub, HttpMethod.GET, "/_users/tags/{tags}/top-answers");
}
public GraphicQuestion(int id = 0, string text = null, Image image = null, Domain domain = 0, int difficulty = 0, Answers answers = null)
: base(id,text,domain,difficulty,answers)
{
this.image = image;
}
protected void ansGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{
using (Answers answers = new Answers())
{
string fileName = ViewState["editf"].ToString();
string title = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string description = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
answers.UpdateAnswerFile(fileName, title, description);
}
ansGrid.EditItemIndex = -1;
BindData(null);
}
