private IActionResult GetAllGrades()
{
IList <GradesEF> students = null;
using (var grd = new GradesContext())
{
students = grd.SGradesEF
.Select(s => new GradesEF()
{
No = s.No,
name = s.name,
math = s.math,
serb = s.serb,
phys = s.phys,
chem = s.chem,
bio = s.bio,
rule = s.rule,
averageRating = s.averageRating
}).ToList();
}
if (students.Count == 0)
{
return(NotFound());
}
return(Ok(students));
}
public IEnumerable <GradesEF> Get()
{
using (GradesContext grd = new GradesContext())
{
List <GradesEF> gradeList = grd.SGradesEF.ToList();
return(gradeList);
}
}
public IEnumerable <GradesEF> Get()
{
using GradesContext grades = new GradesContext();
var all = from c in grades.SGradesEF select c;
grades.SGradesEF.RemoveRange(all);
grades.SaveChanges();
return(null);
}
public IEnumerable <Grades> Get(string?filename)
{
int i = 1, tempi = 0;
var _gradesService = new GradesService();
var path = "wwwroot/" + filename;
//pozivamo funkciju koja cita CSV fajl
if (System.IO.File.Exists(path))
{
var resultData = _gradesService.ReadCSVFile(path);
using (GradesContext grade = new GradesContext())
{
if (grade.SGradesEF.Any())
{
IOrderedQueryable <int> gr = (IOrderedQueryable <int>)grade.SGradesEF.Select(s => Convert.ToInt32(s.No));
i = gr.ToArray().Max() + 1;
}
else
{
i = 1;
}
}
//Kreiramo objekat Grades klase
foreach (Grades result in resultData)
{
tempi = result.serb + result.math + result.phys + result.chem + result.bio + result.rule;
result.averageGrade = tempi / 6F;
//Pozivamo funkciju za upisivanje rezultata
WriteToDatabase(i, result);
i++;
}
//definisanje CSV File name "average.csv", u koji ce biti izvrsen upis u csv file
_gradesService.WriteCSVFile("wwwroot/average.csv", resultData);
return(resultData);
}
else
{
return(null);
}
}
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
using GradesContext grades = new GradesContext();
GradesEF pera = new GradesEF()
{
No = "1",
name = "Pera Mitic",
math = 3,
serb = 4,
phys = 5,
chem = 3,
bio = 4,
rule = 5
};
grades.Add(pera);
grades.SaveChanges();
}
private static void WriteToDatabase(int ind, Grades student)
{
using GradesContext grades = new GradesContext();
GradesEF newStudent = new GradesEF()
{
No = ind.ToString(),
name = student.name,
math = student.math,
serb = student.serb,
phys = student.phys,
chem = student.chem,
bio = student.bio,
rule = student.rule,
averageRating = Convert.ToDecimal(student.averageGrade)
};
grades.Add(newStudent);
grades.SaveChanges();
}
public IEnumerable <GradesEF> Get(string no)
{
List <GradesEF> gradeList = new List <GradesEF>();
//read from localDB
using (GradesContext grd = new GradesContext())
{
gradeList = grd.SGradesEF.ToList();
}
if (no == null)
{
return(gradeList);
}
else
{
return(new List <GradesEF>()
{
gradeList.Find(s => s.No == no)
});
}
}
public GradebookDB(GradesContext db)
{
_db = db;
}
public GradeRepository(GradesContext context)
{
_context = context;
}
public SubjectManipulatorDB(GradesContext db)
{
_db = db;
}
