protected void btnAnswer_Click(object sender, EventArgs e)
{
AnswerEntity obj = new AnswerEntity();
string username = "";
if (Session["username"] != null)
{
username = Session["username"].ToString();
}
else
{
Response.Write("<script>alert('您还没有登录，请先登录！')</script>");
Response.Redirect("LoginBBS.aspx");
}
dt3 = new userInfoBLL().GetUserID(username);
obj.userID = Convert.ToInt32(dt3.Rows[0]["userID"]);
obj.TopicID = Convert.ToInt32(Request.QueryString["TopicID"]);
obj.AnswerDate = DateTime.Now;
obj.AnswerContent = txtContent.Value;
BLL.AnswerBLL.InsertAnswer(obj);
Response.Write("<script>alert('发表成功！')</script>");
userInfoBLL.UpdateUserLevelCount(username);
fresh();
}
public void DeleteAnswer(int idAnswer)
{
AnswerEntity ae = data.AnswerEntities.First(x => x.IdAnswer == idAnswer);
data.DeleteObject(ae);
data.SaveChanges();
}
public AnswerDTO Get(int ID)
{
AnswerEntity getanswer = ur.Get(ID);
AnswerDTO answer = Mapper.Map <AnswerDTO>(getanswer);
return(answer);
}
protected void btnUpLoad_Click(object sender, EventArgs e)
{
if (Session["username"] != null)
{
if (hidContent.Value != string.Empty)
{
string username = Session["username"].ToString();
d = new AnswerBLL().GetUserID(username);
int userID = int.Parse(d.Rows[0][0].ToString());
AnswerEntity answerInfo = new AnswerEntity();
answerInfo.userID = userID;
answerInfo.TopicID = (long)int.Parse(topicID.ToString());
answerInfo.AnswerDate = DateTime.Now;
answerInfo.AnswerContent = hidContent.Value;
BLL.AnswerBLL.InsertAnswerInfo(answerInfo);
Response.Write("<script>alert('回复成功！')</script>");
userInfoBLL.UpdateUserLevelCount(username);
}
Response.Write("<script>('内容不能为空!')</script>");
}
else
{
Response.Write("<script>alert('请先登录')</script>");
Response.Redirect("LoginBBS.aspx");
}
}
public async Task <bool> Handle(AskQuestionCommand request, CancellationToken cancellationToken)
{
var question = new QuestionEntity(
request.Title,
request.UserId,
request.Tags
);
question.DefineId(request.Id);
var questionBody = new AnswerEntity(
request.Body,
request.UserId,
AnswerKind.QuestionBody,
votes: 0
);
questionBody.DefineId(Guid.NewGuid());
question.SetQuestionBody(questionBody);
await _repository.RegisterAsync(question);
return(true);
}
public async Task <Response <IAnswer> > CreateAnswer(CreateAnswer answer)
{
var response = new Response <IAnswer>();
try
{
var newAnswer = new AnswerEntity()
{
Name = answer.Name,
TrueOrFalse = answer.TrueOrFalse
};
_context.Answers.Add(newAnswer);
await _context.SaveChangesAsync();
response.Data = newAnswer;
}
catch (Exception e)
{
response.Error = new Error(500, "Can`t register new Answer: " + e);
}
return(response);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Content")] AnswerEntity answerEntity)
{
if (id != answerEntity.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var answer = await _context.Answers.FirstOrDefaultAsync(x => x.Id == answerEntity.Id);
answer.Content = answerEntity.Content;
_context.Answers.Update(answer);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnswerEntityExists(answerEntity.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Details", "Questions", new { id = GetQuestionId(answerEntity.Id), addView = false }));
}
return(View(answerEntity));
}
public async Task <bool> UpdateAsync(AnswerEntity entity)
{
List <AnswerEntity> answers = await GetAsync();
bool response = await base.UpdateAsync(answers);
return(response);
}
public async Task <bool> InsertAsync(AnswerEntity entity)
{
AnswerEntity lastAnswer = (await GetAsync())?.OrderByDescending(a => a.AnswerID)?.FirstOrDefault();
entity.AnswerID = (lastAnswer?.AnswerID ?? 0) + 1;
bool response = await base.InsertAsync(entity);
return(response);
}
/// <summary>
/// Crear un nuevo objeto AnswerEntity.
/// </summary>
/// <param name="idAnswer">Valor inicial de IdAnswer.</param>
/// <param name="answer">Valor inicial de Answer.</param>
/// <param name="correct">Valor inicial de Correct.</param>
public static AnswerEntity CreateAnswerEntity(int idAnswer, string answer, bool correct)
{
AnswerEntity answerEntity = new AnswerEntity();
answerEntity.IdAnswer = idAnswer;
answerEntity.Answer = answer;
answerEntity.Correct = correct;
return(answerEntity);
}
private bool AnswerIsWellUpdated(AnswerEntity entity, Answer answer)
{
return(entity.User == answer.User &&
entity.Id == answer.Id &&
entity.AnswerSelected.FirstOrDefault().IdOption == answer.AnswerSelected.FirstOrDefault().IdOption&&
entity.AnswerSelected.FirstOrDefault().OptionDescription == answer.AnswerSelected.FirstOrDefault().OptionDescription&&
entity.AnswerSelected.FirstOrDefault().IdQuestion == answer.AnswerSelected.FirstOrDefault().IdQuestion&&
entity.AnswerSelected.FirstOrDefault().QuestionDescription == answer.AnswerSelected.FirstOrDefault().QuestionDescription);
}
public void GenerateTestJSON()
{
FrameworkManager FM = new FrameworkManager();
AspectsManager AM = new AspectsManager();
AnswersManager ASWM = new AnswersManager();
QuestionsManager QM = new QuestionsManager();
NurseSelfAssessmentAnswersManager NSAM = new NurseSelfAssessmentAnswersManager();
//Get Aspects
var aspect_Resul = AM.Get();
var aspects_List = (List <AspectEntity>)aspect_Resul.Entity;
var aspects_Dict = aspects_List.ToDictionary(x => x.AspectId, x => x);
//Get Answers
var answers_result = ASWM.Get();
var answers_List = (List <AnswerEntity>)answers_result.Entity;
var answers_Dict = answers_List.ToDictionary(x => (x.QuestionId, x.Value), x => x);
//Get Questions
var questions_result = QM.Get();
var questions_List = (List <QuestionEntity>)questions_result.Entity;
var question_Dict = questions_List.ToDictionary(x => x.AspectId, x => x);
var criteria = new Dictionary <int, AnswerEntity>();
var criteria_entity = new ListingCriteriaModel();
criteria_entity.EmmployerId = 1;
criteria_entity.JobListingId = 3;
decimal value = (decimal)0.66;
for (int i = 1; i <= 30; i++)
{
var question = question_Dict[i];
var answer = new AnswerEntity();
if (answers_Dict.TryGetValue((question.QuestionId, value), out answer))
{
criteria.Add(i, answer);
}
;
}
criteria_entity.Answers = criteria;
var json = JsonConvert.SerializeObject(criteria_entity);
Console.WriteLine(json);
Assert.IsTrue(true);
}
public static DalAnswer ToDalAnswer(this AnswerEntity answer)
{
return(new DalAnswer
{
Id = answer.Id,
ContentAnswer = answer.ContentAnswer,
IsTrue = answer.IsTrue,
QuestionId = answer.QuestionId
});
}
public async Task <bool> UpdateAnswer(AnswerEntity answer)
{
_context.AnswerEntities.Add(answer);
return(await _context.SaveChangesAsync() > 0);
//return await _context.Database.ExecuteSqlCommandAsync(
// $"updateAnswer {userId}, {questionId}, {answerType}, {answered}") > 0;
}
private async Task <AnswerEntity> CreateAnswer(AnswerEntity answerEntity)
{
var user = await GetCurentUser();
answerEntity.Author = user.UserName;
answerEntity.AuthorId = user.Id;
answerEntity.Created = DateTime.Now;
answerEntity.Id = 0;
return(answerEntity);
}
public static DalAnswer ToDalAnswer(this AnswerEntity e)
{
return(new DalAnswer()
{
Id = e.Id,
AnswerStructure = e.AnswerStructure,
AnswerValue = e.AnswerValue,
QuestionId = e.QuestionId
});
}
public static AnswerViewModel ToMvcAnswer(this AnswerEntity answer)
{
return(new AnswerViewModel
{
Id = answer.Id,
ContentAnswer = answer.ContentAnswer,
IsTrue = answer.IsTrue,
QuestionId = answer.QuestionId
});
}
public IAnswerAspect Map(AnswerEntity entity)
{
return(new AnswerAspect
{
AnswerCode = entity.AnswerId.ToString(),
AnswerSolution = entity.AnswerSolution,
AnswerImageName = entity.AnswerImageName,
AnswerComments = entity.AnswerComments,
AnswerCreatedOn = entity.AnswerCreatedOn
});
}
public Task Update(AnswerEntity answer, IReadOnlyList <string> changedProperties)
{
if (!_datastore.Answers.ContainsKey(answer.Id))
{
throw new EntityNotFoundException(
typeof(AnswerEntity), answer.Id);
}
_datastore.Answers[answer.Id] = answer;
return(Task.CompletedTask);
}
public static AnswerEntity ToBll(this DalAnswer answer)
{
var answerEntity = new AnswerEntity()
{
Id = answer.Id,
Description = answer.Description,
IsCorrect = answer.IsCorrect,
QuestionId = answer.QuestionId,
};
return(answerEntity);
}
public static DalAnswer ToDal(this AnswerEntity answer)
{
var dalAnswer = new DalAnswer()
{
Id = answer.Id,
Description = answer.Description,
IsCorrect = answer.IsCorrect,
QuestionId = answer.QuestionId,
};
return(dalAnswer);
}
public async Task <bool> UpdateAnswer(TwoButtonsContext context, AnswerEntity answer)
{
context.AnswerEntities.Add(answer);
// var p = context.AnswerEntities.ToList();
// var y = p;
return(await context.SaveChangesAsync() > 0);
//return await _context.Database.ExecuteSqlCommandAsync(
// $"updateAnswer {userId}, {questionId}, {answerType}, {answered}") > 0;
}
public JsonResult Save(int optionId, int questionId)
{
var answer = new AnswerEntity()
{
OptionId = optionId,
QuestionId = questionId
};
var result = _answerRepo.Add(answer);
return(Json(result));
}
public static AnswerViewModel ToMvc(this AnswerEntity answer)
{
var dalAnswer = new AnswerViewModel()
{
Id = answer.Id,
Text = answer.Description,
IsCorrect = answer.IsCorrect,
QuestionId = answer.QuestionId,
};
return(dalAnswer);
}
public static AnswerEntity ToBll(this AnswerViewModel answer)
{
var answerEntity = new AnswerEntity()
{
QuestionId = answer.QuestionId,
Description = answer.Text,
IsCorrect = answer.IsCorrect,
Id = answer.Id,
};
return(answerEntity);
}
private void LoadCommentEntityToModel(AnswerEntity entity, AnswerModel model)
{
entity.Comments.ToList().ForEach(comment =>
{
var newComment = _commentFactory.Execute(comment);
if (newComment.Id == Guid.Empty)
{
newComment.Id = Guid.NewGuid();
}
model.Comments.Add(newComment);
});
}
public AnswerModel Execute(AnswerEntity from)
{
var model = new AnswerModel();
model.Id = from.Id;
model.KindOf = (int)from.Kind;
model.QuestionId = from.Parent.Id;
model.Body = from.Body;
model.UserId = from.UserId;
LoadCommentEntityToModel(from, model);
return(model);
}
//answer
public int AddAnswer(Answer answer, int idQuestion)
{
AnswerEntity ae = new AnswerEntity();
ae.Answer = answer.AnswerText;
ae.Correct = answer.Correct;
ae.Question = data.QuestionEntities.First(x => x.IdQuestion == idQuestion);
data.SaveChanges();
return(ae.IdAnswer);
}
public Task Update(AnswerEntity answer, IReadOnlyList <string> changedProperties)
{
var propertiesAssignments = changedProperties
.Select(p => $"{p.PascalCaseToSnakeCase()} = @{p}");
var assignmentsJoined = string.Join(", ", propertiesAssignments);
return(_connection.ExecuteAsync(
sql: $"UPDATE @Schema.answer SET {assignmentsJoined} WHERE id = @Id"
.InjectSchema(Schema),
param: answer,
transaction: _transactionProvider.Get()));
}
public ActionResult SaveAnswer([FromForm] int quizID, [FromForm] string answer)
{
var answerObj = new AnswerEntity();
int.TryParse(Request.Cookies["id"], out int creator); //暂时没有用户名
answerObj.AnswerCreator = creator;
answerObj.AnswerIP = new HttpParser(HttpContext).GetIPAddr();
answerObj.QuizID = quizID;
answerObj.AnswerBody = answer;
dbc.Answer.Add(answerObj);
dbc.SaveChanges();
return(JsonReturn.ReturnSuccess());
}
public static AnswerInfo LoadFromEntity( AnswerEntity entity )
{
if (entity == null)
return default(AnswerInfo);
AnswerInfo info = new AnswerInfo() {
ID = entity.ID,
Content = entity.Content,
OccurTime = entity.OccurTime,
State = (DbState)entity.State,
UpCount = entity.UpCount,
DownCount = entity.DownCount
};
return info;
}
/// <summary>
/// Crear un nuevo objeto AnswerEntity.
/// </summary>
/// <param name="idAnswer">Valor inicial de IdAnswer.</param>
/// <param name="answer">Valor inicial de Answer.</param>
/// <param name="correct">Valor inicial de Correct.</param>
public static AnswerEntity CreateAnswerEntity(int idAnswer, string answer, bool correct)
{
AnswerEntity answerEntity = new AnswerEntity();
answerEntity.IdAnswer = idAnswer;
answerEntity.Answer = answer;
answerEntity.Correct = correct;
return answerEntity;
}
/// <summary>
/// No hay ningún comentario para AnswerEntities en el esquema.
/// </summary>
public void AddToAnswerEntities(AnswerEntity answerEntity)
{
base.AddObject("AnswerEntities", answerEntity);
}