public int Insert(Spartane.Core.Classes.Spartan_BR_Process_Event_Detail.Spartan_BR_Process_Event_Detail entity)
        {
            int rta;

            try
            {
                var padreBusiness_Rule = _dataProvider.GetParameter();
                padreBusiness_Rule.ParameterName = "Business_Rule";
                padreBusiness_Rule.DbType        = DbType.Int32;
                padreBusiness_Rule.Value         = (object)entity.Business_Rule ?? DBNull.Value;
                var padreProcess_Event = _dataProvider.GetParameter();
                padreProcess_Event.ParameterName = "Process_Event";
                padreProcess_Event.DbType        = DbType.Int16;
                padreProcess_Event.Value         = (object)entity.Process_Event ?? DBNull.Value;



                var empEntity =
                    _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Process_Event_Detail>("sp_InsSpartan_BR_Process_Event_Detail", padreBusiness_Rule
                                                                                                                                        , padreProcess_Event
                                                                                                                                        ).FirstOrDefault();

                rta = Convert.ToInt32(empEntity.ProcessEventDetailId);
            }
            catch (ExceptionBase ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new ServiceException(ex.Message, ex);
            }

            return(rta);
        }
        public int Update(Spartane.Core.Classes.Spartan_BR_Process_Event_Detail.Spartan_BR_Process_Event_Detail entity)
        {
            int rta;

            try
            {
                var paramUpdProcessEventDetailId = _dataProvider.GetParameter();
                paramUpdProcessEventDetailId.ParameterName = "ProcessEventDetailId";
                paramUpdProcessEventDetailId.DbType        = DbType.Int32;
                paramUpdProcessEventDetailId.Value         = entity.ProcessEventDetailId;
                var paramUpdBusiness_Rule = _dataProvider.GetParameter();
                paramUpdBusiness_Rule.ParameterName = "Business_Rule";
                paramUpdBusiness_Rule.DbType        = DbType.Int32;
                paramUpdBusiness_Rule.Value         = entity.Business_Rule;
                var paramUpdProcess_Event = _dataProvider.GetParameter();
                paramUpdProcess_Event.ParameterName = "Process_Event";
                paramUpdProcess_Event.DbType        = DbType.Int16;
                if (entity.Process_Event == null)
                {
                    paramUpdProcess_Event.Value = DBNull.Value;
                }
                else
                {
                    paramUpdProcess_Event.Value = entity.Process_Event;
                }



                var empEntity =
                    _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Process_Event_Detail>("sp_UpdSpartan_BR_Process_Event_Detail", paramUpdProcessEventDetailId, paramUpdBusiness_Rule, paramUpdProcess_Event).FirstOrDefault();

                rta = Convert.ToInt32(empEntity.ProcessEventDetailId);
            }
            catch (ExceptionBase ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new ServiceException(ex.Message, ex);
            }

            return(rta);
        }