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