public bool CreateExampleStudents(int count = 100)
{
try
{
IList <Students> _students = new List <Students>();
for (var i = 0; i < count; i++)
{
DateTime dateTime = new DateTime(DateTime.Now.Year - new Random().Next(18, 100), new Random().Next(1, 12), 1).AddDays(new Random().Next(0, 31));
_students.Add(new Students()
{
Id = NetAppCommon.Helpers.Object.ObjectHelper.GuidFromString(i.ToString("D8")), Name = string.Format("{0} {1}", "Imię", i.ToString("D8")), Surname = string.Format("{0} {1}", "Nazwisko", i.ToString("D8")), DateOfBirth = dateTime, IndexNumber = i.ToString("D8")
});
}
try
{
Log4net.Info($"Remove tmp data { _students.Count() }");
_context.Students.RemoveRange(_context.Students.ToList());
_context.SaveChanges();
}
catch (Exception e)
{
Log4net.Error(string.Format("\n{0}\n{1}\n{2}\n{3}\n", e.GetType(), e.InnerException?.GetType(), e.Message, e.StackTrace), e);
}
try
{
Log4net.Info($"Add tmp data { _students }");
_context.AddRange(_students.ToList());
_context.SaveChanges();
}
catch (Exception e)
{
Log4net.Error(string.Format("\n{0}\n{1}\n{2}\n{3}\n", e.GetType(), e.InnerException?.GetType(), e.Message, e.StackTrace), e);
}
return(true);
}
catch (Exception e)
{
Log4net.Error(string.Format("\n{0}\n{1}\n{2}\n{3}\n", e.GetType(), e.InnerException?.GetType(), e.Message, e.StackTrace), e);
}
return(false);
}
public IEnumerable <StudentsGrades> Add(Students student, decimal grade)
{
StudentsGrades studentsGrades = null;
try
{
studentsGrades = new StudentsGrades {
StudentId = student.Id, Grade = grade
};
_context.Entry(studentsGrades).State = EntityState.Added;
_context.SaveChanges();
_studentsGrades = _context.StudentsGrades.Where(w => w.StudentId == student.Id).ToList();
}
catch (Exception e)
{
Log4net.Error(string.Format("\n{0}\n{1}\n{2}\n{3}\n", e.GetType(), e.InnerException?.GetType(), e.Message, e.StackTrace), e);
}
return(_studentsGrades);
}
