public int Update(Spartane.Core.Classes.Spartan_BR_Attribute_Restrictions_Detail.Spartan_BR_Attribute_Restrictions_Detail entity)
{
int rta;
try
{
var paramUpdRestrictionId = _dataProvider.GetParameter();
paramUpdRestrictionId.ParameterName = "RestrictionId";
paramUpdRestrictionId.DbType = DbType.Int32;
paramUpdRestrictionId.Value = entity.RestrictionId;
var paramUpdAction = _dataProvider.GetParameter();
paramUpdAction.ParameterName = "Action";
paramUpdAction.DbType = DbType.Int32;
paramUpdAction.Value = entity.Action;
var paramUpdAttribute_Type = _dataProvider.GetParameter();
paramUpdAttribute_Type.ParameterName = "Attribute_Type";
paramUpdAttribute_Type.DbType = DbType.Int32;
if (entity.Attribute_Type == null)
{
paramUpdAttribute_Type.Value = DBNull.Value;
}
else
{
paramUpdAttribute_Type.Value = entity.Attribute_Type;
}
var paramUpdControl_Type = _dataProvider.GetParameter();
paramUpdControl_Type.ParameterName = "Control_Type";
paramUpdControl_Type.DbType = DbType.Int16;
if (entity.Control_Type == null)
{
paramUpdControl_Type.Value = DBNull.Value;
}
else
{
paramUpdControl_Type.Value = entity.Control_Type;
}
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_BR_Attribute_Restrictions_Detail>("sp_UpdSpartan_BR_Attribute_Restrictions_Detail", paramUpdRestrictionId, paramUpdAction, paramUpdAttribute_Type, paramUpdControl_Type).FirstOrDefault();
rta = Convert.ToInt32(empEntity.RestrictionId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
public int Insert(Spartane.Core.Classes.Spartan_BR_Attribute_Restrictions_Detail.Spartan_BR_Attribute_Restrictions_Detail entity)
{
int rta;
try
{
var padreAction = _dataProvider.GetParameter();
padreAction.ParameterName = "Action";
padreAction.DbType = DbType.Int32;
padreAction.Value = (object)entity.Action ?? DBNull.Value;
var padreAttribute_Type = _dataProvider.GetParameter();
padreAttribute_Type.ParameterName = "Attribute_Type";
padreAttribute_Type.DbType = DbType.Int32;
padreAttribute_Type.Value = (object)entity.Attribute_Type ?? DBNull.Value;
var padreControl_Type = _dataProvider.GetParameter();
padreControl_Type.ParameterName = "Control_Type";
padreControl_Type.DbType = DbType.Int16;
padreControl_Type.Value = (object)entity.Control_Type ?? DBNull.Value;
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_BR_Attribute_Restrictions_Detail>("sp_InsSpartan_BR_Attribute_Restrictions_Detail", padreAction
, padreAttribute_Type
, padreControl_Type
).FirstOrDefault();
rta = Convert.ToInt32(empEntity.RestrictionId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
