public int Insert(Spartane.Core.Classes.Spartan_BR_Modifications_Log.Spartan_BR_Modifications_Log 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 padreModification_Date = _dataProvider.GetParameter();
padreModification_Date.ParameterName = "Modification_Date";
padreModification_Date.DbType = DbType.DateTime;
padreModification_Date.Value = (object)entity.Modification_Date ?? DBNull.Value;
var padreModification_Hour = _dataProvider.GetParameter();
padreModification_Hour.ParameterName = "Modification_Hour";
padreModification_Hour.DbType = DbType.String;
padreModification_Hour.Value = (object)entity.Modification_Hour ?? DBNull.Value;
var padreModification_User = _dataProvider.GetParameter();
padreModification_User.ParameterName = "Modification_User";
padreModification_User.DbType = DbType.Int32;
padreModification_User.Value = (object)entity.Modification_User ?? DBNull.Value;
var padreComments = _dataProvider.GetParameter();
padreComments.ParameterName = "Comments";
padreComments.DbType = DbType.String;
padreComments.Value = (object)entity.Comments ?? 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_Modifications_Log>("sp_InsSpartan_BR_Modifications_Log", padreBusiness_Rule
, padreModification_Date
, padreModification_Hour
, padreModification_User
, padreComments
, padreImplementation_Code
).FirstOrDefault();
rta = Convert.ToInt32(empEntity.ModificationId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
public int Update(Spartane.Core.Classes.Spartan_BR_Modifications_Log.Spartan_BR_Modifications_Log entity)
{
int rta;
try
{
var paramUpdModificationId = _dataProvider.GetParameter();
paramUpdModificationId.ParameterName = "ModificationId";
paramUpdModificationId.DbType = DbType.Int32;
paramUpdModificationId.Value = entity.ModificationId;
var paramUpdBusiness_Rule = _dataProvider.GetParameter();
paramUpdBusiness_Rule.ParameterName = "Business_Rule";
paramUpdBusiness_Rule.DbType = DbType.Int32;
paramUpdBusiness_Rule.Value = entity.Business_Rule;
var paramUpdModification_Date = _dataProvider.GetParameter();
paramUpdModification_Date.ParameterName = "Modification_Date";
paramUpdModification_Date.DbType = DbType.DateTime;
if (entity.Modification_Date == null)
{
paramUpdModification_Date.Value = DBNull.Value;
}
else
{
paramUpdModification_Date.Value = entity.Modification_Date;
}
var paramUpdModification_Hour = _dataProvider.GetParameter();
paramUpdModification_Hour.ParameterName = "Modification_Hour";
paramUpdModification_Hour.DbType = DbType.String;
paramUpdModification_Hour.Value = entity.Modification_Hour;
var paramUpdModification_User = _dataProvider.GetParameter();
paramUpdModification_User.ParameterName = "Modification_User";
paramUpdModification_User.DbType = DbType.Int32;
if (entity.Modification_User == null)
{
paramUpdModification_User.Value = DBNull.Value;
}
else
{
paramUpdModification_User.Value = entity.Modification_User;
}
var paramUpdComments = _dataProvider.GetParameter();
paramUpdComments.ParameterName = "Comments";
paramUpdComments.DbType = DbType.String;
paramUpdComments.Value = entity.Comments;
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_Modifications_Log>("sp_UpdSpartan_BR_Modifications_Log", paramUpdModificationId, paramUpdBusiness_Rule, paramUpdModification_Date, paramUpdModification_Hour, paramUpdModification_User, paramUpdComments, paramUpdImplementation_Code).FirstOrDefault();
rta = Convert.ToInt32(empEntity.ModificationId);
}
catch (ExceptionBase ex)
{
throw ex;
}
catch (Exception ex)
{
throw new ServiceException(ex.Message, ex);
}
return(rta);
}
