public bool Insert(DailyScoreParam dailyScoreParam)
{
var result = 0;
dailyScore.Date = DateTimeOffset.Now.LocalDateTime;
dailyScore.Score1 = dailyScoreParam.Score1;
dailyScore.Score2 = dailyScoreParam.Score2;
dailyScore.Score3 = dailyScoreParam.Score3;
dailyScore.students = _context.Students.Find(Convert.ToInt16(dailyScoreParam.Students));
dailyScore.employees = _context.Employees.Find(Convert.ToInt16(dailyScoreParam.Employees));
dailyScore.lessons = _context.Lessons.Find(Convert.ToInt16(dailyScoreParam.Lessons));
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, DailyScoreParam dailyScoreParam)
{
var result = 0;
var dailyScore = Get(id);
dailyScore.Date = DateTimeOffset.Now.LocalDateTime;
dailyScore.Score1 = dailyScoreParam.Score1;
dailyScore.Score2 = dailyScoreParam.Score2;
dailyScore.Score3 = dailyScoreParam.Score3;
dailyScore.students = _context.Students.Find(Convert.ToInt16(dailyScoreParam.Students));
dailyScore.employees = _context.Employees.Find(Convert.ToInt16(dailyScoreParam.Employees));
dailyScore.lessons = _context.Lessons.Find(Convert.ToInt16(dailyScoreParam.Lessons));
dailyScore.UpdateDate = DateTimeOffset.Now.LocalDateTime;
result = _context.SaveChanges();
if (result > 0)
{
status = true;
MessageBox.Show("Update Successfully");
}
else
{
MessageBox.Show("Update Failed");
}
return(status);
}
public bool Insert(DailyScoreParam dailyScoreParam)
{
if (dailyScoreParam.Score1.ToString() == " ")
{
MessageBox.Show("Don't insert white space");
}
else
{
//status = _dailyScoreRepository.Insert(dailyScoreParam);
}
return(status);
}
public bool Update(int?id, DailyScoreParam dailyScoreParam)
{
if (_dailyScoreRepository.Get(id) == null)
{
MessageBox.Show("Sorry, your data is not found");
}
else if (id.ToString() == " ")
{
MessageBox.Show("Don't insert white space in Id");
}
else
{
if (dailyScoreParam.Score1.ToString() == " ")
{
MessageBox.Show("Don't insert white space in Name");
}
else
{
status = _dailyScoreRepository.Update(id, dailyScoreParam);
}
}
return(status);
}
