public override BaseEntity Add(object Obj) { position position = (position)Obj; position.created_date = DateTime.Now; dbEntities = new mpi_dbEntities(); position newposition = dbEntities.positions.Add(position); try { dbEntities.SaveChanges(); return(newposition); } 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; } }
public override BaseEntity Update(object Obj) { dbEntities = new mpi_dbEntities(); position position = (position)Obj; position DBposition = (position)GetById(position.id); if (DBposition == null) { return(null); } dbEntities.Entry(DBposition).CurrentValues.SetValues(position); dbEntities.SaveChanges(); return(position); }
public override BaseEntity Update(object Obj) { dbEntities = new mpi_dbEntities(); member Member = (member)Obj; member DBmember = (member)GetById(Member.id); if (DBmember == null) { return(null); } dbEntities.Entry(DBmember).CurrentValues.SetValues(Member); dbEntities.SaveChanges(); return(Member); }
public override BaseEntity Update(object Obj) { dbEntities = new mpi_dbEntities(); program program = (program)Obj; program DBProgram = (program)GetById(program.id); if (DBProgram == null) { return(null); } dbEntities.Entry(DBProgram).CurrentValues.SetValues(program); dbEntities.SaveChanges(); return(program); }
public override bool Delete(object Obj) { try { dbEntities = new mpi_dbEntities(); position position = (position)Obj; dbEntities.positions.Remove(position); dbEntities.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public override bool Delete(object Obj) { try { dbEntities = new mpi_dbEntities(); member member = (member)Obj; dbEntities.members.Remove(member); dbEntities.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public override bool Delete(object Obj) { try { dbEntities = new mpi_dbEntities(); @event @event = (@event)Obj; dbEntities.events.Remove(@event); dbEntities.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public override BaseEntity Update(object Obj) { dbEntities = new mpi_dbEntities(); @event @event = (@event)Obj; @event.created_date = DateTime.Now; @event DBEvent = (@event)GetById(@event.id); if (DBEvent == null) { return(null); } dbEntities.Entry(DBEvent).CurrentValues.SetValues(@event); dbEntities.SaveChanges(); return(@event); }
public override BaseEntity Update(object Obj) { dbEntities = new mpi_dbEntities(); section section = (section)Obj; section DBsection = (section)GetById(section.id); if (DBsection == null) { return(null); } dbEntities.Entry(DBsection).CurrentValues.SetValues(section); try { dbEntities.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); return(null); } return(section); }
public override BaseEntity Add(object Obj) { user user = (user)Obj; if (user.admin == null) { user.admin = 1; } dbEntities = new mpi_dbEntities(); user newUser = dbEntities.users.Add(user); try { dbEntities.SaveChanges(); return(newUser); } 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; } }