public int Update(Spartane.Core.Classes.Spartan_BR_Conditions_Detail.Spartan_BR_Conditions_Detail entity)
{
int rta;
try
{
var paramUpdConditionsDetailId = _dataProvider.GetParameter();
paramUpdConditionsDetailId.ParameterName = "ConditionsDetailId";
paramUpdConditionsDetailId.DbType = DbType.Int32;
paramUpdConditionsDetailId.Value = entity.ConditionsDetailId;
var paramUpdBusiness_Rule = _dataProvider.GetParameter();
paramUpdBusiness_Rule.ParameterName = "Business_Rule";
paramUpdBusiness_Rule.DbType = DbType.Int32;
paramUpdBusiness_Rule.Value = entity.Business_Rule;
var paramUpdCondition_Operator = _dataProvider.GetParameter();
paramUpdCondition_Operator.ParameterName = "Condition_Operator";
paramUpdCondition_Operator.DbType = DbType.Int16;
if (entity.Condition_Operator == null)
{
paramUpdCondition_Operator.Value = DBNull.Value;
}
else
{
paramUpdCondition_Operator.Value = entity.Condition_Operator;
}
var paramUpdFirst_Operator_Type = _dataProvider.GetParameter();
paramUpdFirst_Operator_Type.ParameterName = "First_Operator_Type";
paramUpdFirst_Operator_Type.DbType = DbType.Int32;
if (entity.First_Operator_Type == null)
{
paramUpdFirst_Operator_Type.Value = DBNull.Value;
}
else
{
paramUpdFirst_Operator_Type.Value = entity.First_Operator_Type;
}
var paramUpdFirst_Operator_Value = _dataProvider.GetParameter();
paramUpdFirst_Operator_Value.ParameterName = "First_Operator_Value";
paramUpdFirst_Operator_Value.DbType = DbType.String;
paramUpdFirst_Operator_Value.Value = entity.First_Operator_Value;
var paramUpdCondition = _dataProvider.GetParameter();
paramUpdCondition.ParameterName = "Condition";
paramUpdCondition.DbType = DbType.Int16;
if (entity.Condition == null)
{
paramUpdCondition.Value = DBNull.Value;
}
else
{
paramUpdCondition.Value = entity.Condition;
}
var paramUpdSecond_Operator_Type = _dataProvider.GetParameter();
paramUpdSecond_Operator_Type.ParameterName = "Second_Operator_Type";
paramUpdSecond_Operator_Type.DbType = DbType.Int32;
if (entity.Second_Operator_Type == null)
{
paramUpdSecond_Operator_Type.Value = DBNull.Value;
}
else
{
paramUpdSecond_Operator_Type.Value = entity.Second_Operator_Type;
}
var paramUpdSecond_Operator_Value = _dataProvider.GetParameter();
paramUpdSecond_Operator_Value.ParameterName = "Second_Operator_Value";
paramUpdSecond_Operator_Value.DbType = DbType.String;
paramUpdSecond_Operator_Value.Value = entity.Second_Operator_Value;
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Conditions_Detail>("sp_UpdSpartan_BR_Conditions_Detail",
paramUpdConditionsDetailId,
paramUpdBusiness_Rule,
paramUpdCondition_Operator,
paramUpdFirst_Operator_Type,
paramUpdFirst_Operator_Value,
paramUpdCondition,
paramUpdSecond_Operator_Type,
paramUpdSecond_Operator_Value).FirstOrDefault();
rta = Convert.ToInt32(empEntity.ConditionsDetailId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
public int Insert(Spartane.Core.Classes.Spartan_BR_Conditions_Detail.Spartan_BR_Conditions_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 padreCondition_Operator = _dataProvider.GetParameter();
padreCondition_Operator.ParameterName = "Condition_Operator";
padreCondition_Operator.DbType = DbType.Int16;
padreCondition_Operator.Value = (object)entity.Condition_Operator ?? DBNull.Value;
var padreFirst_Operator_Type = _dataProvider.GetParameter();
padreFirst_Operator_Type.ParameterName = "First_Operator_Type";
padreFirst_Operator_Type.DbType = DbType.Int32;
padreFirst_Operator_Type.Value = (object)entity.First_Operator_Type ?? DBNull.Value;
var padreFirst_Operator_Value = _dataProvider.GetParameter();
padreFirst_Operator_Value.ParameterName = "First_Operator_Value";
padreFirst_Operator_Value.DbType = DbType.String;
padreFirst_Operator_Value.Value = (object)entity.First_Operator_Value ?? DBNull.Value;
var padreCondition = _dataProvider.GetParameter();
padreCondition.ParameterName = "Condition";
padreCondition.DbType = DbType.Int16;
padreCondition.Value = (object)entity.Condition ?? DBNull.Value;
var padreSecond_Operator_Type = _dataProvider.GetParameter();
padreSecond_Operator_Type.ParameterName = "Second_Operator_Type";
padreSecond_Operator_Type.DbType = DbType.Int32;
padreSecond_Operator_Type.Value = (object)entity.Second_Operator_Type ?? DBNull.Value;
var padreSecond_Operator_Value = _dataProvider.GetParameter();
padreSecond_Operator_Value.ParameterName = "Second_Operator_Value";
padreSecond_Operator_Value.DbType = DbType.String;
padreSecond_Operator_Value.Value = (object)entity.Second_Operator_Value ?? DBNull.Value;
//CAMBIOS MANUALES(padre Condition no estaba en la ejecucion)
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Conditions_Detail>("sp_InsSpartan_BR_Conditions_Detail", padreBusiness_Rule
, padreCondition_Operator
, padreFirst_Operator_Type
, padreFirst_Operator_Value
, padreCondition
, padreSecond_Operator_Type
, padreSecond_Operator_Value
).FirstOrDefault();
rta = Convert.ToInt32(empEntity.ConditionsDetailId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
