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