public Object UploadImage(string id)
{
string imageName = null;
var httpRequest = HttpContext.Current.Request;
//Upload Image
var postedFile = httpRequest.Files["Image"];
//Create custom filename
imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-");
imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName);
var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName);
postedFile.SaveAs(filePath);
var validUser = dbContext.Users.Where(c => c.Id == id).SingleOrDefault();
if (validUser == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
else
{
validUser.imageUrl = "Image/" + imageName;
dbContext.SaveChanges();
SuccessStatus s = new SuccessStatus();
s.status = "Success";
s.data = new List <string>()
{
"Url: " + validUser.imageUrl,
"Message: image uploaded successfully"
};
return(s);
}
}
public Object Post([FromBody] Question question)
{
try
{
using (var entities = new ApplicationDbContext())// to define scope of dbContext object
{
entities.Questions.Add(question);
entities.SaveChanges();
//// sending message to particular location
//var message = Request.CreateResponse(HttpStatusCode.Created, question);
//message.Headers.Location = new Uri(Request.RequestUri + question.Id.ToString());
//return message;
SuccessStatus s = new SuccessStatus();
s.status = "Success";
/*becoz question id will be automatically attached to this question.quesId
* after the record is inserted to db using SaveChanges*/
s.data = question;
return(s);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <int> enigmasbyStatus(SuccessStatus status)
{
List <EnigmaStatus> statuses = statusList.FindAll(enigmaStatus => enigmaStatus.successStatus == status);
List <int> enigmasId = new List <int>();
foreach (EnigmaStatus eStatus in statuses)
{
enigmasId.Add(eStatus.enigmaId);
}
return(enigmasId);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//{"ext":"\"11\"","msg":"","result":"Exec successful,0/1 is error!ReplicateCount is1"}
SortedDictionary <string, string> pams = GetRequestPost(Request.RequestContext.HttpContext.Request);
// CoreHelper.CreateFile(System.Configuration.ConfigurationManager.AppSettings["NotifyErrLogPath"] + "\\Qunar\\" + System.Guid.NewGuid() + ".txt", JsonConvert.SerializeObject(pams));//创建文件 JsonConvert.SerializeObject(pams);
string result = pams["result"] == null ? "" : pams["result"].ToString();
SuccessStatus notifyResult = SuccessStatus.Other;
bool isSucess = true;
if (result.IndexOf("successful") > -1)
{
isSucess = true;
notifyResult = SuccessStatus.Success;
}
else
{
isSucess = false;
notifyResult = SuccessStatus.Failed;
CoreHelper.CreateFile(System.Configuration.ConfigurationManager.AppSettings["NotifyErrLogPath"] + "\\Qunar\\" + DateTime.Now.ToString("yyyy-MM-dd") + ".txt", JsonConvert.SerializeObject(pams));//创建文件
}
UpdateNotifyRequest request = new UpdateNotifyRequest()
{
UpdateStatusId = pams["ext"] == null || string.IsNullOrEmpty(pams["ext"])? "0" : pams["ext"].ToString().Replace("\\", ""),
ResponseParams = JsonConvert.SerializeObject(pams),
NotifyResult = notifyResult,
IsSucess = isSucess
};
IPolicyNotify notify = new DefaultPolicyNotify();
EmptyResponse res = notify.UpdateNotify(request);
if (res.ErrCode == PolicyService.Enums.ResultType.Failed)
{
string log = DateTime.Now + ":回调内容:" + JsonConvert.SerializeObject(pams) + ",更新回调结果:" + JsonConvert.SerializeObject(res);
CoreHelper.CreateFile(System.Configuration.ConfigurationManager.AppSettings["NotifyErrLogPath"] + "\\Qunar\\" + DateTime.Now.ToString("yyyy-MM-dd") + ".txt", log);//创建文件
Response.Write("F");
//Response.End();
}
else
{
Response.Write("S");
}
//Response.End();
}
catch (Exception ex)
{
CoreHelper.CreateFile(System.Configuration.ConfigurationManager.AppSettings["NotifyErrLogPath"] + "\\Qunar\\" + DateTime.Now.ToString("yyyy-MM-dd") + ".txt", JsonConvert.SerializeObject(ex));//创建文件
}
}
/// <summary>
/// All enum values are valid.
/// </summary>
/// <param name="value">The value to validate.</param>
public override void ValidateSuccessStatus(SuccessStatus value)
{
switch (value)
{
case SuccessStatus.Failed:
case SuccessStatus.Passed:
case SuccessStatus.Unknown:
break;
default:
throw new ArgumentOutOfRangeException("value");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Response" /> class.
/// </summary>
/// <param name="content">The content.</param>
/// <param name="sent">The sent.</param>
/// <param name="statusCode">The status code.</param>
/// <param name="isSuccess">if set to <c>true</c> [is success].</param>
/// <param name="status">The status.</param>
/// <param name="cookie">The cookie.</param>
public Response(
String content,
DateTime sent,
HttpStatusCode statusCode,
bool isSuccess, SuccessStatus status, string cookie = "")
{
this.Content = content;
this.Sent = sent;
this.StatusCode = statusCode;
this.IsSuccess = isSuccess;
this.ResponseStatus = status;
this.Cookie = cookie;
}
public AttemptResult(long attemptId, User user, Theme theme,
CompletionStatus completionStatus, AttemptStatus attemptStatus,
SuccessStatus successStatus, DateTime? startTime, float? scaledScore)
{
this.AttemptId = attemptId;
this.User = user;
this.Theme = theme;
this.CompletionStatus = completionStatus;
this.AttemptStatus = attemptStatus;
this.SuccessStatus = successStatus;
this.StartTime = startTime;
this.Score = new Score(scaledScore);
}
public AttemptResult(long attemptId, User user, Topic topic,
CompletionStatus completionStatus, AttemptStatus attemptStatus,
SuccessStatus successStatus, DateTime?startTime, float?scaledScore)
{
this.AttemptId = attemptId;
this.User = user;
this.Topic = topic;
this.CompletionStatus = completionStatus;
this.AttemptStatus = attemptStatus;
this.SuccessStatus = successStatus;
this.StartTime = startTime;
this.Score = new Score(scaledScore);
}
public AttemptResult(long attemptId, User user, CurriculumChapterTopic curriculumChapterTopic, TopicTypeEnum topicType, CompletionStatus completionStatus, AttemptStatus attemptStatus, SuccessStatus successStatus, DateTime? startTime, DateTime? finishTime, int iudicoCourseRef, float? minScore, float? maxScore, float? rawScore, float? scaledScore)
{
this.AttemptId = attemptId;
this.User = user;
this.CurriculumChapterTopic = curriculumChapterTopic;
this.TopicType = topicType;
this.CompletionStatus = completionStatus;
this.AttemptStatus = attemptStatus;
this.SuccessStatus = successStatus;
this.StartTime = startTime;
this.FinishTime = finishTime;
this.IudicoCourseRef = iudicoCourseRef;
this.Score = new Score(minScore, maxScore, rawScore, scaledScore);
}
public AnswerResult(long activityAttempId, long activityPackageId, string activityTitle, long? interactionId, CompletionStatus completionStatus, SuccessStatus? successStatus,
AttemptResult attempResult, object learnerResponse, string correctResponse, InteractionType? learnerResponseType, float? scaledScore)
{
this.ActivityAttemptId = activityAttempId;
this.ActivityPackageId = activityPackageId;
this.ActivityTitle = activityTitle;
this.InteractionId = interactionId;
this.CompletionStatus = completionStatus;
this.SuccessStatus = successStatus;
this.AttemptResult = attempResult;
this.LearnerResponse = learnerResponse;
this.CorrectResponse = correctResponse;
this.LearnerResponseType = learnerResponseType;
this.ScaledScore = scaledScore;
}
public void CreateAnswerResultWithParameters()
{
const long ActivityAttemptId = 2349;
const long ActivityPackageId = 83294;
const string ActivityTitle = "Some Activity";
long? interactionId = 12382;
const CompletionStatus CompletionStatus = CompletionStatus.NotAttempted;
const SuccessStatus SuccessStatus = SuccessStatus.Failed;
var attemptResult = new AttemptResult();
const string LearnerResponse = "C";
const string CorrectResponse = "-328";
InteractionType?learnerResponseType = Common.Models.Shared.Statistics.InteractionType.Numeric;
float? scaledScore = 0.58f;
float? minScore = 0;
float? maxScore = 50;
float? rawScore = 29;
string primaryResourceFromManifest = "0.html";
var answerResult = new AnswerResult(
ActivityAttemptId,
ActivityPackageId,
ActivityTitle,
interactionId,
CompletionStatus,
SuccessStatus,
attemptResult,
LearnerResponse,
CorrectResponse,
learnerResponseType,
minScore,
maxScore,
rawScore,
scaledScore,
primaryResourceFromManifest);
Assert.AreEqual(ActivityAttemptId, answerResult.ActivityAttemptId);
Assert.AreEqual(ActivityPackageId, answerResult.ActivityPackageId);
Assert.AreEqual(ActivityTitle, answerResult.ActivityTitle);
Assert.AreEqual(interactionId, answerResult.InteractionId);
Assert.AreEqual(CompletionStatus, answerResult.CompletionStatus);
Assert.AreEqual(SuccessStatus, answerResult.SuccessStatus);
Assert.AreSame(attemptResult, answerResult.AttemptResult);
Assert.AreEqual(LearnerResponse, answerResult.LearnerResponse);
Assert.AreEqual(CorrectResponse, answerResult.CorrectResponse);
Assert.AreEqual(learnerResponseType, answerResult.LearnerResponseType);
Assert.AreEqual(scaledScore, answerResult.ScaledScore);
}
public Object UploadAnswers([FromBody] Answer answer)
{
try
{
var verify = dbContext.Answers.Where(c => c.quesId == answer.quesId).Where(c => c.Id == answer.Id).SingleOrDefault();
SuccessStatus s = new SuccessStatus();
s.status = "success";
if (verify == null)
{ //if answer does not exists
dbContext.Answers.Add(answer);
dbContext.SaveChanges();
var var2 = dbContext.Answers.Where(c => c.quesId == answer.quesId).Where(c => c.Id == answer.Id).SingleOrDefault();
Vote v = new Vote()
{
ansId = var2.ansId, votes = 0, Id = "dummy"
};
dbContext.Votes.Add(v);
dbContext.SaveChanges();
s.data = var2;
return(s);
}
else
{ //if answer exists
verify.answer = answer.answer;
dbContext.SaveChanges();
var var2 = dbContext.Answers.Where(c => c.quesId == answer.quesId).Where(c => c.Id == answer.Id).SingleOrDefault();
s.data = var2;
return(s);
}
}
catch (System.Reflection.TargetException e)
{
return(BadRequest(e.Message + e.Data));
}
catch (System.Data.Entity.Infrastructure.DbUpdateException e)
{
return(BadRequest(e.Message));
}
// if user voilates fk contraint
catch (System.Data.Entity.Validation.DbEntityValidationException e) {
return(BadRequest(e.Message));
}
}
public void CreateAttemptResultWithParameters()
{
const long AttemptId = 12312;
const int IudicoCourseRef = 23;
var user = new User();
var curriculumChapterTopic = new CurriculumChapterTopic();
const TopicTypeEnum TopicTypeEnum = TopicTypeEnum.TestWithoutCourse;
const CompletionStatus CompletionStatus = CompletionStatus.Incomplete;
const AttemptStatus AttemptStatus = AttemptStatus.Completed;
const SuccessStatus SuccessStatus = SuccessStatus.Passed;
DateTime? startTime = new DateTime(32478932);
DateTime? finishTime = new DateTime(189041324);
float? score = 0.22f;
float? minScore = 0;
float? maxScore = 50;
float? rawScore = 11;
var attemptResult = new AttemptResult(
AttemptId,
user,
curriculumChapterTopic,
TopicTypeEnum,
CompletionStatus,
AttemptStatus,
SuccessStatus,
startTime,
finishTime,
IudicoCourseRef,
minScore,
maxScore,
rawScore,
score);
Assert.AreEqual(AttemptId, attemptResult.AttemptId);
Assert.AreEqual(user, attemptResult.User);
Assert.AreEqual(curriculumChapterTopic, attemptResult.CurriculumChapterTopic);
Assert.AreEqual(TopicTypeEnum, attemptResult.TopicType);
Assert.AreEqual(CompletionStatus, attemptResult.CompletionStatus);
Assert.AreEqual(AttemptStatus, attemptResult.AttemptStatus);
Assert.AreEqual(SuccessStatus, attemptResult.SuccessStatus);
Assert.AreEqual(startTime, attemptResult.StartTime);
Assert.AreEqual(finishTime, attemptResult.FinishTime);
Assert.AreEqual(score, attemptResult.Score.ScaledScore);
}
/// <summary>
/// Logs a colored message to the console.
/// </summary>
/// <param name="message"></param>
/// <param name="status"></param>
public void LogColoredMessage(string message, SuccessStatus status)
{
switch (status)
{
case SuccessStatus.SUCCESS:
Console.ForegroundColor = ConsoleColor.DarkGreen;
break;
case SuccessStatus.FAILURE:
Console.ForegroundColor = ConsoleColor.Red;
break;
default:
break;
}
Console.WriteLine(message);
Console.ResetColor();
}
public Object UploadVotes(Vote vote)
{
try
{
var votesUser = dbContext.Votes.Where(v => v.ansId == vote.ansId).SingleOrDefault();
SuccessStatus s = new SuccessStatus();
s.status = "success";
if (votesUser.Id == "dummy")
{
votesUser.Id = vote.Id;
votesUser.votes = vote.votes;
dbContext.SaveChanges();
s.data = votesUser;
}
else
{
var existUser = dbContext.Votes.Where(v => v.ansId == vote.ansId).Where(u => u.Id == vote.Id).SingleOrDefault();
if (existUser == null)
{
dbContext.Votes.Add(vote);
s.data = vote;
}
else
{
if (existUser.votes != vote.votes)
{
existUser.votes = 0;
}
}
dbContext.SaveChanges();
s.data = existUser;
}
return(s);
}
catch (NullReferenceException e) {
return(BadRequest(e.Message));
}
}
public Object UpdateAnswer(int qid, int aid)
{
//selecting answers for particular question in answer table
var an = dbContext.Answers.AsEnumerable()
.Where(ans => ans.quesId == qid)
.Join(dbContext.Users.AsEnumerable(),
ans => ans.Id, u => u.Id, (ans, u) => new allAnswers()
{
ansId = ans.ansId,
answer = ans.answer,
userName = u.name
});
//adding votes of a particular answer(having ansId=aid) by different users
var result = dbContext.Votes.Where(ans => ans.ansId == aid).GroupBy(x => x.ansId, (key, values) => new
{
ansid = key,
totalVotes = values.Sum(x => x.votes)
});
//ADD VOTES TO 'an' OBJECT :'an' has all answer details
var final = an.AsEnumerable().Where(ans => ans.ansId == aid)
.Join(result.AsEnumerable(),
ans => ans.ansId, v => v.ansid, (ans, v) => new allAnswers()
{
ansId = ans.ansId,
answer = ans.answer,
userName = ans.userName,
votes = v.totalVotes
});
SuccessStatus s = new SuccessStatus();
s.status = "success";
s.data = final;
return(s);
}
public Object GetQuestions(int pageNumber)
{
var data = dbContext.Questions.AsEnumerable()
.Join(dbContext.Users.AsEnumerable(),
ques => ques.Id, u => u.Id, (ques, u) => new UserQuestion()
{
quesId = ques.quesId,
question = ques.question,
activityDate = ques.activityDate,
userId = u.Id,
userName = u.name
}).OrderByDescending(c => c.activityDate);
var pageSize = 10;
var pageData = data.Skip(pageSize * (pageNumber - 1)).Take(pageSize);
SuccessStatus s = new SuccessStatus();
s.status = "success";
s.data = pageData;
s.records = new records()
{
pageNo = pageNumber,
returned = pageData.Count(),
total = data.Count()
};
s.sort = new sort()
{
field = "ActivityDate",
order = "Desc"
};
return(s);
}
/// <summary>
/// This value is not valid for SCORM 1.2
/// </summary>
/// <param name="value">The value to validate.</param>
public override void ValidateSuccessStatus(SuccessStatus value)
{
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, Resources.OnlyValidForSCORMV1p3, "SuccessStatus"));
}
/// <summary>
/// All enum values are valid.
/// </summary>
/// <param name="value">The value to validate.</param>
public override void ValidateSuccessStatus(SuccessStatus value)
{
switch(value)
{
case SuccessStatus.Failed:
case SuccessStatus.Passed:
case SuccessStatus.Unknown:
break;
default:
throw new ArgumentOutOfRangeException("value");
}
}
public abstract void ValidateSuccessStatus(SuccessStatus value);
public void Finish()
{
if (m_Result.ContainsKey(Symbol.Success))
{
m_SuccessStatus = SuccessStatus.Success;
}
else if (m_Result.ContainsKey(Symbol.Failure))
{
m_SuccessStatus = SuccessStatus.Failure;
}
else
{
m_SuccessStatus = SuccessStatus.Nothing;
}
if (m_Result.ContainsKey(Symbol.Advantage))
{
m_AdvantageStatus = AdvantageStatus.Advantage;
}
else if (m_Result.ContainsKey(Symbol.Threat))
{
m_AdvantageStatus = AdvantageStatus.Threat;
}
else
{
m_AdvantageStatus = AdvantageStatus.Nothing;
}
m_LightCount = m_Result.GetValueOrDefault(Symbol.Light, 0u);
m_DarkCount = m_Result.GetValueOrDefault(Symbol.Dark, 0u);
if (m_LightCount == 0u && m_DarkCount == 0u)
{
m_ForceStatus = ForceStatus.Nothing;
}
else
{
if (m_DarkCount > m_LightCount)
{
if (m_DarkCount == 1)
{
m_ForceStatus = ForceStatus.Dark;
}
else
{
m_ForceStatus = ForceStatus.DoubleDark;
}
}
else
{
if (m_LightCount == 1)
{
m_ForceStatus = ForceStatus.Light;
}
else
{
m_ForceStatus = ForceStatus.DoubleLight;
}
}
}
m_Triumph = m_Result.ContainsKey(Symbol.Triumph);
m_Despair = m_Result.ContainsKey(Symbol.Despair);
Shuffle(m_DieList);
}
public Object GetAnswers(int id, int pageNumber)
{
//selecting answers for particular question in answer table and get details from user table also
var an = dbContext.Answers.AsEnumerable()
.Where(ans => ans.quesId == id)
.Join(dbContext.Users.AsEnumerable(),
ans => ans.Id, u => u.Id, (ans, u) => new allAnswers()
{
ansId = ans.ansId,
answer = ans.answer,
userName = u.name
});
////lis of answer having same quesid
// var myInClause = dbContext.Answers.Where(c=>c.quesId==id).Select(c=>c.ansId);
// //list contains votes of those answers
// var results = from x in dbContext.Votes
// where myInClause.Contains(x.ansId)
// select x;
//shortcut for above code
//selecting votes of answers for particular question
var re = dbContext.Answers.AsEnumerable().Where(c => c.quesId == id)
.Join(dbContext.Votes.AsEnumerable(),
c => c.ansId, v => v.ansId, (c, v) => new
{
v.votes,
v.ansId
});
//adding votes of same answer by different users
var result = re.GroupBy(x => x.ansId, (key, values) => new
{
ansid = key,
totalVotes = values.Sum(x => x.votes)
});
//ADD VOTES TO 'an' OBJECT
var final = an.AsEnumerable()
.Join(result.AsEnumerable(),
ans => ans.ansId, v => v.ansid, (ans, v) => new allAnswers()
{
ansId = ans.ansId,
answer = ans.answer,
userName = ans.userName,
votes = v.totalVotes
}).OrderByDescending(c => c.votes);
var pageSize = 10;
var pageData = final.Skip(pageSize * (pageNumber - 1)).Take(pageSize);
SuccessStatus s = new SuccessStatus();
s.status = "success";
s.data = pageData;
s.records = new records()
{
pageNo = pageNumber,
returned = pageData.Count(),
total = final.Count()
};
s.sort = new sort()
{
field = "votes",
order = "Desc"
};
return(s);
}
public AnswerResult(long activityAttempId, long activityPackageId, string activityTitle, long? interactionId, CompletionStatus completionStatus, SuccessStatus? successStatus, AttemptResult attempResult, object learnerResponse, string correctResponse, InteractionType? learnerResponseType, float? minScore, float? maxScore, float? rawScore, float? scaledScore, string primaryResourceFromManifest)
{
this.ActivityAttemptId = activityAttempId;
this.ActivityPackageId = activityPackageId;
this.ActivityTitle = activityTitle;
this.InteractionId = interactionId;
this.CompletionStatus = completionStatus;
this.SuccessStatus = successStatus;
this.AttemptResult = attempResult;
this.LearnerResponse = learnerResponse;
this.CorrectResponse = correctResponse;
this.LearnerResponseType = learnerResponseType;
this.MinScore = minScore;
this.MaxScore = maxScore;
this.RawScore = rawScore;
this.ScaledScore = scaledScore;
this.PrimaryResourceFromManifest = primaryResourceFromManifest;
}
public abstract void ValidateSuccessStatus(SuccessStatus value);
/// <summary>
/// This value is not valid for SCORM 1.2
/// </summary>
/// <param name="value">The value to validate.</param>
public override void ValidateSuccessStatus(SuccessStatus value)
{
throw new InvalidOperationException(String.Format(CultureInfo.CurrentCulture, Resources.OnlyValidForSCORMV1p3, "SuccessStatus"));
}
public AttemptResult(long attemptId, User user, CurriculumChapterTopic curriculumChapterTopic, TopicTypeEnum topicType, CompletionStatus completionStatus, AttemptStatus attemptStatus, SuccessStatus successStatus, DateTime?startTime, DateTime?finishTime, int iudicoCourseRef, float?minScore, float?maxScore, float?rawScore, float?scaledScore)
{
this.AttemptId = attemptId;
this.User = user;
this.CurriculumChapterTopic = curriculumChapterTopic;
this.TopicType = topicType;
this.CompletionStatus = completionStatus;
this.AttemptStatus = attemptStatus;
this.SuccessStatus = successStatus;
this.StartTime = startTime;
this.FinishTime = finishTime;
this.IudicoCourseRef = iudicoCourseRef;
this.Score = new Score(minScore, maxScore, rawScore, scaledScore);
}
/// <summary>
/// Gets the RTE string that represents the success status.
/// </summary>
public static string GetRteSuccessStatus(SuccessStatus status)
{
switch (status)
{
case SuccessStatus.Failed:
return "failed";
case SuccessStatus.Passed:
return "passed";
default:
return "unknown";
}
}
public static async Task SetStatus(SuccessStatus status)
{
await File.WriteAllLinesAsync(Path, new[] { status.ToString() });
}
public FeedbackDto UpdateSuccessStatus(int feedbackId, SuccessStatus status, string name)
{
try
{
var feedback = _feedbackRepository.Get(feedbackId);
feedback.SuccessStatus = status;
return SaveFeedback(feedback.ToFeedbackDto(), name);
}
catch (Exception ex)
{
_logger.Log(ex);
throw ex;
}
}
