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);
}
