public static int Insert(AuditoriaTipoInfo _AuditoriaTipoInfo)
{
//Execute the query and return the new Guid
object retval= _AdoHelper.ExecuteScalar(ConnectionString,"AuditoriaTipoInsert",
new SqlParameter("@Descripcion", _AuditoriaTipoInfo.Descripcion),
new SqlParameter("@DMS", _AuditoriaTipoInfo.DMS)
);
return Int32.Parse(retval.ToString());
}
public static void Update(AuditoriaTipoInfo _AuditoriaTipoInfo)
{
_AdoHelper.ExecuteNonQuery(ConnectionString,CommandType.StoredProcedure, "AuditoriaTipoUpdate",
new SqlParameter("@AuditoriaTipoId", _AuditoriaTipoInfo.AuditoriaTipoId),
new SqlParameter("@Descripcion", _AuditoriaTipoInfo.Descripcion),
new SqlParameter("@DMS", _AuditoriaTipoInfo.DMS)
);
}
public static void Delete(AuditoriaTipoInfo _AuditoriaTipoInfo)
{
_AdoHelper.ExecuteNonQuery(ConnectionString,CommandType.StoredProcedure, "AuditoriaTipoDelete",
new SqlParameter("@AuditoriaTipoId", _AuditoriaTipoInfo.AuditoriaTipoId)
);
}
/// <summary>
/// Creates a new instance of the AuditoriaTipo class and populates it with data from the specified SqlDataReader.
/// </summary>
private static AuditoriaTipoInfo MakeAuditoriaTipo(SqlDataReader dataReader)
{
AuditoriaTipoInfo auditoriaTipo = new AuditoriaTipoInfo();
if (dataReader.IsDBNull(AuditoriaTipoId) == false)
auditoriaTipo.AuditoriaTipoId = dataReader.GetInt32(AuditoriaTipoId);
if (dataReader.IsDBNull(Descripcion) == false)
auditoriaTipo.Descripcion = dataReader.GetString(Descripcion);
if (dataReader.IsDBNull(DMS) == false)
auditoriaTipo.DMS = dataReader.GetBoolean(DMS);
return auditoriaTipo;
}