public bool Insert(DailyScore dailyScoreParam)
{
var result = 0;
dailyScore.Date = DateTimeOffset.Now.LocalDateTime;
dailyScore.Score1 = dailyScoreParam.Score1;
dailyScore.Score2 = dailyScoreParam.Score1;
dailyScore.Score3 = dailyScoreParam.Score1;
dailyScore.Students.Id = dailyScoreParam.Students.Id;
dailyScore.Employees.Id = dailyScoreParam.Employees.Id;
dailyScore.Lessons.Id = dailyScoreParam.Lessons.Id;
dailyScore.CreateDate = DateTimeOffset.Now.LocalDateTime;
_context.DailyScores.Add(dailyScore);
result = _context.SaveChanges();
if (result > 0)
{
status = true;
MessageBox.Show("Insert Successfully");
}
else
{
MessageBox.Show("Insert Failed");
}
return(status);
}
public bool Update(int?id, DailyScore dailyScoreParam)
{
var result = 0;
var dailyScore = Get(id);
dailyScore.Date = DateTimeOffset.Now.LocalDateTime;
dailyScore.Score1 = dailyScoreParam.Score1;
dailyScore.Score2 = dailyScoreParam.Score1;
dailyScore.Score3 = dailyScoreParam.Score1;
dailyScore.Students.Id = dailyScoreParam.Students.Id;
dailyScore.Employees.Id = dailyScoreParam.Employees.Id;
dailyScore.Lessons.Id = dailyScoreParam.Lessons.Id;
dailyScore.UpdateDate = DateTimeOffset.Now.LocalDateTime;
result = _context.SaveChanges();
if (result > 0)
{
status = true;
MessageBox.Show("Update Successfully");
Console.Read();
}
else
{
MessageBox.Show("Update Failed");
}
return(status);
}
public IHttpActionResult SaveScore(DailyScore score)
{
using (TestDbEntities db = new TestDbEntities())
{
var entry = db.Scores.FirstOrDefault();
if (entry != null)
{
List <DailyScore> scores = JsonConvert.DeserializeObject <List <DailyScore> >(entry.JsonData ?? string.Empty);
scores.Add(score);
entry.JsonData = JsonConvert.SerializeObject(scores);
db.SaveChanges();
}
else
{
Score newScore = new Score();
List <DailyScore> scores = new List <DailyScore>();
scores.Add(score);
newScore.JsonData = JsonConvert.SerializeObject(scores);
db.Scores.Add(newScore);
db.SaveChanges();
}
return(Ok());
}
}
/// <summary>
/// 投票平均スコアを文字列化
/// </summary>
/// <param name="score"></param>
/// <returns></returns>
static string averageVote(DailyScore score)
{
if (score.Votes < 0)
{
return("");
}
else if (score.Votes == 0)
{
return("0.0");
}
else
{
var voteScore = score.VoteScore / (score.Votes * 2.0);
return(voteScore.ToString("0.0"));
}
}
