protected void Refresh() { if (dbEntities != null) { dbEntities.Dispose(); } dbEntities = LibraryEntities.Instance(); }
public override object Add(object Obj) { student student = (student)Obj; if (student.id == null) { student.id = StringUtil.GenerateRandomNumber(7); } student newstudent = dbEntities.students.Add(student); try { dbEntities.SaveChanges(); return(newstudent); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; // return null; } catch (System.Data.Entity.Infrastructure.DbUpdateException dbEx) { Exception raise = new Exception(dbEx.StackTrace); dbEntities.Dispose(); dbEntities = LibraryEntities.Instance(); return(null); throw raise; // return null; } }
public override object Add(object Obj) { using (LibraryEntities ctx = LibraryEntities.Instance()) { visit visit = (visit)Obj; visit DBVisit = null; try { DBVisit = ctx.visits.Add(visit); int RES = ctx.SaveChanges(); } catch (Exception e) { DBVisit = null; } return(DBVisit); } }
public student GetByIdFull(string Id) { dbEntities = LibraryEntities.Instance(); try { student student = (from s in dbEntities.students where s.id.Equals(Id) select s).SingleOrDefault(); if (student != null) { student.@class = (from c in dbEntities.classes where c.id.Equals(student.class_id) select c).SingleOrDefault(); } return(student); } catch (InvalidOperationException ex) { return(null); } catch (Exception ex) { return(null); } }