public async Task <IActionResult> PutEmpmtr(string id, Empmtr empmtr)
{
if (id != empmtr.EmpNo)
{
return(BadRequest());
}
_context.Entry(empmtr).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmpmtrExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult worstTeacherWithTiming()
{
var data = _context.Eval.Where(q => q.QuestionDesc.Equals(11)).GroupBy(q => q.EmpNo)
.Select((x) => new { empNo = x.Key, points = x.Average(q => q.AnswerMarks) }).OrderBy(q => q.points).ToList();
Empmtr empmtr = new Empmtr();
//foreach (var item in data)
//{
empmtr = _context.Empmtr.Where(e => e.EmpNo.Equals(data[1].empNo)).FirstOrDefault();
//}
return(new JsonResult(empmtr));
}
public ActionResult getpoorTeacher(int id)
{
var data = _context.Eval.Where(q => q.QuestionDesc.Equals(id)).GroupBy(q => q.EmpNo)
.Select((x) => new { empNo = x.Key, points = x.Average(q => q.AnswerMarks) }).OrderBy(q => q.points).ToList();
Empmtr empmtr = new Empmtr();
//foreach (var item in data)
//{
empmtr = _context.Empmtr.Where(e => e.EmpNo.Equals((id == 1)?data[0].empNo: data[2].empNo)).FirstOrDefault();
//}
return(new JsonResult(empmtr));
}
public async Task <ActionResult <Empmtr> > PostEmpmtr(Empmtr empmtr)
{
_context.Empmtr.Add(empmtr);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (EmpmtrExists(empmtr.EmpNo))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetEmpmtr", new { id = empmtr.EmpNo }, empmtr));
}