public int Insert(Spartane.Core.Classes.Spartan_BR_Operation_Detail.Spartan_BR_Operation_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 padreOperation = _dataProvider.GetParameter(); padreOperation.ParameterName = "Operation"; padreOperation.DbType = DbType.Int16; padreOperation.Value = (object)entity.Operation ?? DBNull.Value; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Operation_Detail>("sp_InsSpartan_BR_Operation_Detail", padreBusiness_Rule , padreOperation ).FirstOrDefault(); rta = Convert.ToInt32(empEntity.OperationDetailId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }
public int Update(Spartane.Core.Classes.Spartan_BR_Operation_Detail.Spartan_BR_Operation_Detail entity) { int rta; try { var paramUpdOperationDetailId = _dataProvider.GetParameter(); paramUpdOperationDetailId.ParameterName = "OperationDetailId"; paramUpdOperationDetailId.DbType = DbType.Int32; paramUpdOperationDetailId.Value = entity.OperationDetailId; var paramUpdBusiness_Rule = _dataProvider.GetParameter(); paramUpdBusiness_Rule.ParameterName = "Business_Rule"; paramUpdBusiness_Rule.DbType = DbType.Int32; paramUpdBusiness_Rule.Value = entity.Business_Rule; var paramUpdOperation = _dataProvider.GetParameter(); paramUpdOperation.ParameterName = "Operation"; paramUpdOperation.DbType = DbType.Int16; if (entity.Operation == null) { paramUpdOperation.Value = DBNull.Value; } else { paramUpdOperation.Value = entity.Operation; } var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Operation_Detail>("sp_UpdSpartan_BR_Operation_Detail", paramUpdOperationDetailId, paramUpdBusiness_Rule).FirstOrDefault(); rta = Convert.ToInt32(empEntity.OperationDetailId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }