public int Update(Spartane.Core.Classes.Spartan_BR_Actions_True_Detail.Spartan_BR_Actions_True_Detail entity) { int rta; try { //CAMBIOS MANUALES var paramUpdActionsTrueDetailId = _dataProvider.GetParameter(); paramUpdActionsTrueDetailId.ParameterName = "ActionsTrueDetailId"; paramUpdActionsTrueDetailId.DbType = DbType.Int32; paramUpdActionsTrueDetailId.Value = (object)entity.ActionsTrueDetailId ?? DBNull.Value; //entity.ActionsTrueDetailId; var paramUpdBusiness_Rule = _dataProvider.GetParameter(); paramUpdBusiness_Rule.ParameterName = "Business_Rule"; paramUpdBusiness_Rule.DbType = DbType.Int32; paramUpdBusiness_Rule.Value = (object)entity.Business_Rule ?? DBNull.Value; //entity.Business_Rule; var paramUpdAction_Classification = _dataProvider.GetParameter(); paramUpdAction_Classification.ParameterName = "Action_Classification"; paramUpdAction_Classification.DbType = DbType.Int16; if (entity.Action_Classification == null) { paramUpdAction_Classification.Value = DBNull.Value; } else { paramUpdAction_Classification.Value = entity.Action_Classification; } var paramUpdAction = _dataProvider.GetParameter(); paramUpdAction.ParameterName = "Action"; paramUpdAction.DbType = DbType.Int32; if (entity.Action == null) { paramUpdAction.Value = DBNull.Value; } else { paramUpdAction.Value = entity.Action; } var paramUpdAction_Result = _dataProvider.GetParameter(); paramUpdAction_Result.ParameterName = "Action_Result"; paramUpdAction_Result.DbType = DbType.Int16; if (entity.Action_Result == null) { paramUpdAction_Result.Value = DBNull.Value; } else { paramUpdAction_Result.Value = entity.Action_Result; } var paramUpdParameter_1 = _dataProvider.GetParameter(); paramUpdParameter_1.ParameterName = "Parameter_1"; paramUpdParameter_1.DbType = DbType.String; paramUpdParameter_1.Value = (object)entity.Parameter_1 ?? DBNull.Value; //entity.Parameter_1; var paramUpdParameter_2 = _dataProvider.GetParameter(); paramUpdParameter_2.ParameterName = "Parameter_2"; paramUpdParameter_2.DbType = DbType.String; paramUpdParameter_2.Value = (object)entity.Parameter_2 ?? DBNull.Value; //entity.Parameter_2; var paramUpdParameter_3 = _dataProvider.GetParameter(); paramUpdParameter_3.ParameterName = "Parameter_3"; paramUpdParameter_3.DbType = DbType.String; paramUpdParameter_3.Value = (object)entity.Parameter_3 ?? DBNull.Value; //entity.Parameter_3; var paramUpdParameter_4 = _dataProvider.GetParameter(); paramUpdParameter_4.ParameterName = "Parameter_4"; paramUpdParameter_4.DbType = DbType.String; paramUpdParameter_4.Value = (object)entity.Parameter_4 ?? DBNull.Value; //entity.Parameter_4; var paramUpdParameter_5 = _dataProvider.GetParameter(); paramUpdParameter_5.ParameterName = "Parameter_5"; paramUpdParameter_5.DbType = DbType.String; paramUpdParameter_5.Value = (object)entity.Parameter_5 ?? DBNull.Value; //entity.Parameter_5; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Actions_True_Detail>("sp_UpdSpartan_BR_Actions_True_Detail", paramUpdActionsTrueDetailId, paramUpdBusiness_Rule, paramUpdAction_Classification, paramUpdAction, paramUpdAction_Result, paramUpdParameter_1, paramUpdParameter_2, paramUpdParameter_3, paramUpdParameter_4, paramUpdParameter_5).FirstOrDefault(); rta = Convert.ToInt32(empEntity.ActionsTrueDetailId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }
public int Insert(Spartane.Core.Classes.Spartan_BR_Actions_True_Detail.Spartan_BR_Actions_True_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 padreAction_Classification = _dataProvider.GetParameter(); padreAction_Classification.ParameterName = "Action_Classification"; padreAction_Classification.DbType = DbType.Int16; padreAction_Classification.Value = (object)entity.Action_Classification ?? DBNull.Value; var padreAction = _dataProvider.GetParameter(); padreAction.ParameterName = "Action"; padreAction.DbType = DbType.Int32; padreAction.Value = (object)entity.Action ?? DBNull.Value; var padreAction_Result = _dataProvider.GetParameter(); padreAction_Result.ParameterName = "Action_Result"; padreAction_Result.DbType = DbType.Int16; padreAction_Result.Value = (object)entity.Action_Result ?? DBNull.Value; var padreParameter_1 = _dataProvider.GetParameter(); padreParameter_1.ParameterName = "Parameter_1"; padreParameter_1.DbType = DbType.String; padreParameter_1.Value = (object)entity.Parameter_1 ?? DBNull.Value; var padreParameter_2 = _dataProvider.GetParameter(); padreParameter_2.ParameterName = "Parameter_2"; padreParameter_2.DbType = DbType.String; padreParameter_2.Value = (object)entity.Parameter_2 ?? DBNull.Value; var padreParameter_3 = _dataProvider.GetParameter(); padreParameter_3.ParameterName = "Parameter_3"; padreParameter_3.DbType = DbType.String; padreParameter_3.Value = (object)entity.Parameter_3 ?? DBNull.Value; var padreParameter_4 = _dataProvider.GetParameter(); padreParameter_4.ParameterName = "Parameter_4"; padreParameter_4.DbType = DbType.String; padreParameter_4.Value = (object)entity.Parameter_4 ?? DBNull.Value; var padreParameter_5 = _dataProvider.GetParameter(); padreParameter_5.ParameterName = "Parameter_5"; padreParameter_5.DbType = DbType.String; padreParameter_5.Value = (object)entity.Parameter_5 ?? DBNull.Value; var empEntity = _dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Actions_True_Detail>("sp_InsSpartan_BR_Actions_True_Detail", padreBusiness_Rule , padreAction_Classification , padreAction , padreAction_Result , padreParameter_1 , padreParameter_2 , padreParameter_3 , padreParameter_4 , padreParameter_5 ).FirstOrDefault(); rta = Convert.ToInt32(empEntity.ActionsTrueDetailId); } catch (ExceptionBase ex) { throw ex; } catch (Exception ex) { throw new ServiceException(ex.Message, ex); } return(rta); }