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); }