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