protected DbOperationStatus Save()
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
AffectedIndices = null
};
try
{
opStatus.OperationSuccessStatus = DataContext.SaveChanges() > 0;
}
catch (Exception ex)
{
opStatus = DbOperationStatus.CreateFromException("Error saving.", ex);
}
return(opStatus);
}
public static DbOperationStatus CreateFromException(string statusMessage, Exception ex)
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
Message = statusMessage,
AffectedIndices = null
};
if (ex != null)
{
opStatus.ExceptionMessage = ex.Message;
opStatus.ExceptionStackTrace = ex.StackTrace;
opStatus.ExceptionInnerMessage = (ex.InnerException != null) ? ex.InnerException.Message : null;
opStatus.ExceptionInnerStackTrace = (ex.InnerException != null) ? ex.InnerException.StackTrace : null;
}
return(opStatus);
}
public static DbOperationStatus CreateFromException(string statusMessage, Exception ex)
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
Message = statusMessage,
AffectedIndices = null
};
if (ex != null)
{
opStatus.ExceptionMessage = ex.Message;
opStatus.ExceptionStackTrace = ex.StackTrace;
opStatus.ExceptionInnerMessage = (ex.InnerException != null) ? ex.InnerException.Message : null;
opStatus.ExceptionInnerStackTrace = (ex.InnerException != null) ? ex.InnerException.StackTrace : null;
}
return opStatus;
}
protected DbOperationStatus DeleteEntity <TE>(TE entity) where TE : class
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
AffectedIndices = null
};
try
{
DataContext.Set <TE>().Remove(entity);
opStatus.OperationSuccessStatus = DataContext.SaveChanges() > 0;
}
catch (Exception ex)
{
opStatus = DbOperationStatus.CreateFromException("Error deleting " + entity.GetType(), ex);
}
return(opStatus);
}
protected DbOperationStatus Insert(T entity)
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
AffectedIndices = null
};
try
{
DataContext.Set <T>().Add(entity);
opStatus.OperationSuccessStatus = DataContext.SaveChanges() > 0;
}
catch (Exception ex)
{
opStatus = DbOperationStatus.CreateFromException("Error inserting " + entity.GetType(), ex);
}
return(opStatus);
}
protected DbOperationStatus UpdateEntity <TE>(TE entity) where TE : class
{
var opStatus = new DbOperationStatus
{
OperationSuccessStatus = false,
AffectedIndices = null
};
try
{
DataContext.Set <TE>().Attach(entity);
DataContext.Entry(entity).State = EntityState.Modified;
opStatus.OperationSuccessStatus = DataContext.SaveChanges() > 0;
}
catch (Exception ex)
{
opStatus = DbOperationStatus.CreateFromException("Error updating " + entity.GetType(), ex);
}
return(opStatus);
}
public DbOperationStatus ExecuteStoredProcedure(string command)
{
if (command == null)
{
throw new ArgumentException("The stored procedure must be provided");
}
var opStatus = new DbOperationStatus {
OperationSuccessStatus = false
};
try
{
opStatus.OperationSuccessStatus = DataContext.Database.ExecuteSqlCommand(command) > 0;
}
catch (Exception ex)
{
opStatus = DbOperationStatus.CreateFromException("Error executing Stored Procedure", ex);
}
return(opStatus);
}