Repository Implementation | C# Online Compiler

Repository Implementation by Jason D Wilson

public class ExamRepository : IExamRepository
    {
        private ExamRepositoryContext _contextfield;
        private ExamRepositoryContext _context
        {
            get
            {
                if (_contextfield == null)
                    _contextfield = new ExamRepositoryContext();
                return _contextfield;
            }
        }
        

        public void Add<T>(T entity) where T : DomainEntityBase
        {
            _context.Set<T>().Add(entity);
            _context.SaveChanges();
        }

        public void AssignExamSourceToReader(int readerId, int examSourceId)
        {
            var reader = _context.Readers.Find(readerId);
            var examSource = _context.ExamSources.Find(examSourceId);
            if (reader != null && examSource != null)
            {
                reader.ExamSources.Add(examSource);
            }
            _context.SaveChanges();
        }


        public void Delete<T>(T entity) where T : DomainEntityBase
        {
            _context.Set<T>().Remove(entity);
            _context.SaveChanges();
        }

        public void Delete<T>(int id) where T : DomainEntityBase
        {
            var entity = _context.Set<T>().Find(id);
            if (entity != null)
                Delete<T>(entity);
        }

        public void Delete<T>(IEnumerable<T> entities) where T : DomainEntityBase
        {

            _context.Set<T>().RemoveRange(entities);
            _context.SaveChanges();
        }
        public void DeletePatients(IEnumerable<Patient> patients)
        {
            _context.Patients.RemoveRange(patients);
            _context.SaveChanges();
        }

        public void DeletePatientsWithoutExams()
        {
            _context.Database.ExecuteSqlCommand("EXEC pr_DeletePatientsWithoutExams");
        }


        public IQueryable<T> Get<T>() where T : DomainEntityBase
        {

            return _context.Set<T>();
        }

        public IQueryable<ExamNoteDiscrepancy> GetDiscrepancies()
        {
            return _context.ExamNoteDiscrepancies
                .Include(d => d.ExamNote).Include(d => d.ExamNote.Reader).Include(d => d.ExamNote.Exam).Include(d => d.ExamNote.Exam.ExamSource)
                .Include(d => d.Reader)
                .Include(d => d.DiscrepancyType);
        }

        public IQueryable<ExamNote> GetExamNotes()
        {
            return _context.ExamNotes
                .Include(n => n.Reader)
                .Include(n => n.Exam);
        }

        public IQueryable<Patient> GetPatients()
        {
            return _context.Patients;
        }

        public IQueryable<Reader> GetReaders()
        {
            return _context.Readers
                .Include(r => r.ExamSources);
        }

        public void RemoveExamSourceFromReader(int readerId, int examSourceId)
        {
            var reader = _context.Readers.Find(readerId);
            var examSource = _context.ExamSources.Find(examSourceId);
            if (reader != null && examSource != null)
            {
                reader.ExamSources.Remove(examSource);
            }
            _context.SaveChanges();
        }
        public void SaveChanges()
        {
            _context.SaveChanges();
        }


        public void Update<T>(T entity) where T : DomainEntityBase
        {
            Update<T>(entity, true);
        }
        public void Update<T>(IEnumerable<T> entities) where T : DomainEntityBase
        {
            foreach (var entity in entities)
                Update<T>(entity, false);
            _context.SaveChanges();
        }

        public void Update<T>(T entity, bool saveChanges) where T : DomainEntityBase
        {
            //We query local context first to see if it's there.
            var attachedEntity = _context.Set<T>().Local.Where(e => e.Id == entity.Id).FirstOrDefault();

            //We have it in the context, need to update.
            if (attachedEntity == null)
                attachedEntity = _context.Set<T>().Find(entity.Id);

            var attachedEntry = _context.Entry(attachedEntity);
            attachedEntry.CurrentValues.SetValues(entity);

            try
            {
                _context.SaveChanges();
            }
            catch (DbEntityValidationException ex)
            {
                // Retrieve the error messages as a list of strings.
                var errorMessages = ex.EntityValidationErrors
                    .SelectMany(x => x.ValidationErrors)
                    .Select(x => x.ErrorMessage);

                // Join the list to a single string.
                var fullErrorMessage = string.Join(";", errorMessages);

                // Combine the original exception message with the new one.
                var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);

                // Throw a new DbEntityValidationException with the improved exception message.
                throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
            }
        }

        #region IDisposable Support
        private bool disposedValue = false; // To detect redundant calls

        protected virtual void Dispose(bool disposing)
        {
            if (!disposedValue)
            {
                if (disposing)
                {
                    // TODO: dispose managed state (managed objects).
                }

                // TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
                // TODO: set large fields to null.
                _context.Dispose();

                disposedValue = true;
            }
        }

        public void Dispose()
        {
            Dispose(true);
        }




        #endregion

    }

​x
 
public class ExamRepository : IExamRepository
    {
        private ExamRepositoryContext _contextfield;
        private ExamRepositoryContext _context
        {
            get
            {
                if (_contextfield == null)
                    _contextfield = new ExamRepositoryContext();
                return _contextfield;
            }
        }
        
​
        public void Add<T>(T entity) where T : DomainEntityBase
        {
            _context.Set<T>().Add(entity);
            _context.SaveChanges();
        }
​
        public void AssignExamSourceToReader(int readerId, int examSourceId)
        {
            var reader = _context.Readers.Find(readerId);
            var examSource = _context.ExamSources.Find(examSourceId);
            if (reader != null && examSource != null)
            {
                reader.ExamSources.Add(examSource);
            }
            _context.SaveChanges();
        }
​
​
        public void Delete<T>(T entity) where T : DomainEntityBase
        {
            _context.Set<T>().Remove(entity);
            _context.SaveChanges();
        }
​
        public void Delete<T>(int id) where T : DomainEntityBase
        {
            var entity = _context.Set<T>().Find(id);
            if (entity != null)
                Delete<T>(entity);
        }
​
        public void Delete<T>(IEnumerable<T> entities) where T : DomainEntityBase
        {
​
            _context.Set<T>().RemoveRange(entities);
            _context.SaveChanges();
        }
        public void DeletePatients(IEnumerable<Patient> patients)
        {
            _context.Patients.RemoveRange(patients);
            _context.SaveChanges();
        }
​
        public void DeletePatientsWithoutExams()
        {
            _context.Database.ExecuteSqlCommand("EXEC pr_DeletePatientsWithoutExams");
        }
​
​
        public IQueryable<T> Get<T>() where T : DomainEntityBase
        {
​
            return _context.Set<T>();
        }
​
        public IQueryable<ExamNoteDiscrepancy> GetDiscrepancies()
        {
            return _context.ExamNoteDiscrepancies
                .Include(d => d.ExamNote).Include(d => d.ExamNote.Reader).Include(d => d.ExamNote.Exam).Include(d => d.ExamNote.Exam.ExamSource)
                .Include(d => d.Reader)
                .Include(d => d.DiscrepancyType);
        }
​
        public IQueryable<ExamNote> GetExamNotes()
        {
            return _context.ExamNotes
                .Include(n => n.Reader)
                .Include(n => n.Exam);
        }
​
        public IQueryable<Patient> GetPatients()
        {
            return _context.Patients;
        }
​
        public IQueryable<Reader> GetReaders()
        {
            return _context.Readers
                .Include(r => r.ExamSources);
        }
​
        public void RemoveExamSourceFromReader(int readerId, int examSourceId)
        {
            var reader = _context.Readers.Find(readerId);
            var examSource = _context.ExamSources.Find(examSourceId);
            if (reader != null && examSource != null)
            {
                reader.ExamSources.Remove(examSource);
            }
            _context.SaveChanges();
        }
        public void SaveChanges()
        {
            _context.SaveChanges();
        }
​
​
        public void Update<T>(T entity) where T : DomainEntityBase
        {
            Update<T>(entity, true);
        }
        public void Update<T>(IEnumerable<T> entities) where T : DomainEntityBase
        {
            foreach (var entity in entities)
                Update<T>(entity, false);
            _context.SaveChanges();
        }
​
        public void Update<T>(T entity, bool saveChanges) where T : DomainEntityBase
        {
            //We query local context first to see if it's there.
            var attachedEntity = _context.Set<T>().Local.Where(e => e.Id == entity.Id).FirstOrDefault();
​
            //We have it in the context, need to update.
            if (attachedEntity == null)
                attachedEntity = _context.Set<T>().Find(entity.Id);
​
            var attachedEntry = _context.Entry(attachedEntity);
            attachedEntry.CurrentValues.SetValues(entity);
​
            try
            {
                _context.SaveChanges();
            }
            catch (DbEntityValidationException ex)
            {
                // Retrieve the error messages as a list of strings.
                var errorMessages = ex.EntityValidationErrors
                    .SelectMany(x => x.ValidationErrors)
                    .Select(x => x.ErrorMessage);
​
                // Join the list to a single string.
                var fullErrorMessage = string.Join(";", errorMessages);
​
                // Combine the original exception message with the new one.
                var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
​
                // Throw a new DbEntityValidationException with the improved exception message.
                throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
            }
        }
​
        #region IDisposable Support
        private bool disposedValue = false; // To detect redundant calls
​
        protected virtual void Dispose(bool disposing)
        {
            if (!disposedValue)
            {
                if (disposing)
                {
                    // TODO: dispose managed state (managed objects).
                }
​
                // TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
                // TODO: set large fields to null.
                _context.Dispose();
​
                disposedValue = true;
            }
        }
​
        public void Dispose()
        {
            Dispose(true);
        }
​
​
​
​
        #endregion
​
    }

2 this is the value of i
4 this is the value of i
6 this is the value of i
8 this is the value of i
10 this is the value of i
12 this is the value of i
14 this is the value of i
16 this is the value of i
18 this is the value of i
20 this is the value of i
22 this is the value of i
24 this is the value of i
26 this is the value of i
28 this is the value of i
30 this is the value of i
32 this is the value of i
34 this is the value of i
36 this is the value of i
38 this is the value of i
40 this is the value of i
42 this is the value of i
44 this is the value of i
46 this is the value of i
48 this is the value of i
50 this is the value of i
52 this is the value of i
54 this is the value of i
56 this is the value of i
58 this is the value of i
60 this is the value of i
62 this is the value of i
64 this is the value of i
66 this is the value of i
68 this is the value of i
70 this is the value of i
72 this is the value of i
74 this is the value of i
76 this is the value of i
78 this is the value of i
80 this is the value of i
82 this is the value of i
84 this is the value of i
86 this is the value of i
88 this is the value of i
90 this is the value of i
92 this is the value of i
94 this is the value of i
96 this is the value of i
98 this is the value of i
100 this is the value of i
102 this is the value of i
104 this is the value of i
106 this is the value of i
108 this is the value of i
110 this is the value of i
112 this is the value of i
114 this is the value of i
116 this is the value of i
118 this is the value of i
120 this is the value of i
122 this is the value of i
124 this is the value of i
126 this is the value of i
128 this is the value of i
130 this is the value of i
132 this is the value of i
134 this is the value of i
136 this is the value of i
138 this is the value of i
140 this is the value of i
142 this is the value of i
144 this is the value of i
146 this is the value of i
148 this is the value of i
150 this is the value of i
152 this is the value of i
154 this is the value of i
156 this is the value of i
158 this is the value of i
160 this is the value of i
162 this is the value of i
164 this is the value of i
166 this is the value of i
168 this is the value of i
170 this is the value of i
172 this is the value of i
174 this is the value of i
176 this is the value of i
178 this is the value of i
180 this is the value of i
182 this is the value of i
184 this is the value of i
186 this is the value of i
188 this is the value of i
190 this is the value of i
192 this is the value of i
194 this is the value of i
196 this is the value of i
198 this is the value of i
200 this is the value of i
202 this is the value of i
204 this is the value of i
206 this is the value of i
208 this is the value of i
210 this is the value of i
212 this is the value of i
214 this is the value of i
216 this is the value of i
218 this is the value of i
220 this is the value of i
222 this is the value of i
224 this is the value of i
226 this is the value of i
228 this is the value of i
230 this is the value of i
232 this is the value of i
234 this is the value of i
236 this is the value of i
238 this is the value of i
240 this is the value of i
242 this is the value of i
244 this is the value of i
246 this is the value of i
248 this is the value of i
250 this is the value of i
252 this is the value of i
254 this is the value of i
256 this is the value of i
258 this is the value of i
260 this is the value of i
262 this is the value of i
264 this is the value of i
266 this is the value of i
268 this is the value of i
270 this is the value of i
272 this is the value of i
274 this is the value of i
276 this is the value of i
278 this is the value of i
280 this is the value of i
282 this is the value of i
284 this is the value of i
286 this is the value of i
288 this is the value of i
290 this is the value of i
292 this is the value of i
294 this is the value of i
296 this is the value of i
298 this is the value of i
300 this is the value of i
302 this is the value of i
304 this is the value of i
306 this is the value of i
308 this is the value of i
310 this is the value of i
312 this is the value of i
314 this is the value of i
316 this is the value of i
318 this is the value of i
320 this is the value of i
322 this is the value of i
324 this is the value of i
326 this is the value of i
328 this is the value of i
330 this is the value of i
332 this is the value of i
334 this is the value of i
336 this is the value of i
338 this is the value of i
340 this is the value of i
342 this is the value of i
344 this is the value of i
346 this is the value of i
348 this is the value of i
350 this is the value of i
352 this is the value of i
354 this is the value of i
356 this is the value of i
358 this is the value of i
360 this is the value of i
362 this is the value of i
364 this is the value of i
366 this is the value of i
368 this is the value of i
370 this is the value of i
372 this is the value of i
374 this is the value of i
376 this is the value of i
378 this is the value of i
380 this is the value of i
382 this is the value of i
384 this is the value of i
386 this is the value of i
388 this is the value of i
390 this is the value of i
392 this is the value of i
394 this is the value of i
396 this is the value of i
398 this is the value of i
400 this is the value of i
402 this is the value of i
404 this is the value of i
406 this is the value of i
408 this is the value of i
410 this is the value of i
412 this is the value of i
414 this is the value of i
416 this is the value of i
418 this is the value of i
420 this is the value of i
422 this is the value of i
424 this is the value of i
426 this is the value of i
428 this is the value of i
430 this is the value of i
432 this is the value of i
434 this is the value of i
436 this is the value of i
438 this is the value of i
440 this is the value of i
442 this is the value of i
444 this is the value of i
446 this is the value of i
448 this is the value of i
450 this is the value of i
452 this is the value of i
454 this is the value of i
456 this is the value of i
458 this is the value of i
460 this is the value of i
462 this is the value of i
464 this is the value of i
466 this is the value of i
468 this is the value of i
470 this is the value of i
472 this is the value of i
474 this is the value of i
476 this is the value of i
478 this is the value of i
480 this is the value of i
482 this is the value of i
484 this is the value of i
486 this is the value of i
488 this is the value of i
490 this is the value of i
492 this is the value of i
494 this is the value of i
496 this is the value of i
498 this is the value of i
500 this is the value of i

Cached Result
Last Run:	12:16:29 am
Compile:	0.186s
Execute:	0s
Memory:	80.05kb
CPU:	0s

View IL Code