public int Update(Spartane.Core.Classes.Spartan_BR_Action.Spartan_BR_Action entity) { int rta; try { var paramUpdActionId = _dataProvider.GetParameter(); paramUpdActionId.ParameterName = "ActionId"; paramUpdActionId.DbType = DbType.Int32; paramUpdActionId.Value = entity.ActionId; var paramUpdDescription = _dataProvider.GetParameter(); paramUpdDescription.ParameterName = "Description"; paramUpdDescription.DbType = DbType.String; paramUpdDescription.Value = entity.Description; var paramUpdClassification = _dataProvider.GetParameter(); paramUpdClassification.ParameterName = "Classification"; paramUpdClassification.DbType = DbType.Int16; if (entity.Classification == null) { paramUpdClassification.Value = DBNull.Value; } else { paramUpdClassification.Value = entity.Classification; } var paramUpdImplementation_Code = _dataProvider.GetParameter(); paramUpdImplementation_Code.ParameterName = "Implementation_Code"; paramUpdImplementation_Code.DbType = DbType.String; paramUpdImplementation_Code.Value = entity.Implementation_Code; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Action>("sp_UpdSpartan_BR_Action", paramUpdActionId, paramUpdDescription, paramUpdClassification, paramUpdImplementation_Code).FirstOrDefault(); rta = Convert.ToInt32(empEntity.ActionId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }
public int Insert(Spartane.Core.Classes.Spartan_BR_Action.Spartan_BR_Action entity) { int rta; try { var padreDescription = _dataProvider.GetParameter(); padreDescription.ParameterName = "Description"; padreDescription.DbType = DbType.String; padreDescription.Value = (object)entity.Description ?? DBNull.Value; var padreClassification = _dataProvider.GetParameter(); padreClassification.ParameterName = "Classification"; padreClassification.DbType = DbType.Int16; padreClassification.Value = (object)entity.Classification ?? DBNull.Value; var padreImplementation_Code = _dataProvider.GetParameter(); padreImplementation_Code.ParameterName = "Implementation_Code"; padreImplementation_Code.DbType = DbType.String; padreImplementation_Code.Value = (object)entity.Implementation_Code ?? DBNull.Value; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Action>("sp_InsSpartan_BR_Action", padreDescription , padreClassification , padreImplementation_Code ).FirstOrDefault(); rta = Convert.ToInt32(empEntity.ActionId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }