public int Update(Spartane.Core.Classes.Spartan_Report_Advance_Filter.Spartan_Report_Advance_Filter entity)
{
int rta;
try
{
var paramUpdClave = _dataProvider.GetParameter();
paramUpdClave.ParameterName = "Clave";
paramUpdClave.DbType = DbType.Int32;
paramUpdClave.Value = (object)entity.Clave ?? DBNull.Value;
var paramUpdReport = _dataProvider.GetParameter();
paramUpdReport.ParameterName = "Report";
paramUpdReport.DbType = DbType.Int32;
paramUpdReport.Value = (object)entity.Report ?? DBNull.Value;
var paramUpdAttributeId = _dataProvider.GetParameter();
paramUpdAttributeId.ParameterName = "AttributeId";
paramUpdAttributeId.DbType = DbType.Int32;
paramUpdAttributeId.Value = (object)entity.AttributeId ?? DBNull.Value;
var paramUpdDefect_Value_From = _dataProvider.GetParameter();
paramUpdDefect_Value_From.ParameterName = "Defect_Value_From";
paramUpdDefect_Value_From.DbType = DbType.String;
paramUpdDefect_Value_From.Value = (object)entity.Defect_Value_From ?? DBNull.Value;
var paramUpdDefect_Value_To = _dataProvider.GetParameter();
paramUpdDefect_Value_To.ParameterName = "Defect_Value_To";
paramUpdDefect_Value_To.DbType = DbType.String;
paramUpdDefect_Value_To.Value = (object)entity.Defect_Value_To ?? DBNull.Value;
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_UpdSpartan_Report_Advance_Filter>("sp_UpdSpartan_Report_Advance_Filter", paramUpdClave, paramUpdReport, paramUpdAttributeId, paramUpdDefect_Value_From, paramUpdDefect_Value_To).FirstOrDefault();
rta = Convert.ToInt32(empEntity.Clave);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
public int Insert(Spartane.Core.Classes.Spartan_Report_Advance_Filter.Spartan_Report_Advance_Filter entity)
{
int rta;
try
{
var padreReport = _dataProvider.GetParameter();
padreReport.ParameterName = "Report";
padreReport.DbType = DbType.Int32;
padreReport.Value = (object)entity.Report ?? DBNull.Value;
var padreAttributeId = _dataProvider.GetParameter();
padreAttributeId.ParameterName = "AttributeId";
padreAttributeId.DbType = DbType.Int32;
padreAttributeId.Value = (object)entity.AttributeId ?? DBNull.Value;
var padreObjectId = _dataProvider.GetParameter();
padreObjectId.ParameterName = "ObjectId";
padreObjectId.DbType = DbType.Int32;
padreObjectId.Value = (object)entity.ObjectId ?? DBNull.Value;
var padreDefect_Value_From = _dataProvider.GetParameter();
padreDefect_Value_From.ParameterName = "Defect_Value_From";
padreDefect_Value_From.DbType = DbType.String;
padreDefect_Value_From.Value = (object)entity.Defect_Value_From ?? DBNull.Value;
var padreDefect_Value_To = _dataProvider.GetParameter();
padreDefect_Value_To.ParameterName = "Defect_Value_To";
padreDefect_Value_To.DbType = DbType.String;
padreDefect_Value_To.Value = (object)entity.Defect_Value_To ?? DBNull.Value;
var padrePathField = _dataProvider.GetParameter();
padrePathField.ParameterName = "PathField";
padrePathField.DbType = DbType.String;
padrePathField.Value = (object)entity.PathField ?? DBNull.Value;
var padreVisible = _dataProvider.GetParameter();
padreVisible.ParameterName = "Visible";
padreVisible.DbType = DbType.Boolean;
padreVisible.Value = (object)entity.Visible ?? DBNull.Value;
var empEntity =
_dbContext.ExecuteStoredProcedureList <Spartane.Core.Classes.StoredProcedure.sp_InsSpartan_Report_Advance_Filter>("sp_InsSpartan_Report_Advance_Filter"
, padreReport
, padreAttributeId
, padreDefect_Value_From
, padreDefect_Value_To
, padreObjectId
, padrePathField
, padreVisible
).FirstOrDefault();
rta = Convert.ToInt32(empEntity.Clave);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
